On 2015-04-11 06:12 PM, Simon Slavin wrote: > On 11 Apr 2015, at 4:13pm, Keith Medcalf <kmedcalf at dessus.com> wrote: > >> Interestingly if you run analyze, it works properly ... > Oh my. I don't like the idea that ANALYZE changes the result set. > > Simon.
Yes, that would be worrisome... but not to worry, the bug is in the index usage and analyze probably coaxed it into using another index that works - so not an ANALYZE bug. It's already checked in and getting fixed at: http://www.sqlite.org/src/info/e3b1f625518edc0e
