Debian Codegraph @

mysql-test/suite/innodb/t/trigger_error.test

raw
1 --source include/have_innodb.inc
2
3 CREATE TABLE t1 (i INT) ENGINE=InnoDB;
4 CREATE TABLE t2 (i INT) ENGINE=InnoDB;
5
6 CREATE OR REPLACE TRIGGER tr1
7 AFTER UPDATE ON t2
8 FOR EACH ROW
9 INSERT INTO tlog (i) VALUES (1);
10
11 INSERT IGNORE INTO t2 VALUES (1);
12
13 CREATE TRIGGER IF NOT EXISTS tr2
14 BEFORE INSERT ON t2
15 FOR EACH ROW
16 INSERT INTO tlog (i) VALUES (2);
17
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (1);
20 --error ER_NO_SUCH_TABLE
21 UPDATE t2 SET i = 3;
22 INSERT INTO t1 VALUES (2);
23 --error ER_NO_SUCH_TABLE
24 INSERT INTO t2 VALUES (4);
25 UPDATE t1 SET i = 4 LIMIT 1;
26 COMMIT;
27
28 SELECT * FROM t1;
29 SELECT * FROM t2;
30
31 DROP TABLE t1,t2;