Debian Codegraph @

mysql-test/suite/galera/r/mysql-wsrep#110.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 END|
18 INSERT INTO t2 VALUES (1);
19 INSERT INTO t1 VALUES (1);
20 SELECT COUNT(*) = 1 FROM t1;
21 COUNT(*) = 1
22 1
23 SELECT COUNT(*) = 1 FROM t2;
24 COUNT(*) = 1
25 1
26 SELECT COUNT(*) = 1 FROM t3;
27 COUNT(*) = 1
28 1
29 connection node_2;
30 SELECT COUNT(*) = 1 FROM t1;
31 COUNT(*) = 1
32 1
33 SELECT COUNT(*) = 1 FROM t2;
34 COUNT(*) = 1
35 1
36 SELECT COUNT(*) = 1 FROM t3;
37 COUNT(*) = 1
38 1
39 connection node_1;
40 DROP TABLE t1;
41 DROP TABLE t2;
42 DROP TABLE t3;
43 DROP PROCEDURE p1;