--source include/master-slave.inc # References: # # MDEV-32447 Using check_constraint_checks=OFF can break replication # # check_constraint_checks was added in MDEV-7563 but its addition # to OPTIONS_WRITTEN_TO_BINLOG was missed and therefore it was breaking # replication in binlog formats other than ROW. --connection master create table t10( pk int primary key, a int, constraint a_big check (a>10) ); insert into t10 values (1, 20); set check_constraint_checks=off; update t10 set a=a-15 where pk=1; update t10 set a=a+100 where pk=1; set check_constraint_checks=on ; select * from t10; --sync_slave_with_master # Here we are on the slave select * from t10; --connection master drop table t10; --sync_slave_with_master --source include/rpl_end.inc