diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-07-13 05:47:29 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-07-13 05:47:29 +0000 |
| commit | 9191d684a7dad1bba82427b760ff61912df1d7d0 (patch) | |
| tree | 5a9e921d82dde6ceea3b6dd7b8b97cd736977edc | |
| parent | cb292206c5c160cde6eb5618de64f810e62f378a (diff) | |
| download | postgresql-9191d684a7dad1bba82427b760ff61912df1d7d0.tar.gz postgresql-9191d684a7dad1bba82427b760ff61912df1d7d0.zip | |
Planner did the wrong thing with index-scan-backward plans: generated
them, but forgot to attach relevant restriction clauses, so that the
plan represented a scan over the whole table with restrictions applied
as qpquals not indexquals. Another day, another bug...
| -rw-r--r-- | src/backend/optimizer/path/indxpath.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/optimizer/path/indxpath.c b/src/backend/optimizer/path/indxpath.c index 7b87555df09..0ea1971710e 100644 --- a/src/backend/optimizer/path/indxpath.c +++ b/src/backend/optimizer/path/indxpath.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.86 2000/07/05 23:11:22 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.87 2000/07/13 05:47:29 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -195,7 +195,7 @@ create_index_paths(Query *root, useful_for_ordering(root, rel, index, ForwardScanDirection)) add_path(rel, (Path *) create_index_path(root, rel, index, - NIL, + restrictclauses, ForwardScanDirection)); } @@ -207,7 +207,7 @@ create_index_paths(Query *root, if (useful_for_ordering(root, rel, index, BackwardScanDirection)) add_path(rel, (Path *) create_index_path(root, rel, index, - NIL, + restrictclauses, BackwardScanDirection)); /* |