diff options
| author | drh <drh@noemail.net> | 2015-05-27 13:06:55 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2015-05-27 13:06:55 +0000 |
| commit | fccda8a162b99c9419c6bccad4d88459a4c2dc81 (patch) | |
| tree | 68d54c7bc36171a5e9f72fc8bb1f8c552e9d48e5 /src/select.c | |
| parent | b95e1193d58be876cffb061424aae2e13115c338 (diff) | |
| download | sqlite-fccda8a162b99c9419c6bccad4d88459a4c2dc81.tar.gz sqlite-fccda8a162b99c9419c6bccad4d88459a4c2dc81.zip | |
CTEs have never add working rowids. So disallow the use of the "rowid" column
within CTEs.
FossilOrigin-Name: 0055df0445932a43e42b318ef88672dcbe312c3a
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/select.c b/src/select.c index 5626bb070..ad9571920 100644 --- a/src/select.c +++ b/src/select.c @@ -3991,7 +3991,7 @@ static int withExpand( pTab->zName = sqlite3DbStrDup(db, pCte->zName); pTab->iPKey = -1; pTab->nRowLogEst = 200; assert( 200==sqlite3LogEst(1048576) ); - pTab->tabFlags |= TF_Ephemeral; + pTab->tabFlags |= TF_Ephemeral | TF_NoVisibleRowid; pFrom->pSelect = sqlite3SelectDup(db, pCte->pSelect, 0); if( db->mallocFailed ) return SQLITE_NOMEM; assert( pFrom->pSelect ); |