Hi,
using SQLite 3.18.0, x86 (and x64), on Windows 10 x64 (using the
precompiled tools from https://www.sqlite.org/download.html -- issue
appears when building from source as well):
E:\DL\sqlite-tools-win32-x86-3180000> .\sqlite3.exe
SQLite version 3.18.0 2017-03-28 18:48:43
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> VACUUM;
sqlite> PRAGMA optimize;
Error: database schema has changed
Notice that VACUUM; ANALYZE; works, as well as PRAGMA optimize; VACUUM;
Given that PRAGMA optimize only calls ANALYZE as of 3.18 on tables that
might benefit, I'd expect it to behave the same as an ANALYZE call --
i.e. either both should return an error, or both should pass.
Is this a bug, or is this intended behavior?
Cheers,
Matthäus
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
