Debian Codegraph @

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

raw
1 #
2 # Test ensures that MDL locks for foreign keys are taken correctly for Write
3 # rows log events. That is, when slave_exec_mode=STRICT, MDL locks for only
4 # target tables are taken. When slave_exec_mode=IDEMPOTENT, MDL locks for
5 # target tables and tables referenced in foreign keys are taken.
6 #
7 # References:
8 # MDEV-25039: MDL BF-BF conflict because of foreign key
9 #
10 source include/have_innodb.inc;
11 source include/have_perfschema.inc;
12 source include/have_debug_sync.inc;
13 source include/have_binlog_format_row.inc;
14 source include/master-slave.inc;
15
16 --echo #
17 --echo # Initialize test data
18 connection master;
19 CREATE TABLE t1 (
20 id INTEGER PRIMARY KEY AUTO_INCREMENT,
21 f2 INTEGER
22 ) engine=innodb;
23
24 CREATE TABLE t2 (
25 id INT PRIMARY KEY AUTO_INCREMENT,
26 t1_id INT NOT NULL,
27 f2 INTEGER NOT NULL,
28 KEY key_t1_id(t1_id),
29 CONSTRAINT key_t1_id FOREIGN KEY (t1_id) REFERENCES t1 (id) ON UPDATE CASCADE ON DELETE CASCADE
30 ) engine=innodb;
31
32 INSERT INTO t1 (f2) VALUES (0);
33 INSERT INTO t1 (f2) VALUES (0);
34 INSERT INTO t2 (t1_id, f2) VALUES (1,1234);
35 --sync_slave_with_master
36
37 --echo #
38 --echo # slave_exec_mode = IDEMPOTENT
39 --let $fk_slave_exec_mode = IDEMPOTENT
40 --source rpl_row_foreign_key_mdl.inc
41
42 --echo #
43 --echo # slave_exec_mode = STRICT
44 --let $fk_slave_exec_mode = STRICT
45 --source rpl_row_foreign_key_mdl.inc
46
47 #
48 # Cleanup
49 #
50 --connection master
51 DROP TABLE t2;
52 DROP TABLE t1;
53 --sync_slave_with_master
54
55 --source include/rpl_end.inc
56 --echo # End of rpl_row_foreign_key_mdl.test