> On Aug 15, 2017, at 8:12 AM, Bob Friesenhahn <[email protected]> > wrote: > > Notice that adding a 'where' clause has caused the order to be reversed from > what was requested in the query. Why is this and what can I do to correct it?
It’s actually not reversed; the ordering looks random. So it appears the ORDER BY wasn’t applied. Huh. … Actually, the docs for group_concat do say "The order of the concatenated elements is arbitrary.” :-/ —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
