Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SAVEPOINT in a stored function should be forbidden
5 CREATE FUNCTION f1 () RETURNS INT BEGIN
6 SAVEPOINT s;
7 RETURN 1;
8 END|
9 SELECT f1();
10 f1()
11 1
12 DROP FUNCTION f1;
13 ROLLBACK TO SAVEPOINT in a stored function should be forbidden
14 CREATE FUNCTION f2 () RETURNS INT BEGIN
15 ROLLBACK TO SAVEPOINT s;
16 RETURN 1;
17 END|
18 BEGIN;
19 SAVEPOINT s;
20 SELECT f2();
21 ERROR 42000: SAVEPOINT s does not exist
22 COMMIT;
23 DROP FUNCTION f2;
24 BEGIN;
25 SAVEPOINT S;
26 ROLLBACK TO SAVEPOINT S;
27 COMMIT;
28 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
29 CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
30 INSERT INTO t1 values (110), (111), (112), (113), (114);
31 Direct SAVEPOINT in a trigger should be forbidden
32 connection node_2;
33 CREATE TRIGGER i1_t1 BEFORE INSERT ON t1 FOR EACH ROW SAVEPOINT s;
34 connection node_1;
35 INSERT INTO t1 VALUES (1);
36 DROP TRIGGER i1_t1;
37 CREATE TRIGGER i2_t1 AFTER INSERT ON t1 FOR EACH ROW SAVEPOINT s;
38 INSERT INTO t1 VALUES (2);
39 DROP TRIGGER i2_t1;
40 INSERT INTO t1 VALUES (3);
41 CREATE TRIGGER u1_t1 BEFORE UPDATE ON t1 FOR EACH ROW SAVEPOINT s;
42 UPDATE t1 SET a=4 WHERE a=3;
43 DROP TRIGGER u1_t1;
44 CREATE TRIGGER u2_t1 AFTER UPDATE ON t1 FOR EACH ROW SAVEPOINT s;
45 UPDATE t1 SET a=4 WHERE a=3;
46 DROP TRIGGER u2_t1;
47 CREATE TRIGGER d1_t1 BEFORE DELETE ON t1 FOR EACH ROW SAVEPOINT s;
48 DELETE FROM t1;
49 DROP TRIGGER d1_t1;
50 CREATE TRIGGER d1_t1 AFTER DELETE ON t1 FOR EACH ROW SAVEPOINT s;
51 DELETE FROM t1;
52 DROP TRIGGER d1_t1;
53 SAVEPOINT in a compound statement in a trigger should be forbidden
54 CREATE TRIGGER i3_t1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
55 SAVEPOINT s;
56 END|
57 INSERT INTO t1 VALUES (5);
58 DROP TRIGGER i3_t1;
59 SAVEPOINT in a PS call in a trigger should be forbidden
60 CREATE TRIGGER i4_t1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN
61 PREPARE set_savepoint FROM "SAVEPOINT s";
62 EXECUTE set_savepoint;
63 DEALLOCATE PREPARE set_savepoint;
64 END|
65 ERROR 0A000: Dynamic SQL is not allowed in stored function or trigger
66 connection node_2;
67 SAVEPOINT in SP called from a trigger should be forbidden
68 CREATE PROCEDURE p1() BEGIN
69 SAVEPOINT s;
70 END|
71 connection node_1;
72 CREATE TRIGGER i5_t1 BEFORE INSERT ON t1 FOR EACH ROW CALL p1;
73 INSERT INTO t1 VALUES (6);
74 DROP TRIGGER i5_t1;
75 SAVEPOINT in a SP called from a PS called from a trigger be forbidden
76 PREPARE call_p1 FROM "CALL p1";
77 CREATE TRIGGER i6_t1 BEFORE INSERT ON t1 FOR EACH ROW EXECUTE call_p1;
78 ERROR 0A000: Dynamic SQL is not allowed in stored function or trigger
79 SAVEPOINT in a function called from a trigger should be forbidden
80 CREATE FUNCTION f1 () RETURNS INT BEGIN
81 SAVEPOINT s;
82 RETURN 1;
83 END|
84 CREATE TRIGGER i7_t1 BEFORE INSERT ON t1 FOR EACH ROW SET @foo = f1();
85 INSERT INTO t1 VALUES (7);
86 DROP TRIGGER i7_t1;
87 SAVEPOINT in a SP called from a SP called from a trigger should be forbidden
88 CREATE PROCEDURE p2() BEGIN
89 CALL p1();
90 END|
91 CREATE TRIGGER i8_t1 BEFORE INSERT ON t1 FOR EACH ROW CALL p2;
92 INSERT INTO t1 VALUES (8);
93 DROP TRIGGER i8_t1;
94 SAVEPOINT in a SP called from a trigger called from a SP should be forbidden
95 CREATE TRIGGER i9_t1 BEFORE INSERT ON t1 FOR EACH ROW CALL p1;
96 CREATE PROCEDURE p3() BEGIN
97 INSERT INTO t1 VALUES (9);
98 END|
99 CALL p3();
100 DROP TRIGGER i9_t1;
101 ROLLBACK TO SAVEPOINT in trigger as a trivial statement should be forbidden
102 CREATE TRIGGER i4_t1 BEFORE INSERT ON t1 FOR EACH ROW ROLLBACK TO SAVEPOINT s;
103 BEGIN;
104 SAVEPOINT s;
105 INSERT INTO t1 VALUES (5);
106 ERROR 42000: SAVEPOINT s does not exist
107 COMMIT;
108 DROP TRIGGER i4_t1;
109 ROLLBACK TO SAVEPOINT in a trigger in a SP call should be forbidden
110 CREATE PROCEDURE p4() BEGIN
111 ROLLBACK TO SAVEPOINT s;
112 END|
113 CREATE TRIGGER i5_t1 BEFORE INSERT ON t1 FOR EACH ROW CALL p4;
114 BEGIN;
115 SAVEPOINT s;
116 INSERT INTO t1 VALUES (6);
117 ERROR 42000: SAVEPOINT s does not exist
118 COMMIT;
119 DROP TRIGGER i5_t1;
120 SAVEPOINT in a SP next to a trigger should work
121 CREATE TRIGGER i6_t1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a = NEW.a + 1;
122 CREATE PROCEDURE p5() BEGIN
123 SAVEPOINT s;
124 INSERT INTO t1 VALUES (10);
125 ROLLBACK TO SAVEPOINT s;
126 END|
127 BEGIN;
128 CALL p5();
129 COMMIT;
130 DROP TRIGGER i6_t1;
131 connection node_2;
132 create trigger t1 before insert on t1 for each row
133 begin
134 insert into t2 values (NULL);
135 end|
136 connection node_1;
137 INSERT INTO t1 VALUES (201), (202), (203);
138 connection node_1;
139 SELECT * FROM t1;
140 a
141 5
142 6
143 7
144 8
145 9
146 201
147 202
148 203
149 SELECT COUNT(*) FROM t2;
150 COUNT(*)
151 3
152 connection node_2;
153 SELECT * FROM t1;
154 a
155 5
156 6
157 7
158 8
159 9
160 201
161 202
162 203
163 SELECT COUNT(*) FROM t2;
164 COUNT(*)
165 3
166 connection node_1;
167 DEALLOCATE PREPARE call_p1;
168 connection node_2;
169 DROP TABLE t1, t2;
170 DROP PROCEDURE p1;
171 DROP PROCEDURE p2;
172 DROP PROCEDURE p3;
173 DROP PROCEDURE p4;
174 DROP PROCEDURE p5;
175 DROP FUNCTION f1;