diff options
Diffstat (limited to 'src/test/isolation/specs/drop-index-concurrently-1.spec')
| -rw-r--r-- | src/test/isolation/specs/drop-index-concurrently-1.spec | 33 |
1 files changed, 0 insertions, 33 deletions
diff --git a/src/test/isolation/specs/drop-index-concurrently-1.spec b/src/test/isolation/specs/drop-index-concurrently-1.spec deleted file mode 100644 index 83c44ab31a..0000000000 --- a/src/test/isolation/specs/drop-index-concurrently-1.spec +++ /dev/null @@ -1,33 +0,0 @@ -setup -{ - CREATE TABLE test_dc(id serial primary key, data int); - INSERT INTO test_dc(data) SELECT * FROM generate_series(1, 100); - CREATE INDEX test_dc_data ON test_dc(data); -} - -teardown -{ - DROP TABLE test_dc; -} - -session "s1" -step "noseq" { SET enable_seqscan = false; } -step "prepi" { PREPARE getrow_idx AS SELECT * FROM test_dc WHERE data=34; } -step "preps" { PREPARE getrow_seq AS SELECT * FROM test_dc WHERE data::text=34::text; } -step "begin" { BEGIN; } -step "explaini" { EXPLAIN (COSTS OFF) EXECUTE getrow_idx; } -step "explains" { EXPLAIN (COSTS OFF) EXECUTE getrow_seq; } -step "selecti" { EXECUTE getrow_idx; } -step "selects" { EXECUTE getrow_seq; } -step "end" { COMMIT; } - -session "s2" -setup { BEGIN; } -step "select2" { SELECT * FROM test_dc WHERE data=34; } -step "insert2" { INSERT INTO test_dc(data) SELECT * FROM generate_series(1, 100); } -step "end2" { COMMIT; } - -session "s3" -step "drop" { DROP INDEX CONCURRENTLY test_dc_data; } - -permutation "noseq" "prepi" "preps" "begin" "explaini" "explains" "select2" "drop" "insert2" "end2" "selecti" "selects" "end" |