From cb02610e503957d7ed9b4375537fb6275c16f1fa Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 15 Jun 2003 22:51:45 +0000 Subject: 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. --- src/backend/optimizer/util/pathnode.c | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'src/backend/optimizer/util/pathnode.c') 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; /* -- cgit v1.2.3