> On Aug 15, 2017, at 12:22 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > Well, the documentation is incorrect. The ordering is entirely > deterministic. The items presented to the aggregate are concatenated in the > order in which they are presented to the aggregate function, and this > ordering is determined solely by the traversal order of the underlying table > from which the data is drawn.
…which is arbitrary, from the POV of a client of SQLite. The documentation warns against making assumptions about unordered table traversal, and even offers "pragma reverse_unordered_selects” to deliberately perturb it, to flush out code that might be relying on consistent ordering. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
