diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-05-12 20:04:12 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-05-12 20:04:40 -0400 |
| commit | ea2ae830d9f07826a19a4eaf5131b9db3d554d51 (patch) | |
| tree | df3e745a660755a1e69c204c30d7ecd28ed3b86f /contrib/btree_gist | |
| parent | 627dcb6e42d2fd67ac1e2fb7cb8071d244697a53 (diff) | |
| download | postgresql-ea2ae830d9f07826a19a4eaf5131b9db3d554d51.tar.gz | |
Ensure plan stability in contrib/btree_gist regression test.
Buildfarm member skink failed with symptoms suggesting that an
auto-analyze had happened and changed the plan displayed for a
test query. Although this is evidently of low probability,
regression tests that sometimes fail are no fun, so add commands
to force a bitmap scan to be chosen.
Diffstat (limited to 'contrib/btree_gist')
| -rw-r--r-- | contrib/btree_gist/expected/not_equal.out | 2 | ||||
| -rw-r--r-- | contrib/btree_gist/sql/not_equal.sql | 4 |
2 files changed, 6 insertions, 0 deletions
diff --git a/contrib/btree_gist/expected/not_equal.out b/contrib/btree_gist/expected/not_equal.out index 1d5b55db5a..85b1e868a8 100644 --- a/contrib/btree_gist/expected/not_equal.out +++ b/contrib/btree_gist/expected/not_equal.out @@ -9,6 +9,7 @@ INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); INSERT INTO test_ne VALUES('2007-02-03', -91.3); INSERT INTO test_ne VALUES('2011-09-01', 43.7); INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); +SET enable_indexscan to false; EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; QUERY PLAN ------------------------------------------------------------------------------------------------------ @@ -25,6 +26,7 @@ SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; Thu Sep 01 00:00:00 2011 | 43.7 (2 rows) +RESET enable_indexscan; -- test search for "not equals" using an exclusion constraint CREATE TABLE zoo ( cage INTEGER, diff --git a/contrib/btree_gist/sql/not_equal.sql b/contrib/btree_gist/sql/not_equal.sql index b1940ef4fe..6dfac5d0aa 100644 --- a/contrib/btree_gist/sql/not_equal.sql +++ b/contrib/btree_gist/sql/not_equal.sql @@ -14,10 +14,14 @@ INSERT INTO test_ne VALUES('2007-02-03', -91.3); INSERT INTO test_ne VALUES('2011-09-01', 43.7); INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); +SET enable_indexscan to false; + EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; +RESET enable_indexscan; + -- test search for "not equals" using an exclusion constraint CREATE TABLE zoo ( |