Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit1671c01

Browse files
committed
Remove repeated test in contrib/amcheck
Repeating these tests adds unnecessary cycles, since no improvement intest coverage is expected.Cleanup from commit8224de4.Peter Geoghegan
1 parent9d0383c commit1671c01

File tree

2 files changed

+2
-24
lines changed

2 files changed

+2
-24
lines changed

‎contrib/amcheck/expected/check_btree.out

Lines changed: 1 addition & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -111,27 +111,9 @@ SELECT bt_index_parent_check('bttest_multi_idx', true);
111111

112112
(1 row)
113113

114-
SELECT bt_index_parent_check('bttest_multi_idx', true);
115-
bt_index_parent_check
116-
-----------------------
117-
118-
(1 row)
119-
120-
-- repeat same checks with index made by insertions
114+
-- repeat expansive test for index built using insertions
121115
TRUNCATE bttest_multi;
122116
INSERT INTO bttest_multi SELECT i, i%2 FROM generate_series(1, 100000) as i;
123-
SELECT bt_index_check('bttest_multi_idx');
124-
bt_index_check
125-
----------------
126-
127-
(1 row)
128-
129-
SELECT bt_index_parent_check('bttest_multi_idx', true);
130-
bt_index_parent_check
131-
-----------------------
132-
133-
(1 row)
134-
135117
SELECT bt_index_parent_check('bttest_multi_idx', true);
136118
bt_index_parent_check
137119
-----------------------

‎contrib/amcheck/sql/check_btree.sql

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -65,15 +65,11 @@ COMMIT;
6565
SELECT bt_index_check('bttest_multi_idx');
6666
-- more expansive test for index with included columns
6767
SELECT bt_index_parent_check('bttest_multi_idx', true);
68-
SELECT bt_index_parent_check('bttest_multi_idx', true);
6968

70-
-- repeatsame checks with indexmade by insertions
69+
-- repeatexpansive test for indexbuilt using insertions
7170
TRUNCATE bttest_multi;
7271
INSERT INTO bttest_multiSELECT i, i%2FROM generate_series(1,100000)as i;
73-
SELECT bt_index_check('bttest_multi_idx');
7472
SELECT bt_index_parent_check('bttest_multi_idx', true);
75-
SELECT bt_index_parent_check('bttest_multi_idx', true);
76-
7773

7874
-- cleanup
7975
DROPTABLE bttest_a;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp