Mark Lawrence wrote: > I'm hitting an issue with ordering and GROUP_CONCAT that seems to > depend on whether the reverse_unordered_selects pragma is enabled, > and/or non-aggregate terms are also selected. > > reverse_unordered_select with non-agg result > ------------------------ ------------ ------ > ON No Bad > OFF No Good > ON Yes Good > OFF Yes Good > > The attached file should show some details.
The result is correct in all four cases. <http://www.sqlite.org/lang_aggfunc.html#groupconcat> says: | The order of the concatenated elements is arbitrary. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
