> 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. > Try upgrading to 3.8.4 or newer.
Thanks. I was using SQLite version 3.8.3.1 2014-02-11 14:52:19 indeed. I'll upgrade now. --DD _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
