Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_skip_locked.test

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