1Parsed test spec with 2 sessions
2
3starting permutation: rwx1 c1 rwx2 c2
4step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
5step c1: COMMIT;
6step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
7step c2: COMMIT;
8
9starting permutation: rwx1 rwx2 c1 c2
10step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
11step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
12step c1: COMMIT;
13step c2: COMMIT;
14ERROR:  could not serialize access due to read/write dependencies among transactions
15
16starting permutation: rwx1 rwx2 c2 c1
17step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
18step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
19step c2: COMMIT;
20step c1: COMMIT;
21ERROR:  could not serialize access due to read/write dependencies among transactions
22
23starting permutation: rwx2 rwx1 c1 c2
24step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
25step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
26step c1: COMMIT;
27step c2: COMMIT;
28ERROR:  could not serialize access due to read/write dependencies among transactions
29
30starting permutation: rwx2 rwx1 c2 c1
31step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
32step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
33step c2: COMMIT;
34step c1: COMMIT;
35ERROR:  could not serialize access due to read/write dependencies among transactions
36
37starting permutation: rwx2 c2 rwx1 c1
38step rwx2: UPDATE test SET t = 'pear' WHERE t = 'apple'
39step c2: COMMIT;
40step rwx1: UPDATE test SET t = 'apple' WHERE t = 'pear';
41step c1: COMMIT;
42