diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-08-17 02:19:19 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-08-17 02:19:19 +0000 |
| commit | f2689e421d7ca0a103e33f5b92bb0676c80e1d04 (patch) | |
| tree | f78f91f14b18aa81bf8c767ee30fe2486ca0f0ad | |
| parent | 19e34b62395b36513a8e6c35ddfbeef12dd1e89f (diff) | |
| download | postgresql-f2689e421d7ca0a103e33f5b92bb0676c80e1d04.tar.gz postgresql-f2689e421d7ca0a103e33f5b92bb0676c80e1d04.zip | |
Remove prohibition against SubLinks in the WHERE clause of an EXISTS subquery
that we're considering pulling up. I hadn't wanted to think through whether
that could work during the first pass at this stuff. However, on closer
inspection it seems to be safe enough.
| -rw-r--r-- | src/backend/optimizer/plan/subselect.c | 10 |
1 files changed, 1 insertions, 9 deletions
diff --git a/src/backend/optimizer/plan/subselect.c b/src/backend/optimizer/plan/subselect.c index d4374516ac8..9eaeaedc68f 100644 --- a/src/backend/optimizer/plan/subselect.c +++ b/src/backend/optimizer/plan/subselect.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/subselect.c,v 1.134 2008/08/17 01:20:00 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/subselect.c,v 1.135 2008/08/17 02:19:19 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -970,14 +970,6 @@ convert_EXISTS_sublink_to_join(PlannerInfo *root, SubLink *sublink, return false; /* - * Also disallow SubLinks within the WHERE clause. (XXX this could - * probably be supported, but it would complicate the transformation - * below, and it doesn't seem worth worrying about in a first pass.) - */ - if (contain_subplans(whereClause)) - return false; - - /* * Prepare to pull up the sub-select into top range table. * * We rely here on the assumption that the outer query has no references |