Re: [sqlite] Bug: LSM1 lsm1BestIndex() always chooses table scan

2019-08-17 Thread Richard Hipp
On 8/16/19, James Kafader wrote: > > We think, after trying out a fix that line 845 of lsm_vtab.c contains a > bug. This line > for(i=0; inConstraint && idxNum<16; i++, pConstraint++){ > should perhaps be replaced by this line: >for(i=0; inConstraint && idxNum>16; i++, pConstraint++){ >

[sqlite] Bug: LSM1 lsm1BestIndex() always chooses table scan

2019-08-16 Thread James Kafader
Hi SQLite devs, I'd like to begin with a "thank you" for a great tool that we use every day at Internet Archive. We are currently considering SQLite's LSM engine (we are aware it is not considered production quality) to implement a index server process that will underpin the Wayback Machine's