Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit9191d68

Browse files
committed
Planner did the wrong thing with index-scan-backward plans: generated
them, but forgot to attach relevant restriction clauses, so that theplan represented a scan over the whole table with restrictions appliedas qpquals not indexquals. Another day, another bug...
1 parentcb29220 commit9191d68

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

‎src/backend/optimizer/path/indxpath.c

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
*
1010
*
1111
* IDENTIFICATION
12-
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.86 2000/07/05 23:11:22 tgl Exp $
12+
* $Header: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v 1.87 2000/07/13 05:47:29 tgl Exp $
1313
*
1414
*-------------------------------------------------------------------------
1515
*/
@@ -195,7 +195,7 @@ create_index_paths(Query *root,
195195
useful_for_ordering(root,rel,index,ForwardScanDirection))
196196
add_path(rel, (Path*)
197197
create_index_path(root,rel,index,
198-
NIL,
198+
restrictclauses,
199199
ForwardScanDirection));
200200
}
201201

@@ -207,7 +207,7 @@ create_index_paths(Query *root,
207207
if (useful_for_ordering(root,rel,index,BackwardScanDirection))
208208
add_path(rel, (Path*)
209209
create_index_path(root,rel,index,
210-
NIL,
210+
restrictclauses,
211211
BackwardScanDirection));
212212

213213
/*

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp