I have an application that uses SQLite 3.5.7. I have recently started seeing occasional SQLITE_SCHEMA errors being returned by sqlite3_exec() that I don't understand.
The application doesn't do ALTER TABLE. It creates the database file afresh on each run (it's created in a RAM file system). All connections are from the same application process, across several threads. I do have some long-living connections , on the order of hours, and there are some DROP TABLE IF EXISTS / CREATE TABLE calls in the application, although normally only at startup. Most changes to data are either via explicit UPDATEs or by INSERTs to tables that have an ON CONFLICT REPLACE in their CREATE TABLE definition. All transactions against the database are initiated with explicit BEGIN IMMEDIATEs. Under what circumstances could one expect to get SQLITE_SCHEMA back from sqlite3_exec()? Cheers, Dave _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
