commit 1db95106ee48da9743f2d64bf1fdf7ba6d1442ed
author dan <dan@noemail.net> Mon Jun 28 10:15:19 2010 +0000
committer dan <dan@noemail.net> Mon Jun 28 10:15:19 2010 +0000
tree 7b19ee3eceab2e088cd7d02792dad180c8965db1
parent 7750ab48f55204c274ebf7ca5422b5397b2ef3de

Currently, if SQLite cannot find a table or index referred to by a query, it reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.).

FossilOrigin-Name: 4932f22848b3d15a2b6dc5fa2cd69ce19182e2a4

src/build.c

diff --git a/src/build.c b/src/build.c
index 4c00e39..ce3e614 100644
--- a/src/build.c
+++ b/src/build.c
@@ -2614,6 +2614,7 @@
     if( j>=pTab->nCol ){
       sqlite3ErrorMsg(pParse, "table %s has no column named %s",
         pTab->zName, zColName);
+      pParse->checkSchema = 1;
       goto exit_create_index;
     }
     pIndex->aiColumn[i] = j;

src/insert.c

diff --git a/src/insert.c b/src/insert.c
index 05964f8..f6ad5ab 100644
--- a/src/insert.c
+++ b/src/insert.c
@@ -727,7 +727,7 @@
         }else{
           sqlite3ErrorMsg(pParse, "table %S has no column named %s",
               pTabList, 0, pColumn->a[i].zName);
-          pParse->nErr++;
+          pParse->checkSchema = 1;
           goto insert_cleanup;
         }
       }

src/resolve.c

diff --git a/src/resolve.c b/src/resolve.c
index 4e94827..74d6aae 100644
--- a/src/resolve.c
+++ b/src/resolve.c
@@ -357,6 +357,7 @@
     }else{
       sqlite3ErrorMsg(pParse, "%s: %s", zErr, zCol);
     }
+    pParse->checkSchema = 1;
     pTopNC->nErr++;
   }
 

src/select.c

diff --git a/src/select.c b/src/select.c
index 9a01603..b03e506 100644
--- a/src/select.c
+++ b/src/select.c
@@ -3020,6 +3020,7 @@
     );
     if( !pIdx ){
       sqlite3ErrorMsg(pParse, "no such index: %s", zIndex, 0);
+      pParse->checkSchema = 1;
       return SQLITE_ERROR;
     }
     pFrom->pIndex = pIdx;

src/trigger.c

diff --git a/src/trigger.c b/src/trigger.c
index 66464bd..27fc708 100644
--- a/src/trigger.c
+++ b/src/trigger.c
@@ -496,6 +496,7 @@
     if( !noErr ){
       sqlite3ErrorMsg(pParse, "no such trigger: %S", pName, 0);
     }
+    pParse->checkSchema = 1;
     goto drop_trigger_cleanup;
   }
   sqlite3DropTriggerPtr(pParse, pTrigger);

src/update.c

diff --git a/src/update.c b/src/update.c
index 3c82c27..fe8344c 100644
--- a/src/update.c
+++ b/src/update.c
@@ -212,6 +212,7 @@
         pRowidExpr = pChanges->a[i].pExpr;
       }else{
         sqlite3ErrorMsg(pParse, "no such column: %s", pChanges->a[i].zName);
+        pParse->checkSchema = 1;
         goto update_cleanup;
       }
     }