Debian Codegraph @

mysql-test/suite/rpl/r/mysql-wsrep#110-2.result

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