diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-06-15 22:51:45 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-06-15 22:51:45 +0000 |
| commit | cb02610e503957d7ed9b4375537fb6275c16f1fa (patch) | |
| tree | 540391048748403dc597c35b4cb662d2d4cc3494 /src/backend/optimizer/util/pathnode.c | |
| parent | 3fb6f1347ffbfcbba48b37ea35925f6b19821bf6 (diff) | |
| download | postgresql-cb02610e503957d7ed9b4375537fb6275c16f1fa.tar.gz postgresql-cb02610e503957d7ed9b4375537fb6275c16f1fa.zip | |
Adjust nestloop-with-inner-indexscan plan generation so that we catch
some cases of redundant clauses that were formerly not caught. We have
to special-case this because the clauses involved never get attached to
the same join restrictlist and so the existing logic does not notice
that they are redundant.
Diffstat (limited to 'src/backend/optimizer/util/pathnode.c')
| -rw-r--r-- | src/backend/optimizer/util/pathnode.c | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/backend/optimizer/util/pathnode.c b/src/backend/optimizer/util/pathnode.c index 25648beed19..da9497d58a4 100644 --- a/src/backend/optimizer/util/pathnode.c +++ b/src/backend/optimizer/util/pathnode.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/optimizer/util/pathnode.c,v 1.89 2003/05/26 00:11:27 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/optimizer/util/pathnode.c,v 1.90 2003/06/15 22:51:45 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -362,6 +362,9 @@ create_index_path(Query *root, pathnode->indexinfo = makeList1(index); pathnode->indexqual = makeList1(indexquals); + /* It's not an innerjoin path. */ + pathnode->indexjoinclauses = NIL; + pathnode->indexscandir = indexscandir; /* |