1include/master-slave.inc 2[connection master] 3==== Initialize ==== 4[on master] 5[connection master] 6CREATE TABLE t (a VARCHAR(100)) ENGINE = MYISAM; 7CREATE TABLE t_self_logging (a VARCHAR(100)) ENGINE = NDB; 8[on slave] 9include/sync_slave_sql_with_master.inc 10[on master] 11[connection master] 12==== Test ==== 13---- binlog_format=row ---- 14* Modify tables of more than one engine, one of which is self-logging 15CREATE TRIGGER trig_1 AFTER INSERT ON t_self_logging FOR EACH ROW BEGIN INSERT INTO t VALUES (1); END; 16INSERT INTO t_self_logging VALUES (1); 17ERROR HY000: Cannot execute statement: impossible to write to binary log since more than one engine is involved and at least one engine is self-logging. 18DROP trigger trig_1; 19SELECT * FROM t_self_logging /* Should be empty */; 20a 21SELECT * FROM t /* Should be empty */; 22a 23==== Clean up ==== 24DROP TABLE t, t_self_logging; 25include/sync_slave_sql_with_master.inc 26include/rpl_end.inc 27