So by design then. Alright, thanks. Guess its plan B with user_schema. On Tue, Sep 6, 2016 at 8:04 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Stephen Chrzanowski wrote: > > [...] I'm relying on the results from "pragma > > schema_version". I've noticed that this bumps up every time I run a > vacuum > > or use the backup API against the database. Is this supposed to happen? > > The documentation says that the schema version > | is incremented by SQLite whenever the database schema is modified (by > | creating or dropping a table or index). The schema version is used by > | SQLite each time a query is executed to ensure that the internal cache > | of the schema used when compiling the SQL query matches the schema of > | the database against which the compiled query is actually executed. > > Inside a compiled statement, tables and indexes are identified by their > root page number. When running VACUUM, this is likely to change. > > The backup code has this comment: > /* Update the schema version field in the destination database. This > ** is to make sure that the schema-version really does change in > ** the case where the source and destination databases have the > ** same schema version. > */ > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users