Re: [sqlite] CTEs and unions

[Andy Goth]

On 4/22/2014 5:55 PM, Andy Goth wrote:

On 4/22/2014 5:16 PM, Dominique Devienne wrote:

sqlite> with cte(a) as (select 1)
    ...> select * from cte
    ...> union all
    ...> select * from cte;
Error: no such table: cte

All these queries work for me without error.

http://www.sqlite.org/cgi/src/info/67bfd59d9087a987

This commit fixed your problem, which was written up here:

http://www.sqlite.org/cgi/src/info/31a19d11b97088296a

Try upgrading to 3.8.4 or newer.

--
Andy Goth | <andrew.m.goth/at/gmail/dot/com>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users