Debian Codegraph @

mysql-test/suite/galera/r/lp1438990.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
5 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY);
6 CREATE TABLE t3 (f1 INTEGER PRIMARY KEY);
7 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW CALL p1(NEW.f1);
8 CREATE PROCEDURE p1 (IN x INT)
9 BEGIN
10 DECLARE EXIT HANDLER FOR SQLEXCEPTION
11 BEGIN
12 ROLLBACK TO event_logging;
13 INSERT t3 VALUES (x);
14 END;
15 SAVEPOINT event_logging;
16 INSERT INTO t2 VALUES (x);
17 RELEASE SAVEPOINT event_logging;
18 END|
19 INSERT INTO t2 VALUES (1);
20 INSERT INTO t1 VALUES (1);
21 DROP PROCEDURE p1;
22 DROP TABLE t1;
23 DROP TABLE t2;
24 DROP TABLE t3;