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
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
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
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:
4 matches
Mail list logo