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: cteAll 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
