I am fully aware of this and I have no problem at all with this behaviour. I just wondered why it choose the particular plan in this situation. There is no criticism, just curiosity.
RBS On Thu, Jan 12, 2017 at 12:45 AM, Richard Hipp <d...@sqlite.org> wrote: > On 1/11/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > > > The result is that the output is descending on DOB. > > I expected and preferred if the output was ascending on rowid. > > If you omit the ORDER BY clause, then the SQL database engine (*any* > engine, not just SQLite) is free to return the rows in whatever random > order it chooses. And it does not need to explain itself when it > does. :-) > > If you expect and/or prefer the output to be in order of ascending > rowid, then add > > ORDER BY rowid ASC > > to the end of the query. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
