2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TRIGGER test.t1_bi_t2;
8
DROP TABLE IF EXISTS test.t1;
9
DROP TABLE IF EXISTS test.t2;
10
CREATE TABLE test.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT, d FLOAT, PRIMARY KEY(n))ENGINE=INNODB;
11
CREATE TABLE test.t2 (n MEDIUMINT NOT NULL, f FLOAT, PRIMARY KEY(n))ENGINE=INNODB;
12
CREATE TRIGGER test.t1_bi_t2 BEFORE INSERT ON test.t2 FOR EACH ROW INSERT INTO test.t1 VALUES (NULL, 1.234)//
13
INSERT INTO test.t2 VALUES (1, 0.0);
14
INSERT INTO test.t2 VALUES (1, 0.0);
15
Got one of the listed errors
16
select * from test.t1;
19
select * from test.t2;
22
select * from test.t1;
25
select * from test.t2;
28
DROP TRIGGER test.t1_bi_t2;