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