Debian Codegraph @

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

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