aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTeodor Sigaev <teodor@sigaev.ru>2018-04-09 09:19:09 +0300
committerTeodor Sigaev <teodor@sigaev.ru>2018-04-09 09:19:09 +0300
commit1671c01650d2cf9398b2e5ff87be2e2fd03781b7 (patch)
treed75e24b983397f42ceac2f412be5de302330bec9
parent9d0383c015aabd7565f3df010a5ff56b46aa8756 (diff)
downloadpostgresql-1671c01650d2cf9398b2e5ff87be2e2fd03781b7.tar.gz
postgresql-1671c01650d2cf9398b2e5ff87be2e2fd03781b7.zip
Remove repeated test in contrib/amcheck
Repeating these tests adds unnecessary cycles, since no improvement in test coverage is expected. Cleanup from commit 8224de4f42ccf98e08db07b43d52fed72f962ebb. Peter Geoghegan
-rw-r--r--contrib/amcheck/expected/check_btree.out20
-rw-r--r--contrib/amcheck/sql/check_btree.sql6
2 files changed, 2 insertions, 24 deletions
diff --git a/contrib/amcheck/expected/check_btree.out b/contrib/amcheck/expected/check_btree.out
index 2a06cce9a0e..ed80ac46648 100644
--- a/contrib/amcheck/expected/check_btree.out
+++ b/contrib/amcheck/expected/check_btree.out
@@ -111,27 +111,9 @@ SELECT bt_index_parent_check('bttest_multi_idx', true);
(1 row)
-SELECT bt_index_parent_check('bttest_multi_idx', true);
- bt_index_parent_check
------------------------
-
-(1 row)
-
--- repeat same checks with index made by insertions
+-- repeat expansive test for index built using insertions
TRUNCATE bttest_multi;
INSERT INTO bttest_multi SELECT i, i%2 FROM generate_series(1, 100000) as i;
-SELECT bt_index_check('bttest_multi_idx');
- bt_index_check
-----------------
-
-(1 row)
-
-SELECT bt_index_parent_check('bttest_multi_idx', true);
- bt_index_parent_check
------------------------
-
-(1 row)
-
SELECT bt_index_parent_check('bttest_multi_idx', true);
bt_index_parent_check
-----------------------
diff --git a/contrib/amcheck/sql/check_btree.sql b/contrib/amcheck/sql/check_btree.sql
index da2f1314e57..4ca9d2d0ed1 100644
--- a/contrib/amcheck/sql/check_btree.sql
+++ b/contrib/amcheck/sql/check_btree.sql
@@ -65,15 +65,11 @@ COMMIT;
SELECT bt_index_check('bttest_multi_idx');
-- more expansive test for index with included columns
SELECT bt_index_parent_check('bttest_multi_idx', true);
-SELECT bt_index_parent_check('bttest_multi_idx', true);
--- repeat same checks with index made by insertions
+-- repeat expansive test for index built using insertions
TRUNCATE bttest_multi;
INSERT INTO bttest_multi SELECT i, i%2 FROM generate_series(1, 100000) as i;
-SELECT bt_index_check('bttest_multi_idx');
SELECT bt_index_parent_check('bttest_multi_idx', true);
-SELECT bt_index_parent_check('bttest_multi_idx', true);
-
-- cleanup
DROP TABLE bttest_a;