blob: 2d7e0b8f1818ada1d66f8671ed3d4da62d47f097 (
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
|
Parsed test spec with 2 sessions
starting permutation: update2 insert1 c2 select1surprise c1
step update2: UPDATE colors SET is_active = true WHERE key = 1;
step insert1:
WITH t AS (
INSERT INTO colors(key, color, is_active)
VALUES(1, 'Brown', true), (2, 'Gray', true)
ON CONFLICT (key) DO UPDATE
SET color = EXCLUDED.color
WHERE colors.is_active)
SELECT * FROM colors ORDER BY key; <waiting ...>
step c2: COMMIT;
step insert1: <... completed>
key|color|is_active
---+-----+---------
1|Red |f
2|Green|f
3|Blue |f
(3 rows)
step select1surprise: SELECT * FROM colors ORDER BY key;
key|color|is_active
---+-----+---------
1|Brown|t
2|Green|f
3|Blue |f
(3 rows)
step c1: COMMIT;
|
