1Parsed test spec with 2 sessions
2
3starting permutation: rxwy1 c1 rywx2 c2
4step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
5step c1: COMMIT;
6step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
7step c2: COMMIT;
8
9starting permutation: rxwy1 rywx2 c1 c2
10step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
11step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
12step c1: COMMIT;
13step c2: COMMIT;
14ERROR:  could not serialize access due to read/write dependencies among transactions
15
16starting permutation: rxwy1 rywx2 c2 c1
17step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
18step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
19step c2: COMMIT;
20step c1: COMMIT;
21ERROR:  could not serialize access due to read/write dependencies among transactions
22
23starting permutation: rywx2 rxwy1 c1 c2
24step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
25step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
26step c1: COMMIT;
27step c2: COMMIT;
28ERROR:  could not serialize access due to read/write dependencies among transactions
29
30starting permutation: rywx2 rxwy1 c2 c1
31step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
32step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
33step c2: COMMIT;
34step c1: COMMIT;
35ERROR:  could not serialize access due to read/write dependencies among transactions
36
37starting permutation: rywx2 c2 rxwy1 c1
38step rywx2: DELETE FROM tabx WHERE id = (SELECT min(id) FROM taby);
39step c2: COMMIT;
40step rxwy1: DELETE FROM taby WHERE id = (SELECT min(id) FROM tabx);
41step c1: COMMIT;
42