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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
