bug: Recursive CTE must contain a UNION(ALL) query

[wubx]

Search before asking

• I had searched in the issues and found no similar issues.

Version

main

What's Wrong?

WITH RECURSIVE t(n) as (   select 1    union all    select n+1 from t where n<10 ), cte1(c1) as (   select 'abc' ) select  n, c1  from t,cte1;

error: APIError: ResponseError with 1005: Recursive CTE must contain a UNION(ALL) query

WITH RECURSIVE t(n) as (
  select 1
  union all
  select n+1 from t where n<10
),
cte1 as (
  select number  from numbers(10)
)
select n, cet1.nubmer  from t join cte1 where t.n=cte1.number;

error: APIError: ResponseError with 1005: Recursive CTE must contain a UNION(ALL) query

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!