On 3/5/15, Mike Nicolino <mike.nicolino at centrify.com> wrote: > Incidentally, this used to 'work' in a much older version of SQLite, though > the semantics may not have been correct in all cases. Version 3.7.7.1, > ended up transforming like to of pair of constraints in the "like 'a%'" case > which were passed to BestIndex. >
That was a bug - it could lead to incorrect answers depending on the virtual table and its content. The bug was fixed on 2012-03-29. https://www.sqlite.org/src/timeline?c=2012-03-29+14:29:07 -- D. Richard Hipp drh at sqlite.org
