[sqlite] Bug: #if SQLITE_HAS_CODEC warning

Hi, 3.6.23.1's amalgamated sqlite.h include a prototype for sqlite3_key() if SQLITE_HAS_CODEC is defined. This test is currently done with "#if SQLITE_HAS_CODEC", which triggers a warning from gcc -Wundef if this macro isn't declared via a precompiled header/command line flag/etc. Most of the o

[sqlite] Crash in Rtree

Hi, I think I have run into a crashing bug in the Rtree module, triggered by changing the database page size. The summary is that I create a database with an Rtree, populate it with data, change the page size, and then crash when querying the Rtree. The sequence is: - Database is created, p

Re: [sqlite] Data loss after vacuum

chen jia wrote: > Before I ran vacuum, I ran pragma integrity_check; and got > sqlite> pragma integrity_check; > ok > > After I ran vacuum, I ran pragma integrity_check; again and got > sqlite> pragma integrity_check; > *** in database main *** > On tree page 15 cell 36: Child page depth differs

[sqlite] Vacuum corruption

Hi, Are there any circumstances in which a vacuum could corrupt a database? I am storing about 30 images in an SQLite database, where each row contains a couple of integers and a BLOB of data (average size 80Kb). There are a some indices on the integer columns, and the final database is aro