diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/isolation/expected/brin-1.out | 39 | ||||
| -rw-r--r-- | src/test/isolation/isolation_schedule | 1 | ||||
| -rw-r--r-- | src/test/isolation/specs/brin-1.spec | 44 |
3 files changed, 0 insertions, 84 deletions
diff --git a/src/test/isolation/expected/brin-1.out b/src/test/isolation/expected/brin-1.out deleted file mode 100644 index ddb90f4dba1..00000000000 --- a/src/test/isolation/expected/brin-1.out +++ /dev/null @@ -1,39 +0,0 @@ -Parsed test spec with 2 sessions - -starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset blknum attnum allnulls hasnulls placeholder value - -1 0 1 f f f {1 .. 1} -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; -?column? - -1 -step s1i: INSERT INTO brin_iso VALUES (1000); -step s2summ: SELECT brin_summarize_new_values('brinidx'::regclass); -brin_summarize_new_values - -1 -step s1c: COMMIT; -step s2c: COMMIT; -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset blknum attnum allnulls hasnulls placeholder value - -1 0 1 f f f {1 .. 1} -2 1 1 f f f {1 .. 1000} - -starting permutation: s2check s1b s1i s2vacuum s1c s2check -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset blknum attnum allnulls hasnulls placeholder value - -1 0 1 f f f {1 .. 1} -step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ; -step s1i: INSERT INTO brin_iso VALUES (1000); -step s2vacuum: VACUUM brin_iso; -step s1c: COMMIT; -step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); -itemoffset blknum attnum allnulls hasnulls placeholder value - -1 0 1 f f f {1 .. 1} -2 1 1 f f f {1 .. 1000} diff --git a/src/test/isolation/isolation_schedule b/src/test/isolation/isolation_schedule index 5852c6e51c2..c0ed637cd24 100644 --- a/src/test/isolation/isolation_schedule +++ b/src/test/isolation/isolation_schedule @@ -36,7 +36,6 @@ test: skip-locked test: skip-locked-2 test: skip-locked-3 test: skip-locked-4 -test: brin-1 test: drop-index-concurrently-1 test: alter-table-1 test: alter-table-2 diff --git a/src/test/isolation/specs/brin-1.spec b/src/test/isolation/specs/brin-1.spec deleted file mode 100644 index 19ac18a2e88..00000000000 --- a/src/test/isolation/specs/brin-1.spec +++ /dev/null @@ -1,44 +0,0 @@ -# This test verifies that values inserted in transactions still in progress -# are considered during concurrent range summarization (either using the -# brin_summarize_new_values function or regular VACUUM). - -setup -{ - CREATE TABLE brin_iso ( - value int - ) WITH (fillfactor=10); - CREATE INDEX brinidx ON brin_iso USING brin (value) WITH (pages_per_range=1); - -- this fills the first page - DO $$ - DECLARE curtid tid; - BEGIN - LOOP - INSERT INTO brin_iso VALUES (1) RETURNING ctid INTO curtid; - EXIT WHEN curtid > tid '(1, 0)'; - END LOOP; - END; - $$; - CREATE EXTENSION IF NOT EXISTS pageinspect; -} - -teardown -{ - DROP TABLE brin_iso; -} - -session "s1" -step "s1b" { BEGIN ISOLATION LEVEL REPEATABLE READ; } -step "s1i" { INSERT INTO brin_iso VALUES (1000); } -step "s1c" { COMMIT; } - -session "s2" -step "s2b" { BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1; } -step "s2summ" { SELECT brin_summarize_new_values('brinidx'::regclass); } -step "s2c" { COMMIT; } - -step "s2vacuum" { VACUUM brin_iso; } - -step "s2check" { SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass); } - -permutation "s2check" "s1b" "s2b" "s1i" "s2summ" "s1c" "s2c" "s2check" -permutation "s2check" "s1b" "s1i" "s2vacuum" "s1c" "s2check" |