On 18/02/2016 21:55, Stephan Beal wrote: > On Thu, Feb 18, 2016 at 10:42 PM, Stephan Beal <sgbeal-gM/Ye1E23mwN+BqQ9rBEUg > at public.gmane.org> > wrote: > >> Here we go: >> >> http://fossil.wanderinghorse.net/download/cal.sql >> > > sorry, one more: it was just updated with minor doc improvements and better > syntax conformance (i had used a lot of double-quotes simply out of recent > scripting habit). > > Excellent CTE query, thanks, but one question: the query uses group_concat() and the documentation says 'The order of the concatenated elements is arbitrary.'
Would it not be better if Sqlite guaranteed that group_concat() respected the order by clause, if one exists. I think the alternative, if group_concat does not/will not support this, would be to create yet another CTE to replicate group_concat() functionality that does, although that would introduce additional complexity and it would of course be better if the Sqlite gave guarantees about this function's behaviour instead. Thanks, K
