ORA-32044 in recursive CTE with cross join clause
I have recursive CTE. There is a cross join in recursive part of query. Cross-joined table is dummy unnecessary table with single row without any influence on query result. The point is, if cross join clause is used, query fails on "ORA-32044: cycle detected while executing recursive WITH query" error.
with r (v) as (
select 1 as v from dual
union all
select v + 1 from r cross join dual where v < 5
)
select * from r;
If simple comma separation is used, query succeeds.
with r (v) as (
select 1 as v from dual
union all
select v + 1 from r,dual where v < 5
)
select * from r;