Commite543fef

committed

pathman: handle CTE subqueries

1 parentab50daa commite543fefCopy full SHA for e543fef

File tree

+10

-0

lines changed

+10

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -187,6 +187,7 @@ PlannedStmt *`
`187`	`187`	`pathman_planner_hook(Query*parse,intcursorOptions,ParamListInfoboundParams)`
`188`	`188`	`{`
`189`	`189`	`PlannedStmt*result;`
	`190`	`+ListCell*lc;`
`190`	`191`
`191`	`192`	`if (initialization_needed)`
`192`	`193`	`{`
`@@ -196,6 +197,15 @@ pathman_planner_hook(Query *parse, int cursorOptions, ParamListInfo boundParams)`
`196`	`197`	`inheritance_disabled= false;`
`197`	`198`	`disable_inheritance(parse);`
`198`	`199`
	`200`	`+/* If query contains CTE (WITH statement) then handle subqueries too */`
	`201`	`+foreach(lc,parse->cteList)`
	`202`	`+{`
	`203`	`+CommonTableExprcte= (CommonTableExpr)lfirst(lc);`
	`204`	`+`
	`205`	`+if (IsA(cte->ctequery,Query))`
	`206`	`+disable_inheritance((Query*)cte->ctequery);`
	`207`	`+}`
	`208`	`+`
`199`	`209`	`/* Invoke original hook */`
`200`	`210`	`if (planner_hook_original)`
`201`	`211`	`result=planner_hook_original(parse,cursorOptions,boundParams);`

Comments

(0)