| 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 |