| # Test NOWAIT when regular row locks can't be acquired. |
| # GPDB: have to run sessions that have SELECT ... FOR ... w/ planner because |
| # ORCA would upgrade lock to ExclusiveLock. |
| |
| 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 { SET optimizer=off; BEGIN; } |
| step s1a { SELECT * FROM foo FOR UPDATE NOWAIT; } |
| step s1b { COMMIT; } |
| |
| session s2 |
| setup { SET optimizer=off; BEGIN; } |
| step s2a { SELECT * FROM foo FOR UPDATE NOWAIT; } |
| step s2b { COMMIT; } |
