/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/skip-locked-2.out
67 строк
1 KB
Tom Lane
Improve display of query results in isolation tests.
23 июн 2021, 18:13
23 июн 2021, 18:13
4a05406
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1a s2a s2b s1b s2c step s1a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s2a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s2b: SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 2|bar |NEW (1 row) step s1b: COMMIT; step s2c: COMMIT; starting permutation: s2a s1a s2b s1b s2c step s2a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s1a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s2b: SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 2|bar |NEW (1 row) step s1b: COMMIT; step s2c: COMMIT; starting permutation: s2a s2b s1a s1b s2c step s2a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s2b: SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 1|foo |NEW (1 row) step s1a: SELECT * FROM queue ORDER BY id FOR SHARE SKIP LOCKED LIMIT 1; id|data|status --+----+------ 2|bar |NEW (1 row) step s1b: COMMIT; step s2c: COMMIT;