On 2018-11-29 21:17:59, "Keith Medcalf" <kmedc...@dessus.com> wrote:
while I cannot comment on the "reverse_unordered_select" pragma, you are
getting the result you are because you are using union rather than union all.
The actual query didn't use a union and wasn't affected by the pragma
either (presumably for some other reason I'd have to puzzle out), so I
didn't realize my error. Thanks.
Probably not since this would break backwards compatibility. It is however
documented:
https://sqlite.org/lang_expr.html#subq
I've probably read that several times over the years and didn't recall
it when it was actually important. Once again, thanks. :)
--
J. King
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
