1 include/master-slave.inc
3 DROP TRIGGER test.t1_bi_t2;
4 DROP TABLE IF EXISTS test.t1;
5 DROP TABLE IF EXISTS test.t2;
6 CREATE TABLE test.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT, d FLOAT, PRIMARY KEY(n))ENGINE=INNODB;
7 CREATE TABLE test.t2 (n MEDIUMINT NOT NULL, f FLOAT, PRIMARY KEY(n))ENGINE=INNODB;
8 CREATE TRIGGER test.t1_bi_t2 BEFORE INSERT ON test.t2 FOR EACH ROW INSERT INTO test.t1 VALUES (NULL, 1.234)//
9 INSERT INTO test.t2 VALUES (1, 0.0);
10 INSERT INTO test.t2 VALUES (1, 0.0);
11 Got one of the listed errors
12 select * from test.t1;
15 select * from test.t2;
18 select * from test.t1;
21 select * from test.t2;
24 DROP TRIGGER test.t1_bi_t2;