Debian Codegraph @

mysql-test/suite/galera/t/lp1438990.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --connection node_1
5
6 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
7 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY);
8 CREATE TABLE t3 (f1 INTEGER PRIMARY KEY);
9
10 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW CALL p1(NEW.f1);
11
12
13 DELIMITER |;
14
15 CREATE PROCEDURE p1 (IN x INT)
16 BEGIN
17 DECLARE EXIT HANDLER FOR SQLEXCEPTION
18 BEGIN
19 ROLLBACK TO event_logging;
20 INSERT t3 VALUES (x);
21 END;
22 SAVEPOINT event_logging;
23
24 INSERT INTO t2 VALUES (x);
25
26 RELEASE SAVEPOINT event_logging;
27 END|
28 DELIMITER ;|
29
30
31 INSERT INTO t2 VALUES (1);
32 INSERT INTO t1 VALUES (1);
33
34 DROP PROCEDURE p1;
35
36 DROP TABLE t1;
37 DROP TABLE t2;
38 DROP TABLE t3;