RSmith wrote: > On 2014/11/08 14:21, Clemens Ladisch wrote: >> the following query fails to parse, although it should be valid: >> >> sqlite> select 1 union select 1 from (select 1 as x) group by x order by >> 1 collate binary; >> Error: no such column: x > > I don't see how that can ever be valid
SQLite thinks it's valid if the "union" is replaced with "union all", or without the collation. > Not a bug I think. I forgot to mention explicitly that this is a regression. (It worked with 3.7.11, and some app is using this.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
