mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
37 lines
732 B
Text
37 lines
732 B
Text
--source include/have_innodb.inc
|
|
|
|
--let $rpl_topology=1->2->3
|
|
--source include/rpl_init.inc
|
|
|
|
#
|
|
# Test of MDEV-8428 Mangled DML statements on 2nd level slave when enabling
|
|
# binlog checksums
|
|
#
|
|
|
|
connection server_1;
|
|
|
|
CREATE DATABASE test_8428;
|
|
USE test_8428;
|
|
CREATE TABLE t1(i INT) ENGINE=INNODB;
|
|
INSERT INTO t1 VALUES(1), (2), (3), (4), (5);
|
|
CREATE TABLE t2 AS SELECT * FROM t1;
|
|
CREATE TABLE t3 ENGINE=MyISAM AS SELECT * FROM t1;
|
|
|
|
save_master_pos;
|
|
connection server_2;
|
|
sync_with_master;
|
|
|
|
SHOW TABLES IN test_8428;
|
|
|
|
save_master_pos;
|
|
connection server_3;
|
|
sync_with_master;
|
|
|
|
SHOW TABLES IN test_8428;
|
|
SELECT * from test_8428.t1;
|
|
|
|
# Cleanup
|
|
connection server_1;
|
|
DROP DATABASE test_8428;
|
|
--source include/rpl_end.inc
|
|
--echo # End of test
|