polardbxengine/mysql-test/suite/xengine_main/r/archive_skip_lock_nowait.re...

13 lines
201 B
Plaintext

CREATE TABLE t1 ( a INT) ENGINE=archive;
INSERT INTO t1 VALUES (1);
SELECT * FROM t1 FOR UPDATE;
a
1
SELECT * FROM t1 FOR UPDATE SKIP LOCKED;
a
1
SELECT * FROM t1 FOR UPDATE NOWAIT;
a
1
DROP TABLE t1;