summaryrefslogtreecommitdiff
path: root/src/test/isolation/expected/inplace-inval.out
blob: c35895a8aa7b0ad102188daa86516547cf0d8659 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Parsed test spec with 3 sessions

starting permutation: cachefill3 cir1 cic2 ddl3 read1
step cachefill3: TABLE newly_indexed;
c
-
(0 rows)

step cir1: BEGIN; CREATE INDEX i1 ON newly_indexed (c); ROLLBACK;
step cic2: CREATE INDEX i2 ON newly_indexed (c);
step ddl3: ALTER TABLE newly_indexed ADD extra int;
step read1: 
	SELECT relhasindex FROM pg_class WHERE oid = 'newly_indexed'::regclass;

relhasindex
-----------
t          
(1 row)


starting permutation: cir1 cic2 ddl3 read1
step cir1: BEGIN; CREATE INDEX i1 ON newly_indexed (c); ROLLBACK;
step cic2: CREATE INDEX i2 ON newly_indexed (c);
step ddl3: ALTER TABLE newly_indexed ADD extra int;
step read1: 
	SELECT relhasindex FROM pg_class WHERE oid = 'newly_indexed'::regclass;

relhasindex
-----------
t          
(1 row)