Re: [sqlite] bug: "no such column" with UNION + subquery + GROUP BY + ORDER BY + COLLATE

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

Re: [sqlite] bug: "no such column" with UNION + subquery + GROUP BY + ORDER BY + COLLATE

sers- >boun...@sqlite.org] On Behalf Of RSmith >Sent: Saturday, 8 November, 2014 06:01 >To: General Discussion of SQLite Database >Subject: Re: [sqlite] bug: "no such column" with UNION + subquery + GROUP >BY + ORDER BY + COLLATE > > >On 2014/11/08 14:21, Clemens La

Re: [sqlite] bug: "no such column" with UNION + subquery + GROUP BY + ORDER BY + COLLATE

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] bug: "no such column" with UNION + subquery + GROUP BY + ORDER BY + COLLATE

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: