Hi,
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
originally reported by Michael Geier here:
On 2014/11/08 14:21, Clemens Ladisch wrote:
Hi,
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
Will call the above Version A.
I don't see how that can
sqlite select 1 union select 1 from (select 1 as x) group by x order by 1
collate binary;
Error: no such column: x
sqlite select 1 from (select 1 as x) group by x;
1
sqlite select 1 from (select 1 as x) group by x order by 1;
1
sqlite select 1 from (select 1 as x) group by x order by 1
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