Debian Codegraph @

mysql-test/suite/atomic/create_trigger.result

raw
1 RESET MASTER;
2 "engine: aria crash point: ddl_log_create_before_create_trigger position: 1"
3 "engine: aria crash point: ddl_log_create_before_create_trigger position: 2"
4 t1.TRG
5 t1_trg.TRN
6 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
7 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
8 begin
9 if isnull(new.a) then
10 set new.a:= 1000;
11 end if;
12 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
13 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
14 begin
15 if isnull(new.a) then
16 set new.a:= 1000;
17 end if;
18 end
19 "engine: aria crash point: ddl_log_create_before_create_trigger position: 3"
20 t1.TRG
21 t1_trg.TRN
22 t2_trg.TRN
23 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
24 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
25 begin
26 if isnull(new.a) then
27 set new.a:= 1000;
28 end if;
29 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
30 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
31 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
32 begin
33 if isnull(new.b) then
34 set new.b:= 2000;
35 end if;
36 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
37 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
38 begin
39 if isnull(new.a) then
40 set new.a:= 1000;
41 end if;
42 end
43 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
44 begin
45 if isnull(new.b) then
46 set new.b:= 2000;
47 end if;
48 end
49 "engine: aria crash point: ddl_log_create_after_create_trigger position: 1"
50 "engine: aria crash point: ddl_log_create_after_create_trigger position: 2"
51 t1.TRG
52 t1_trg.TRN
53 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
54 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
55 begin
56 if isnull(new.a) then
57 set new.a:= 1000;
58 end if;
59 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
60 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
61 begin
62 if isnull(new.a) then
63 set new.a:= 1000;
64 end if;
65 end
66 "engine: aria crash point: ddl_log_create_after_create_trigger position: 3"
67 t1.TRG
68 t1_trg.TRN
69 t2_trg.TRN
70 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
71 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
72 begin
73 if isnull(new.a) then
74 set new.a:= 1000;
75 end if;
76 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
77 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
78 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
79 begin
80 if isnull(new.b) then
81 set new.b:= 2000;
82 end if;
83 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
84 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
85 begin
86 if isnull(new.a) then
87 set new.a:= 1000;
88 end if;
89 end
90 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
91 begin
92 if isnull(new.b) then
93 set new.b:= 2000;
94 end if;
95 end
96 "engine: aria crash point: definition_file_after_create position: 1"
97 "engine: aria crash point: definition_file_after_create position: 2"
98 "engine: aria crash point: definition_file_after_create position: 3"
99 t1.TRG
100 t1_trg.TRN
101 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
102 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
103 begin
104 if isnull(new.a) then
105 set new.a:= 1000;
106 end if;
107 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
108 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
109 begin
110 if isnull(new.a) then
111 set new.a:= 1000;
112 end if;
113 end
114 "engine: aria crash point: ddl_log_drop_before_binlog position: 1"
115 "engine: aria crash point: ddl_log_drop_before_binlog position: 2"
116 t1.TRG
117 t1_trg.TRN
118 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
119 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
120 begin
121 if isnull(new.a) then
122 set new.a:= 1000;
123 end if;
124 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
125 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
126 begin
127 if isnull(new.a) then
128 set new.a:= 1000;
129 end if;
130 end
131 "engine: aria crash point: ddl_log_drop_before_binlog position: 3"
132 t1.TRG
133 t1_trg.TRN
134 t2_trg.TRN
135 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
136 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
137 begin
138 if isnull(new.a) then
139 set new.a:= 1000;
140 end if;
141 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
142 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
143 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
144 begin
145 if isnull(new.b) then
146 set new.b:= 2000;
147 end if;
148 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
149 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
150 begin
151 if isnull(new.a) then
152 set new.a:= 1000;
153 end if;
154 end
155 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
156 begin
157 if isnull(new.b) then
158 set new.b:= 2000;
159 end if;
160 end
161 "engine: aria crash point: ddl_log_drop_after_binlog position: 1"
162 t1.TRG
163 t1_trg.TRN
164 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
165 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
166 begin
167 if isnull(new.a) then
168 set new.a:= 1000;
169 end if;
170 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
171 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
172 begin
173 if isnull(new.a) then
174 set new.a:= 1000;
175 end if;
176 end
177 "engine: aria crash point: ddl_log_drop_after_binlog position: 2"
178 t1.TRG
179 t1_trg.TRN
180 t2_trg.TRN
181 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
182 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
183 begin
184 if isnull(new.a) then
185 set new.a:= 1000;
186 end if;
187 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
188 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
189 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
190 begin
191 if isnull(new.b) then
192 set new.b:= 2000;
193 end if;
194 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
195 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
196 begin
197 if isnull(new.a) then
198 set new.a:= 1000;
199 end if;
200 end
201 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
202 begin
203 if isnull(new.b) then
204 set new.b:= 2000;
205 end if;
206 end
207 "engine: aria crash point: ddl_log_drop_after_binlog position: 3"
208 t1.TRG
209 t1_trg.TRN
210 t2_trg.TRN
211 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
212 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
213 begin
214 if isnull(new.a) then
215 set new.a:= 1000;
216 end if;
217 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
218 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
219 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
220 begin
221 if isnull(new.b) then
222 set new.b:= 3000;
223 end if;
224 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
225 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
226 begin
227 if isnull(new.a) then
228 set new.a:= 1000;
229 end if;
230 end
231 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
232 begin
233 if isnull(new.b) then
234 set new.b:= 2000;
235 end if;
236 end
237 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
238 begin
239 if isnull(new.b) then
240 set new.b:= 3000;
241 end if;
242 end
243 "engine: aria crash point: ddl_log_drop_before_delete_tmp position: 1"
244 t1.TRG
245 t1_trg.TRN
246 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
247 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
248 begin
249 if isnull(new.a) then
250 set new.a:= 1000;
251 end if;
252 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
253 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
254 begin
255 if isnull(new.a) then
256 set new.a:= 1000;
257 end if;
258 end
259 "engine: aria crash point: ddl_log_drop_before_delete_tmp position: 2"
260 t1.TRG
261 t1_trg.TRN
262 t2_trg.TRN
263 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
264 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
265 begin
266 if isnull(new.a) then
267 set new.a:= 1000;
268 end if;
269 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
270 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
271 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
272 begin
273 if isnull(new.b) then
274 set new.b:= 2000;
275 end if;
276 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
277 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
278 begin
279 if isnull(new.a) then
280 set new.a:= 1000;
281 end if;
282 end
283 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
284 begin
285 if isnull(new.b) then
286 set new.b:= 2000;
287 end if;
288 end
289 "engine: aria crash point: ddl_log_drop_before_delete_tmp position: 3"
290 t1.TRG
291 t1_trg.TRN
292 t2_trg.TRN
293 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
294 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
295 begin
296 if isnull(new.a) then
297 set new.a:= 1000;
298 end if;
299 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
300 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
301 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
302 begin
303 if isnull(new.b) then
304 set new.b:= 3000;
305 end if;
306 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
307 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER t1_trg before insert on t1 for each row
308 begin
309 if isnull(new.a) then
310 set new.a:= 1000;
311 end if;
312 end
313 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
314 begin
315 if isnull(new.b) then
316 set new.b:= 2000;
317 end if;
318 end
319 master-bin.000001 # Query # # use `test`; CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER t2_trg before insert on t1 for each row
320 begin
321 if isnull(new.b) then
322 set new.b:= 3000;
323 end if;
324 end