diff options
Diffstat (limited to 'src/test/regress/sql/select.sql')
| -rw-r--r-- | src/test/regress/sql/select.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/src/test/regress/sql/select.sql b/src/test/regress/sql/select.sql index f23cccd24f..8c92168c9b 100644 --- a/src/test/regress/sql/select.sql +++ b/src/test/regress/sql/select.sql @@ -59,10 +59,15 @@ SELECT onek.unique1, onek.string4 FROM onek -- test partial btree indexes -- -- As of 7.2, planner probably won't pick an indexscan without stats, --- so ANALYZE first. +-- so ANALYZE first. Also, we want to prevent it from picking a bitmapscan +-- followed by sort, because that could hide index ordering problems. -- ANALYZE onek2; +SET enable_seqscan TO off; +SET enable_bitmapscan TO off; +SET enable_sort TO off; + -- -- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1 -- @@ -81,6 +86,10 @@ SELECT onek2.unique1, onek2.stringu1 FROM onek2 SELECT onek2.unique1, onek2.stringu1 FROM onek2 WHERE onek2.unique1 > 980; +RESET enable_seqscan; +RESET enable_bitmapscan; +RESET enable_sort; + SELECT two, stringu1, ten, string4 INTO TABLE tmp |