Debian Codegraph @

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

raw
1 --source include/not_group_replication_plugin.inc
2 -- source include/have_binlog_format_mixed.inc
3 -- source include/not_ndb_default.inc
4 -- source include/master-slave.inc
5
6 # Test that the slave temporarily switches to ROW when seeing row
7 # events when it is in MIXED mode
8
9 --echo **** On Master ****
10 CREATE TABLE t1 (a INT, b LONG);
11 INSERT INTO t1 VALUES (1,1), (2,2);
12 INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
13
14 --let $mask_binlog_commit_events= 1
15 source include/show_binlog_events.inc;
16 --source include/sync_slave_sql_with_master.inc
17 --echo **** On Slave ****
18 source include/show_binlog_events.inc;
19 --let $mask_binlog_commit_events= 0
20
21 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql
22 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql
23
24 connection master;
25 DROP TABLE IF EXISTS t1;
26
27 # Let's compare. Note: If they match test will pass, if they do not match
28 # the test will show that the diff statement failed and not reject file
29 # will be created. You will need to go to the mysql-test dir and diff
30 # the files your self to see what is not matching
31
32 diff_files $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql;
33
34 # If all is good, we can remove the files
35
36 --remove_file $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_master.sql
37 --remove_file $MYSQLTEST_VARDIR/tmp/rpl_rbr_to_sbr_slave.sql
38 --source include/rpl_end.inc