Simple SELECT misbehaving in Sqlite 3.8.3 with ENABLE_STAT3

2014-02-10 Thread Bert Huijben
Hi, As part of the Subversion 1.8.6 release we tried introducing some data in the 'sqlitstat_stat1' table using the recommended approach for Sqlite 3.8.0+ compatibility to tell sqlite about our 'bad indexes': [[ ANALYZE sqlite_master; INSERT INTO "sqlite_stat1" VALUES INSERT INTO "sqlite

Re: Regresson on trunk with SQLite 3.8 [was: Re: 1.8.6 up for testing/signing]

2014-02-10 Thread Ben Reser
On 2/9/14, 10:58 PM, Branko Čibej wrote: >> I just wonder when we started to rely on a particular query plan. > > It turns out to be more complex than that. I started bisecting to find the > revision that broke trunk, and found that in r1542765, op-depth-test changed > its failure mode from, e.g.,