> In SQLite version 3.0, when a schema change occurs, SQLite > automatically goes back to step 1, rereads the schema, and > tries again. So you should never get an SQLITE_SCHEMA error > in version 3.0. Back in version 2.8, you could get an > SQLITE_SCHEMA error in some circumstances. When you do, all > you have to do is retry the command and it should work. > > So to answer your questions: > > No, this is not a serious bug. You just need to be prepared to > reissue any SQL statement that returns SQLITE_SCHEMA. > > Yes, this issue is fixed in version 3.0. > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 >
This is not entirely correct IMHO. I can easily re-create an SQLITE_SCHEMA error in version 3.8. you just need two processes to do it: *. Open a database from one processs *. Do a select * from a table *. Open the same database from another process *. Create a new table from the second process *. Go back to the first process, and do a select * on the same table you used before. You will get an SQLITE_SCHEMA error, once. DRH, can you confirm this ? According to your description above , it should not happen.
