aboutsummaryrefslogtreecommitdiff
path: root/src/test/isolation/expected/drop-index-concurrently-1_2.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/isolation/expected/drop-index-concurrently-1_2.out')
-rw-r--r--src/test/isolation/expected/drop-index-concurrently-1_2.out46
1 files changed, 29 insertions, 17 deletions
diff --git a/src/test/isolation/expected/drop-index-concurrently-1_2.out b/src/test/isolation/expected/drop-index-concurrently-1_2.out
index 87d07955d04..04612d3cacc 100644
--- a/src/test/isolation/expected/drop-index-concurrently-1_2.out
+++ b/src/test/isolation/expected/drop-index-concurrently-1_2.out
@@ -4,39 +4,51 @@ starting permutation: noseq chkiso prepi preps begin explaini explains select2 d
step noseq: SET enable_seqscan = false;
step chkiso: SELECT (setting in ('read committed','read uncommitted')) AS is_read_committed FROM pg_settings WHERE name = 'default_transaction_isolation';
is_read_committed
+-----------------
+f
+(1 row)
-f
step prepi: PREPARE getrow_idx AS SELECT * FROM test_dc WHERE data=34 ORDER BY id,data;
step preps: PREPARE getrow_seq AS SELECT * FROM test_dc WHERE data::text=34::text ORDER BY id,data;
step begin: BEGIN;
step explaini: EXPLAIN (COSTS OFF) EXECUTE getrow_idx;
-QUERY PLAN
-
-Sort
- Sort Key: id
+QUERY PLAN
+----------------------------------------------
+Sort
+ Sort Key: id
-> Index Scan using test_dc_data on test_dc
- Index Cond: (data = 34)
-step explains: EXPLAIN (COSTS OFF) EXECUTE getrow_seq;
-QUERY PLAN
+ Index Cond: (data = 34)
+(4 rows)
-Sort
- Sort Key: id, data
+step explains: EXPLAIN (COSTS OFF) EXECUTE getrow_seq;
+QUERY PLAN
+----------------------------------------------
+Sort
+ Sort Key: id, data
-> Index Scan using test_dc_pkey on test_dc
- Filter: ((data)::text = '34'::text)
+ Filter: ((data)::text = '34'::text)
+(4 rows)
+
step select2: SELECT * FROM test_dc WHERE data=34 ORDER BY id,data;
-id data
+id|data
+--+----
+34| 34
+(1 row)
-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
+id|data
+--+----
+34| 34
+(1 row)
-34 34
step selects: EXECUTE getrow_seq;
-id data
+id|data
+--+----
+34| 34
+(1 row)
-34 34
step end: COMMIT;
step drop: <... completed>