Have recompiled and indeed this makes both statements run at the same fast speed. I can also see that the both Explain now produce near enough the same. So it looks this has fixed it. I can see now that this could affect query speed not only in unrealistic testing situations, so this looks a useful fix.
RBS On Wed, Jan 4, 2017 at 1:09 AM, Richard Hipp <[email protected]> wrote: > On 1/3/17, Richard Hipp <[email protected]> wrote: > > On 1/3/17, Richard Hipp <[email protected]> wrote: > >> On 1/3/17, Bart Smissaert <[email protected]> wrote: > >>> > >>> Firstly, is this a bug? > >> > >> No. A "bug" means it gets the wrong answer. In this case, it gets > >> the correct answer, just more slowly than you would like. That means > >> this is an optimization opportunity. > >> > >> Thanks for bringing it to my attention. > > > > Please experiment with this version of SQLite: > > https://www.sqlite.org/src/info/acdb8f6f10953ed4 > > Wrong version. Sorry. Should have been > https://www.sqlite.org/src/info/62e9270a8057d758 > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
