summaryrefslogtreecommitdiffstats
path: root/src/test/isolation/expected/insert-conflict-do-nothing.out
blob: cadf46d06546a7fe504bab642e19f280d5452e04 (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
Parsed test spec with 2 sessions

starting permutation: donothing1 donothing2 c1 select2 c2
step donothing1: INSERT INTO ints(key, val) VALUES(1, 'donothing1') ON CONFLICT DO NOTHING;
step donothing2: INSERT INTO ints(key, val) VALUES(1, 'donothing2') ON CONFLICT DO NOTHING; <waiting ...>
step c1: COMMIT;
step donothing2: <... completed>
step select2: SELECT * FROM ints;
key|val       
---+----------
  1|donothing1
(1 row)

step c2: COMMIT;

starting permutation: donothing1 donothing2 a1 select2 c2
step donothing1: INSERT INTO ints(key, val) VALUES(1, 'donothing1') ON CONFLICT DO NOTHING;
step donothing2: INSERT INTO ints(key, val) VALUES(1, 'donothing2') ON CONFLICT DO NOTHING; <waiting ...>
step a1: ABORT;
step donothing2: <... completed>
step select2: SELECT * FROM ints;
key|val       
---+----------
  1|donothing2
(1 row)

step c2: COMMIT;