When compiling the amalgamation with #define SQLITE_DEFAULT_AUTOVACUUM 2
and creating an in-memory-DB, pragma auto_vacuum will return 0 (confirmed on 3.1.12, 3.1.17) Doing this in a disk DB, or after changing it at runtime (pragma auto_vacuum=N; VACUUM;), auto_vacuum will return the expected value. --- This is not an issue for me - and I'm not sure if auto_vacuum is even relevant for an in-memory-db, so a note in the documentation might be sufficient. Yet it did trigger a unit test (and it took me longer than I am willing to admit to find the cause). -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLITE-DEFAULT-AUTOVACUUM-not-preserved-for-in-memory-db-tp70571.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users