On 2 Feb 2019, at 10:19pm, Gerlando Falauto <gerlando.fala...@gmail.com> wrote:
> Results should be naturally ordered by source1, source2,ts. [Sorry, I missed this the first time. Thanks, Tim.] Sorry, no. You're making assumptions about how SQLite works internally. If you want your results sorted, ask for them sorted. If you don't, don't. Note that if you don't ask for them sorted and they come out sorted by good luck, there's no guarantee that they'll be sorted if you put different data in the table, or the same data with the rows in a different order, or if you update to a later version of SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
