Debian Codegraph @

mysql-test/suite/innodb/r/trigger_error.result

raw
1 CREATE TABLE t1 (i INT) ENGINE=InnoDB;
2 CREATE TABLE t2 (i INT) ENGINE=InnoDB;
3 CREATE OR REPLACE TRIGGER tr1
4 AFTER UPDATE ON t2
5 FOR EACH ROW
6 INSERT INTO tlog (i) VALUES (1);
7 INSERT IGNORE INTO t2 VALUES (1);
8 CREATE TRIGGER IF NOT EXISTS tr2
9 BEFORE INSERT ON t2
10 FOR EACH ROW
11 INSERT INTO tlog (i) VALUES (2);
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (1);
14 UPDATE t2 SET i = 3;
15 ERROR 42S02: Table 'test.tlog' doesn't exist
16 INSERT INTO t1 VALUES (2);
17 INSERT INTO t2 VALUES (4);
18 ERROR 42S02: Table 'test.tlog' doesn't exist
19 UPDATE t1 SET i = 4 LIMIT 1;
20 COMMIT;
21 SELECT * FROM t1;
22 i
23 4
24 2
25 SELECT * FROM t2;
26 i
27 1
28 DROP TABLE t1,t2;