Hi When performing some testing I noticed that SQLite was not enforcing the max_page_count pragma. Using the test case below is appears SQLite is not remembering the max_page_count across closing and opening a database file. Instead of the expected 12800 from PRAGMA max_page_count; I got 1073741823.
Is anyone else affected by this? Environment: Ubuntu Linux 10.04 SQLite shell 3.7.6.3 downloaded from SQlite.org The following is copy-n-paste from the command line rm page_count_test.db rm: cannot remove `page_count_test.db': No such file or directory ./sqlite3 page_count_test.db SQLite version 3.7.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" PRAGMA encoding = "UTF-8"; PRAGMA legacy_file_format = off; PRAGMA auto_vacuum = 0; PRAGMA page_size = 4096; PRAGMA max_page_count = 12800; 12800 sqlite> PRAGMA journal_mode = WAL; wal sqlite> PRAGMA user_version = 20; sqlite> sqlite> sqlite> PRAGMA page_size; 4096 sqlite> PRAGMA max_page_count; 12800 sqlite> .quit ./sqlite3 page_count_test.db SQLite version 3.7.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA page_size; 4096 sqlite> PRAGMA max_page_count; 1073741823 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
