diff options
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/regress/expected/alter_table.out | 6 | ||||
-rw-r--r-- | src/test/regress/expected/arrays.out | 3 | ||||
-rw-r--r-- | src/test/regress/expected/stats.out | 2 | ||||
-rw-r--r-- | src/test/regress/sql/alter_table.sql | 8 | ||||
-rw-r--r-- | src/test/regress/sql/arrays.sql | 4 | ||||
-rw-r--r-- | src/test/regress/sql/stats.sql | 3 |
6 files changed, 24 insertions, 2 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index b9edbc649d4..54205395e2b 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -131,8 +131,10 @@ ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1; -- renaming views CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1; ALTER TABLE tmp_view RENAME TO tmp_view_new; --- analyze to ensure we get an indexscan here +-- hack to ensure we get an indexscan here ANALYZE tenk1; +set enable_seqscan to off; +set enable_bitmapscan to off; -- 5 values, sorted SELECT unique1 FROM tenk1 WHERE unique1 < 5; unique1 @@ -144,6 +146,8 @@ SELECT unique1 FROM tenk1 WHERE unique1 < 5; 4 (5 rows) +reset enable_seqscan; +reset enable_bitmapscan; DROP VIEW tmp_view_new; -- toast-like relation name alter table stud_emp rename to pg_toast_stud_emp; diff --git a/src/test/regress/expected/arrays.out b/src/test/regress/expected/arrays.out index edcfa900a58..80eab4a13da 100644 --- a/src/test/regress/expected/arrays.out +++ b/src/test/regress/expected/arrays.out @@ -367,6 +367,7 @@ insert into arr_tbl values ('{2,3,4}'); insert into arr_tbl values ('{1,5,3}'); insert into arr_tbl values ('{1,2,10}'); set enable_seqscan to off; +set enable_bitmapscan to off; select * from arr_tbl where f1 > '{1,2,3}' and f1 <= '{1,5,3}'; f1 ---------- @@ -376,6 +377,8 @@ select * from arr_tbl where f1 > '{1,2,3}' and f1 <= '{1,5,3}'; -- note: if above select doesn't produce the expected tuple order, -- then you didn't get an indexscan plan, and something is busted. +reset enable_seqscan; +reset enable_bitmapscan; -- test [not] (like|ilike) (any|all) (...) select 'foo' like any (array['%a', '%o']); -- t ?column? diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out index 8013ab65b29..e366f76cb9c 100644 --- a/src/test/regress/expected/stats.out +++ b/src/test/regress/expected/stats.out @@ -11,6 +11,8 @@ SHOW stats_start_collector; -- must be on on (1 row) +-- XXX stopgap until we figure out how bitmap scans should be counted +SET enable_bitmapscan = off; -- save counters CREATE TEMP TABLE prevstats AS SELECT t.seq_scan, t.seq_tup_read, t.idx_scan, t.idx_tup_fetch, diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 2659efbfac5..aa3d17ccf7d 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -171,10 +171,16 @@ ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1; -- renaming views CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1; ALTER TABLE tmp_view RENAME TO tmp_view_new; --- analyze to ensure we get an indexscan here + +-- hack to ensure we get an indexscan here ANALYZE tenk1; +set enable_seqscan to off; +set enable_bitmapscan to off; -- 5 values, sorted SELECT unique1 FROM tenk1 WHERE unique1 < 5; +reset enable_seqscan; +reset enable_bitmapscan; + DROP VIEW tmp_view_new; -- toast-like relation name alter table stud_emp rename to pg_toast_stud_emp; diff --git a/src/test/regress/sql/arrays.sql b/src/test/regress/sql/arrays.sql index a2308353575..37ef80bb5c4 100644 --- a/src/test/regress/sql/arrays.sql +++ b/src/test/regress/sql/arrays.sql @@ -178,10 +178,14 @@ insert into arr_tbl values ('{1,2,3}'); insert into arr_tbl values ('{2,3,4}'); insert into arr_tbl values ('{1,5,3}'); insert into arr_tbl values ('{1,2,10}'); + set enable_seqscan to off; +set enable_bitmapscan to off; select * from arr_tbl where f1 > '{1,2,3}' and f1 <= '{1,5,3}'; -- note: if above select doesn't produce the expected tuple order, -- then you didn't get an indexscan plan, and something is busted. +reset enable_seqscan; +reset enable_bitmapscan; -- test [not] (like|ilike) (any|all) (...) select 'foo' like any (array['%a', '%o']); -- t diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql index 948a81f0c40..d5dcbd92cee 100644 --- a/src/test/regress/sql/stats.sql +++ b/src/test/regress/sql/stats.sql @@ -8,6 +8,9 @@ -- conditio sine qua non SHOW stats_start_collector; -- must be on +-- XXX stopgap until we figure out how bitmap scans should be counted +SET enable_bitmapscan = off; + -- save counters CREATE TEMP TABLE prevstats AS SELECT t.seq_scan, t.seq_tup_read, t.idx_scan, t.idx_tup_fetch, |