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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
