/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/specs/skip-locked.spec
28 строк
678 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 when regular row locks can't be acquired. 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 SKIP LOCKED LIMIT 1; } step s1b { SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; } step s1c { COMMIT; } session s2 setup { BEGIN; } step s2a { SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; } step s2b { SELECT * FROM queue ORDER BY id FOR UPDATE SKIP LOCKED LIMIT 1; } step s2c { COMMIT; }