Debian Codegraph @

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

raw
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
11 connection server_1;
12
13 CREATE DATABASE test_8428;
14 USE test_8428;
15 CREATE TABLE t1(i INT) ENGINE=INNODB;
16 INSERT INTO t1 VALUES(1), (2), (3), (4), (5);
17 CREATE TABLE t2 AS SELECT * FROM t1;
18 CREATE TABLE t3 ENGINE=MyISAM AS SELECT * FROM t1;
19
20 save_master_pos;
21 connection server_2;
22 sync_with_master;
23
24 SHOW TABLES IN test_8428;
25
26 save_master_pos;
27 connection server_3;
28 sync_with_master;
29
30 SHOW TABLES IN test_8428;
31 SELECT * from test_8428.t1;
32
33 # Cleanup
34 connection server_1;
35 DROP DATABASE test_8428;
36 --source include/rpl_end.inc
37 --echo # End of test