Debian Codegraph @

mysql-test/suite/rpl/t/rpl_unsafe_skip_locked_nowait.test

raw
1 --source include/have_binlog_format_statement.inc
2 --source include/master-slave.inc
3 call mtr.add_suppression("unsafe because it uses SKIP LOCKED");
4
5 --echo # Case-1: BINLOG_STMT_UNSAFE_SKIP_LOCKED
6 --echo # Statement is unsafe because it uses SKIP LOCKED.
7
8 --echo # Step-1.1: Create and populate a table.
9 --enable_connect_log
10 --connection master
11 CREATE TABLE t1( a INT PRIMARY KEY, b INT );
12 INSERT INTO t1 VALUES (1, 1), (2, 1), (3, 1);
13
14 CREATE TABLE t2( a INT, b INT );
15 CREATE TABLE t3( a INT, b INT );
16
17 --echo # Step-1.2: Lock a row in said table.
18 START TRANSACTION;
19 SELECT * FROM t1 WHERE a = 2 FOR UPDATE;
20
21 --echo # Step-1.3: Populate another table with the unlocked rows.
22 --connect (conn, localhost, root,)
23 --error ER_LOCK_NOWAIT
24 INSERT INTO t2 SELECT * FROM t1 FOR UPDATE NOWAIT;
25 INSERT INTO t2 SELECT * FROM t1 FOR UPDATE SKIP LOCKED;
26 --disconnect conn
27 --connection master
28 ROLLBACK;
29
30 --echo # Step-1.4: Cleanup
31 DROP TABLE t1, t2, t3;
32 --disable_connect_log
33
34 --source include/rpl_end.inc