aboutsummaryrefslogtreecommitdiff
path: root/src/test/isolation/expected/lock-update-traversal.out
blob: c8e90661b2026fd6406804908584bbe154d0c719 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Parsed test spec with 2 sessions

starting permutation: s1b s2b s1s s2u s1l s2c s2d s1c
step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
step s2b: BEGIN;
step s1s: SELECT * FROM foo;
key            value          

1              1              
step s2u: UPDATE foo SET value = 2 WHERE key = 1;
step s1l: SELECT * FROM foo FOR KEY SHARE;
key            value          

1              1              
step s2c: COMMIT;
step s2d: DELETE FROM foo WHERE key = 1; <waiting ...>
step s1c: COMMIT;
step s2d: <... completed>