Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
2 CREATE TABLE t2 (b INT) ENGINE=InnoDB;
3 CREATE TABLE t3 (c INT) ENGINE=InnoDB;
4 CREATE TRIGGER tr BEFORE INSERT ON t3 FOR EACH ROW BEGIN SAVEPOINT sv; INSERT INTO t2 VALUES (0); END $$
5 START TRANSACTION;
6 DELETE FROM t1;
7 connect con1,localhost,root,,test;
8 START TRANSACTION;
9 INSERT INTO t2 VALUES (2);
10 UPDATE t2 SET b = b+1;
11 INSERT INTO t1 VALUES (1);
12 connection default;
13 COMMIT;
14 connection con1;
15 COMMIT;
16 disconnect con1;
17 connection default;
18 SELECT * FROM t1;
19 a
20 1
21 SELECT * FROM t2;
22 b
23 3
24 SELECT * FROM t3;
25 c
26 DROP TABLE t1, t2, t3;
27 DROP TRIGGER tr;
28 ERROR HY000: Trigger does not exist