diff options
Diffstat (limited to 'src/test/isolation/expected/drop-index-concurrently-1.out')
-rw-r--r-- | src/test/isolation/expected/drop-index-concurrently-1.out | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/src/test/isolation/expected/drop-index-concurrently-1.out b/src/test/isolation/expected/drop-index-concurrently-1.out new file mode 100644 index 00000000000..c42ac91f8be --- /dev/null +++ b/src/test/isolation/expected/drop-index-concurrently-1.out @@ -0,0 +1,36 @@ +Parsed test spec with 3 sessions + +starting permutation: noseq prepi preps begin explaini explains select2 drop insert2 end2 selecti selects end +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; +QUERY PLAN + +Index Scan using test_dc_data on test_dc + Index Cond: (data = 34) +step explains: EXPLAIN (COSTS OFF) EXECUTE getrow_seq; +QUERY PLAN + +Seq Scan on test_dc + Filter: ((data)::text = '34'::text) +step select2: SELECT * FROM test_dc WHERE data=34; +id data + +34 34 +step drop: DROP INDEX CONCURRENTLY test_dc_data; <waiting ...> +step insert2: INSERT INTO test_dc(data) SELECT * FROM generate_series(1, 100); +step end2: COMMIT; +step selecti: EXECUTE getrow_idx; +id data + +34 34 +134 34 +step selects: EXECUTE getrow_seq; +id data + +34 34 +134 34 +step end: COMMIT; +step drop: <... completed> |