# Test NOWAIT when regular row locks can't be acquired. setup { CREATE TABLE foo ( id int PRIMARY KEY, data text NOT NULL ); INSERT INTO foo VALUES (1, 'x'); } teardown { DROP TABLE foo; } session "s1" setup { BEGIN; } step "s1a" { SELECT * FROM foo FOR UPDATE NOWAIT; } step "s1b" { COMMIT; } session "s2" setup { BEGIN; } step "s2a" { SELECT * FROM foo FOR UPDATE NOWAIT; } step "s2b" { COMMIT; }