diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-04-28 21:31:16 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-04-28 21:31:16 +0000 |
| commit | c59d8dd44d34ea617296b4a2d6e22fefc74593ed (patch) | |
| tree | 786e89d2c217b9ed3628cfa09f61993101c48fd3 /src/backend/optimizer/plan/planner.c | |
| parent | 636edd553daafeaab775d0f4054ca02fa5240ad0 (diff) | |
| download | postgresql-c59d8dd44d34ea617296b4a2d6e22fefc74593ed.tar.gz | |
Improve pull_up_subqueries logic so that it doesn't insert unnecessary
PlaceHolderVar nodes in join quals appearing in or below the lowest
outer join that could null the subquery being pulled up. This improves
the planner's ability to recognize constant join quals, and probably
helps with detection of common sort keys (equivalence classes) as well.
Diffstat (limited to 'src/backend/optimizer/plan/planner.c')
| -rw-r--r-- | src/backend/optimizer/plan/planner.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c index bf1142aec0..7ad15d9da2 100644 --- a/src/backend/optimizer/plan/planner.c +++ b/src/backend/optimizer/plan/planner.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.254 2009/04/19 19:46:33 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.255 2009/04/28 21:31:16 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -324,7 +324,7 @@ subquery_planner(PlannerGlobal *glob, Query *parse, * this query. */ parse->jointree = (FromExpr *) - pull_up_subqueries(root, (Node *) parse->jointree, false, false); + pull_up_subqueries(root, (Node *) parse->jointree, NULL, NULL); /* * Detect whether any rangetable entries are RTE_JOIN kind; if not, we can |