Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/count_sessions.inc
3
4 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
5 CREATE TABLE t2 (b INT) ENGINE=InnoDB;
6 CREATE TABLE t3 (c INT) ENGINE=InnoDB;
7
8 --delimiter $$
9 CREATE TRIGGER tr BEFORE INSERT ON t3 FOR EACH ROW BEGIN SAVEPOINT sv; INSERT INTO t2 VALUES (0); END $$
10 --delimiter ;
11
12 START TRANSACTION;
13 DELETE FROM t1;
14
15 connect (con1,localhost,root,,test);
16 START TRANSACTION;
17 INSERT INTO t2 VALUES (2);
18 UPDATE t2 SET b = b+1;
19
20 --send
21 INSERT INTO t1 VALUES (1);
22
23 connection default;
24 let $wait_condition=
25 select count(*) = 1 from information_schema.processlist
26 where state = 'update' and info = 'INSERT INTO t1 VALUES (1)'
27 --source include/wait_condition.inc
28
29 --error ER_LOCK_DEADLOCK
30 INSERT INTO t3 VALUES (2);
31 COMMIT;
32
33 connection con1;
34 reap;
35 COMMIT;
36 disconnect con1;
37
38 connection default;
39 SELECT * FROM t1;
40 SELECT * FROM t2;
41 SELECT * FROM t3;
42
43 DROP TABLE t1, t2, t3;
44 --error ER_TRG_DOES_NOT_EXIST
45 DROP TRIGGER tr;
46
47 --source include/wait_until_count_sessions.inc