diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-12-06 16:50:55 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-12-06 16:50:55 +0000 |
| commit | 7563a16b116603db2c986b04883e18af6dda2be2 (patch) | |
| tree | 081dd3c2fa3ed1767daec7c7b15983fe48506812 /src | |
| parent | 81788719b9f24e58960665230c68bde36e098e03 (diff) | |
| download | postgresql-7563a16b116603db2c986b04883e18af6dda2be2.tar.gz postgresql-7563a16b116603db2c986b04883e18af6dda2be2.zip | |
In a nestloop inner indexscan, it's OK to use pushed-down baserestrictinfo
clauses even if it's an outer join. This is a corner case since such
clauses could only arise from weird OUTER JOIN ON conditions, but worth
fixing. Per example from Ron at cheapcomplexdevices.com.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/optimizer/path/indxpath.c | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/src/backend/optimizer/path/indxpath.c b/src/backend/optimizer/path/indxpath.c index 5680cbbc6e3..dc26fc40cac 100644 --- a/src/backend/optimizer/path/indxpath.c +++ b/src/backend/optimizer/path/indxpath.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/path/indxpath.c,v 1.167.4.2 2005/04/20 21:48:12 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/path/indxpath.c,v 1.167.4.3 2005/12/06 16:50:55 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -332,10 +332,6 @@ group_clauses_by_indexkey_for_join(Query *root, { RestrictInfo *rinfo = (RestrictInfo *) lfirst(l); - /* Can't use pushed-down clauses in outer join */ - if (isouterjoin && rinfo->is_pushed_down) - continue; - if (match_clause_to_indexcol(rel, index, indexcol, |