-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.4, 10.5, 10.6
-
Component/s: Optimizer - CTE
-
Labels:None
Processing of a query containing at least two references to the same CTE that uses an embedded recursive CTE causes a crash of the server in 10.4+.
Here's a simple test case that demonstrates this problem.
create table t1 (a int); |
insert into t1 values (5), (7); |
with cte_e as ( |
with recursive cte_r as ( |
select a from t1 union select a+1 as a from cte_r r where a < 10 |
) select * from cte_r |
) select * from cte_e s1, cte_e s2 where s1.a=s2.a; |
- relates to
-
-
- Closed
-
-
-
- Closed
-