source include/master-slave.inc; source include/have_innodb.inc; --echo # --echo # MDEV-6012: MySQL Bug#56184 Rolled back transaction without non-trasactional table updated was binlogged --echo # connection master; CREATE TABLE t1(c1 INT KEY) ENGINE=MyISAM; CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY) ENGINE=innodb; BEGIN; INSERT INTO t1 VALUES(1); INSERT INTO t2 VALUES(1); ROLLBACK; select * from t1; select * from t2; source include/show_binlog_events.inc; sync_slave_with_master; let $diff_tables= master:test.t1, slave:test.t1; source include/diff_tables.inc; BEGIN; INSERT INTO t1 VALUES(2); --error 1062 INSERT INTO t2 VALUES (2),(2); select * from t1; select * from t2; source include/show_binlog_events.inc; sync_slave_with_master; source include/diff_tables.inc; drop table t1, t2; source include/rpl_end.inc;