Re: [sqlite] CTEs and unions

[Andy Goth]

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

sqlite> with cte(a) as (select 1)
    ...> select * from cte;
a
1

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

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

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

All these queries work for me without error.

--
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