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