/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/specs/skip-locked-3.spec
36 строк
819 B
Tom Lane
Allow non-quoted identifiers as isolation test session/step names.
24 июн 2021, 01:41
24 июн 2021, 01:41
a443c1b
Код
Авторство
О чём код?
# Test SKIP LOCKED with tuple locks. setup { CREATE TABLE queue ( id int PRIMARY KEY, data text NOT NULL, status text NOT NULL ); INSERT INTO queue VALUES (1, 'foo', 'NEW'), (2, 'bar', 'NEW'); } teardown { DROP TABLE queue; } session s1 setup { BEGIN; } step s1a { SELECT * FROM queue ORDER BY id FOR UPDATE LIMIT 1; } step s1b { COMMIT; } session s2 setup { BEGIN; } step s2a { SELECT * FROM queue ORDER BY id FOR UPDATE LIMIT 1; } step s2b { COMMIT; } session s3 setup { BEGIN; } step s3a { SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; } step s3b { COMMIT; } # s3 skips to the second record because it can't obtain the tuple lock # (s2 holds the tuple lock because it is next in line to obtain the # row lock, and s1 holds the row lock) permutation s1a s2a s3a s1b s2b s3b