blob: 660041061833387c83ccf2fb2cf4486461be6573 (
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
|
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
step select1surprise: SELECT * FROM colors ORDER BY key;
key color is_active
1 Brown t
2 Green f
3 Blue f
step c1: COMMIT;
|
