diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2005-08-30 07:57:48 +0000 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2005-08-30 07:57:48 +0000 |
| commit | 13ff51baf282ee4bd49036c82625a36007e0f233 (patch) | |
| tree | a90d22e42dd7d84487ec4935cdc3dbe7c4ff6f50 /src/backend/access/gist/gistget.c | |
| parent | 846ed05de63712fed24fd51043bc308bcd3c2478 (diff) | |
| download | postgresql-13ff51baf282ee4bd49036c82625a36007e0f233.tar.gz postgresql-13ff51baf282ee4bd49036c82625a36007e0f233.zip | |
Fix missing rows in query
update a=.. where a... with GiST index on column 'a'
Diffstat (limited to 'src/backend/access/gist/gistget.c')
| -rw-r--r-- | src/backend/access/gist/gistget.c | 18 |
1 files changed, 13 insertions, 5 deletions
diff --git a/src/backend/access/gist/gistget.c b/src/backend/access/gist/gistget.c index 70febc584c4..aa0260c6ad6 100644 --- a/src/backend/access/gist/gistget.c +++ b/src/backend/access/gist/gistget.c @@ -8,7 +8,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/access/gist/gistget.c,v 1.43 2004/12/31 21:59:10 pgsql Exp $ + * $PostgreSQL: pgsql/src/backend/access/gist/gistget.c,v 1.43.4.1 2005/08/30 07:57:48 teodor Exp $ * *------------------------------------------------------------------------- */ @@ -167,10 +167,18 @@ gistnext(IndexScanDesc s, ScanDirection dir) maxoff = PageGetMaxOffsetNumber(p); po = (GISTPageOpaque) PageGetSpecialPointer(p); - if (ScanDirectionIsBackward(dir)) - n = OffsetNumberPrev(stk->gs_child); - else - n = OffsetNumberNext(stk->gs_child); + if ( stk->gs_child == InvalidOffsetNumber ) { + /* rescan page */ + if (ScanDirectionIsBackward(dir)) + n = PageGetMaxOffsetNumber(p); + else + n = FirstOffsetNumber; + } else { + if (ScanDirectionIsBackward(dir)) + n = OffsetNumberPrev(stk->gs_child); + else + n = OffsetNumberNext(stk->gs_child); + } so->s_stack = stk->gs_parent; pfree(stk); |