From 36e24e8d17b72204568ff7df8fce51adf31dc024 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 16 Feb 2007 03:49:10 +0000 Subject: Fix another problem in 8.2 changes that allowed "one-time" qual conditions to be checked at plan levels below the top; namely, we have to allow for Result nodes inserted just above a nestloop inner indexscan. Should think about using the general Param mechanism to pass down outer-relation variables, but for the moment we need a back-patchable solution. Per report from Phil Frost. --- src/backend/optimizer/plan/setrefs.c | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'src/backend/optimizer/plan/setrefs.c') diff --git a/src/backend/optimizer/plan/setrefs.c b/src/backend/optimizer/plan/setrefs.c index 298c8d1cff6..4fd3546368e 100644 --- a/src/backend/optimizer/plan/setrefs.c +++ b/src/backend/optimizer/plan/setrefs.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/setrefs.c,v 1.126 2006/10/04 00:29:54 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/setrefs.c,v 1.126.2.1 2007/02/16 03:49:10 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -937,6 +937,14 @@ set_inner_join_references(Plan *inner_plan, indexed_tlist *outer_itlist) outer_itlist); } } + else if (IsA(inner_plan, Result)) + { + /* Recurse through a gating Result node (similar to Append case) */ + Result *result = (Result *) inner_plan; + + if (result->plan.lefttree) + set_inner_join_references(result->plan.lefttree, outer_itlist); + } else if (IsA(inner_plan, TidScan)) { TidScan *innerscan = (TidScan *) inner_plan; -- cgit v1.2.3