diff options
Diffstat (limited to 'src/test/modules/snapshot_too_old/expected/sto_using_select.out')
| -rw-r--r-- | src/test/modules/snapshot_too_old/expected/sto_using_select.out | 54 |
1 files changed, 36 insertions, 18 deletions
diff --git a/src/test/modules/snapshot_too_old/expected/sto_using_select.out b/src/test/modules/snapshot_too_old/expected/sto_using_select.out index eb15bc23bf9..3067e054547 100644 --- a/src/test/modules/snapshot_too_old/expected/sto_using_select.out +++ b/src/test/modules/snapshot_too_old/expected/sto_using_select.out @@ -2,54 +2,72 @@ Parsed test spec with 2 sessions starting permutation: s1f1 s1sleep s1f2 s2u step s1f1: SELECT c FROM sto1 ORDER BY c LIMIT 1; -c +c +- +1 +(1 row) -1 step s1sleep: SELECT setting, pg_sleep(6) FROM pg_settings WHERE name = 'old_snapshot_threshold'; -setting pg_sleep +setting|pg_sleep +-------+-------- + 0| +(1 row) -0 step s1f2: SELECT c FROM sto1 ORDER BY c LIMIT 1; -c +c +- +1 +(1 row) -1 step s2u: UPDATE sto1 SET c = 1001 WHERE c = 1; starting permutation: s1f1 s1sleep s2u s1f2 step s1f1: SELECT c FROM sto1 ORDER BY c LIMIT 1; -c +c +- +1 +(1 row) -1 step s1sleep: SELECT setting, pg_sleep(6) FROM pg_settings WHERE name = 'old_snapshot_threshold'; -setting pg_sleep +setting|pg_sleep +-------+-------- + 0| +(1 row) -0 step s2u: UPDATE sto1 SET c = 1001 WHERE c = 1; step s1f2: SELECT c FROM sto1 ORDER BY c LIMIT 1; ERROR: snapshot too old starting permutation: s1f1 s2u s1sleep s1f2 step s1f1: SELECT c FROM sto1 ORDER BY c LIMIT 1; -c +c +- +1 +(1 row) -1 step s2u: UPDATE sto1 SET c = 1001 WHERE c = 1; step s1sleep: SELECT setting, pg_sleep(6) FROM pg_settings WHERE name = 'old_snapshot_threshold'; -setting pg_sleep +setting|pg_sleep +-------+-------- + 0| +(1 row) -0 step s1f2: SELECT c FROM sto1 ORDER BY c LIMIT 1; ERROR: snapshot too old starting permutation: s2u s1f1 s1sleep s1f2 step s2u: UPDATE sto1 SET c = 1001 WHERE c = 1; step s1f1: SELECT c FROM sto1 ORDER BY c LIMIT 1; -c +c +- +2 +(1 row) -2 step s1sleep: SELECT setting, pg_sleep(6) FROM pg_settings WHERE name = 'old_snapshot_threshold'; -setting pg_sleep +setting|pg_sleep +-------+-------- + 0| +(1 row) -0 step s1f2: SELECT c FROM sto1 ORDER BY c LIMIT 1; ERROR: snapshot too old |