On Tue, Oct 28, 2014 at 1:43 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Oct 2014, at 7:33pm, James Earl <ja...@truckhardware.ca> wrote: > >> After upgrading from SQLite 3.8.6 to 3.8.7, I am no longer able to >> order group_concat values by using a subselect. > > Sorry, but as the documentation says > > <https://www.sqlite.org/lang_aggfunc.html> > > "The order of the concatenated elements is arbitrary." > > I think the change you're seeing is the result of improved optimisation in > 3.8.7. It might be possible to get the order you want by changing the > phrasing of your query from a sub-select to JOIN, but it's already > complicated and I can't figure out the right phrasing right now.
Thank you Simon. It was a nice hack while it worked! I don't mind doing things differently. James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
