foreach(lc,parsetree->cteList)

{

sub_action->cteList=list_concat(sub_action->cteList,

copyObject(parsetree->cteList));

sub_action->hasRecursive |=parsetree->hasRecursive;

sub_action->hasModifyingCTE |=parsetree->hasModifyingCTE;

}

3

(3 rows)

-- silly example to verify that hasModifyingCTE flag is propagated

CREATE TEMP TABLE bug6051_3 AS

select a from generate_series(11,13) as a;

CREATE RULE bug6051_3_ins AS ON INSERT TO bug6051_3 DO INSTEAD

SELECT i FROM bug6051_2;

BEGIN; SET LOCAL force_parallel_mode = on;

WITH t1 AS ( DELETE FROM bug6051_3 RETURNING * )

INSERT INTO bug6051_3 SELECT * FROM t1;

i

---

1

2

3

1

2

3

1

2

3

(9 rows)

COMMIT;

SELECT * FROM bug6051_3;

a

---

(0 rows)

-- a truly recursive CTE in the same list

WITH RECURSIVE t(a) AS (

SELECT 0

SELECT*FROM bug6051;

SELECT*FROM bug6051_2;

CREATE TEMP TABLE bug6051_3AS

select afrom generate_series(11,13)as a;

CREATERULEbug6051_3_insASON INSERT TO bug6051_3 DO INSTEAD

SELECT iFROM bug6051_2;

BEGIN;SET LOCAL force_parallel_mode=on;

WITH t1AS (DELETEFROM bug6051_3 RETURNING* )

INSERT INTO bug6051_3SELECT*FROM t1;

COMMIT;

SELECT*FROM bug6051_3;

WITH RECURSIVE t(a)AS (