1--source include/have_innodb.inc
2
3--let $rpl_topology=1->2->3
4--source include/rpl_init.inc
5
6#
7# Test of MDEV-8428 Mangled DML statements on 2nd level slave when enabling
8# binlog checksums
9#
10
11connection server_1;
12
13CREATE DATABASE test_8428;
14USE test_8428;
15CREATE TABLE t1(i INT) ENGINE=INNODB;
16INSERT INTO t1 VALUES(1), (2), (3), (4), (5);
17CREATE TABLE t2 AS SELECT * FROM t1;
18CREATE TABLE t3 ENGINE=MyISAM AS SELECT * FROM t1;
19
20save_master_pos;
21connection server_2;
22sync_with_master;
23
24SHOW TABLES IN test_8428;
25
26save_master_pos;
27connection server_3;
28sync_with_master;
29
30SHOW TABLES IN test_8428;
31SELECT * from test_8428.t1;
32
33# Cleanup
34connection server_1;
35DROP DATABASE test_8428;
36--source include/rpl_end.inc
37--echo # End of test
38