commit fccda8a162b99c9419c6bccad4d88459a4c2dc81
author drh <drh@noemail.net> Wed May 27 13:06:55 2015 +0000
committer drh <drh@noemail.net> Wed May 27 13:06:55 2015 +0000
tree 68d54c7bc36171a5e9f72fc8bb1f8c552e9d48e5
parent b95e1193d58be876cffb061424aae2e13115c338

CTEs have never add working rowids.  So disallow the use of the "rowid" column
within CTEs.

FossilOrigin-Name: 0055df0445932a43e42b318ef88672dcbe312c3a

src/resolve.c

diff --git a/src/resolve.c b/src/resolve.c
index 23636ea..27eba9f 100644
--- a/src/resolve.c
+++ b/src/resolve.c
@@ -358,7 +358,7 @@
             break;
           }
         }
-        if( iCol>=pTab->nCol && sqlite3IsRowid(zCol) && HasRowid(pTab) ){
+        if( iCol>=pTab->nCol && sqlite3IsRowid(zCol) && VisibleRowid(pTab) ){
           /* IMP: R-51414-32910 */
           /* IMP: R-44911-55124 */
           iCol = -1;
@@ -388,7 +388,7 @@
     ** Perhaps the name is a reference to the ROWID
     */
     if( cnt==0 && cntTab==1 && pMatch && sqlite3IsRowid(zCol)
-     && HasRowid(pMatch->pTab) ){
+     && VisibleRowid(pMatch->pTab) ){
       cnt = 1;
       pExpr->iColumn = -1;     /* IMP: R-44911-55124 */
       pExpr->affinity = SQLITE_AFF_INTEGER;