diff options
Diffstat (limited to 'mysql-test/main/flush_read_lock.test')
| -rw-r--r-- | mysql-test/main/flush_read_lock.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/flush_read_lock.test b/mysql-test/main/flush_read_lock.test index d73820425d2..f24f6e389f1 100644 --- a/mysql-test/main/flush_read_lock.test +++ b/mysql-test/main/flush_read_lock.test @@ -1323,6 +1323,16 @@ let $statement= select f2_temp(); let $cleanup_stmt= delete from t1_temp limit 1; --source include/check_ftwrl_compatible.inc +--echo # 30.f) SELECT ... FOR UPDATE SKIP LOCKED is incompatible with FTWRL. +let $statement= select count(*) from t1_base for update skip locked; +let $cleanup_stmt1= ; +--source include/check_ftwrl_incompatible.inc + +--echo # 30.g) SELECT ... LOCK IN SHARE MODE SKIP LOCKED is compatible with FTWRL. +let $statement= select count(*) from t1_base lock in share mode skip locked; +let $cleanup_stmt= ; +--source include/check_ftwrl_compatible.inc + --echo # --echo # 31) Compatibility of SET statement with FTWRL depends on its @@ -1679,6 +1689,9 @@ connection default; --echo # Reap XA COMMIT. --reap delete from t3_trans; +# MDEV-515 takes X-lock on the table for the first insert. +# So concurrent insert won't happen on the table +INSERT INTO t3_trans VALUES(100); --echo # --echo # Check that XA COMMIT / ROLLBACK for prepared transaction from a --echo # disconnected session is blocked by active FTWRL in another connection. |