Debian Codegraph @

mysql-test/suite/innodb/r/ddl_crash_alter_table.result

raw
1 CREATE TABLE t1
2 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
3 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
4 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
5 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
6 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
7 DROP TABLE t1;
8 CREATE TABLE t1
9 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
10 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
11 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
12 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
13 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
14 DROP TABLE t1;
15 CREATE TABLE t1
16 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
17 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
18 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
19 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
20 # No such crash injection, statement did not crash, cleaning up
21 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
22 DROP TABLE t1;
23 CREATE TABLE t1
24 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
25 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
26 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
27 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
28 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
29 DROP TABLE t1;
30 CREATE TABLE t1
31 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
32 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
33 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
34 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
35 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
36 DROP TABLE t1;
37 CREATE TABLE t1
38 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
39 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
40 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
41 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
42 # No such crash injection, statement did not crash, cleaning up
43 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
44 DROP TABLE t1;
45 CREATE TABLE t1
46 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
47 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
48 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
49 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
50 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
51 DROP TABLE t1;
52 CREATE TABLE t1
53 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
54 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
55 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
56 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
57 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
58 DROP TABLE t1;
59 CREATE TABLE t1
60 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
61 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
62 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
63 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
64 # No such crash injection, statement did not crash, cleaning up
65 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
66 DROP TABLE t1;
67 CREATE TABLE t1
68 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
69 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
70 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_1';
71 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
72 # No such crash injection, statement did not crash, cleaning up
73 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_1';
74 DROP TABLE t1;
75 CREATE TABLE t1
76 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
77 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
78 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
79 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
80 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
81 DROP TABLE t1;
82 CREATE TABLE t1
83 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
84 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
85 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
86 ALTER TABLE t1 ADD INDEX (b), ADD INDEX(c), ALGORITHM=INPLACE;
87 # No such crash injection, statement did not crash, cleaning up
88 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
89 DROP TABLE t1;
90 CREATE TABLE t1
91 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
92 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
93 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
94 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
95 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
96 DROP TABLE t1;
97 CREATE TABLE t1
98 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
99 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
100 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
101 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
102 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
103 DROP TABLE t1;
104 CREATE TABLE t1
105 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
106 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
107 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
108 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
109 # No such crash injection, statement did not crash, cleaning up
110 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
111 DROP TABLE t1;
112 CREATE TABLE t1
113 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
114 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
115 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
116 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
117 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
118 DROP TABLE t1;
119 CREATE TABLE t1
120 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
121 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
122 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
123 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
124 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
125 DROP TABLE t1;
126 CREATE TABLE t1
127 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
128 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
129 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
130 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
131 # No such crash injection, statement did not crash, cleaning up
132 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
133 DROP TABLE t1;
134 CREATE TABLE t1
135 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
136 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
137 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
138 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
139 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
140 DROP TABLE t1;
141 CREATE TABLE t1
142 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
143 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
144 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
145 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
146 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
147 DROP TABLE t1;
148 CREATE TABLE t1
149 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
150 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
151 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
152 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
153 # No such crash injection, statement did not crash, cleaning up
154 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
155 DROP TABLE t1;
156 CREATE TABLE t1
157 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
158 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
159 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
160 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
161 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
162 DROP TABLE t1;
163 CREATE TABLE t1
164 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
165 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
166 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
167 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
168 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
169 DROP TABLE t1;
170 CREATE TABLE t1
171 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
172 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
173 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
174 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
175 # No such crash injection, statement did not crash, cleaning up
176 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
177 DROP TABLE t1;
178 CREATE TABLE t1
179 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
180 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
181 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
182 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
183 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
184 DROP TABLE t1;
185 CREATE TABLE t1
186 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
187 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
188 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
189 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
190 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
191 DROP TABLE t1;
192 CREATE TABLE t1
193 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
194 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
195 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
196 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
197 # No such crash injection, statement did not crash, cleaning up
198 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
199 DROP TABLE t1;
200 CREATE TABLE t1
201 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
202 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
203 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
204 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
205 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
206 DROP TABLE t1;
207 CREATE TABLE t1
208 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
209 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
210 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
211 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
212 # No such crash injection, statement did not crash, cleaning up
213 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
214 DROP TABLE t1;
215 CREATE TABLE t1
216 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
217 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
218 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
219 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
220 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
221 DROP TABLE t1;
222 CREATE TABLE t1
223 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
224 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
225 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
226 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
227 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
228 DROP TABLE t1;
229 CREATE TABLE t1
230 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
231 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
232 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
233 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
234 # No such crash injection, statement did not crash, cleaning up
235 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
236 DROP TABLE t1;
237 CREATE TABLE t1
238 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
239 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
240 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
241 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
242 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
243 DROP TABLE t1;
244 CREATE TABLE t1
245 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
246 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
247 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
248 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
249 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
250 DROP TABLE t1;
251 CREATE TABLE t1
252 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
253 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
254 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
255 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
256 # No such crash injection, statement did not crash, cleaning up
257 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
258 DROP TABLE t1;
259 CREATE TABLE t1
260 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
261 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
262 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
263 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
264 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
265 DROP TABLE t1;
266 CREATE TABLE t1
267 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
268 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
269 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
270 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
271 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
272 DROP TABLE t1;
273 CREATE TABLE t1
274 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
275 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
276 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
277 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
278 # No such crash injection, statement did not crash, cleaning up
279 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
280 DROP TABLE t1;
281 CREATE TABLE t1
282 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
283 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
284 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
285 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
286 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
287 DROP TABLE t1;
288 CREATE TABLE t1
289 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
290 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
291 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
292 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
293 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
294 DROP TABLE t1;
295 CREATE TABLE t1
296 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
297 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
298 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
299 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
300 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
301 DROP TABLE t1;
302 CREATE TABLE t1
303 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
304 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
305 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
306 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
307 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
308 DROP TABLE t1;
309 CREATE TABLE t1
310 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
311 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
312 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
313 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
314 # No such crash injection, statement did not crash, cleaning up
315 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
316 DROP TABLE t1;
317 CREATE TABLE t1
318 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
319 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
320 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
321 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
322 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
323 DROP TABLE t1;
324 CREATE TABLE t1
325 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
326 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
327 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
328 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
329 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
330 DROP TABLE t1;
331 CREATE TABLE t1
332 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
333 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
334 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
335 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
336 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
337 DROP TABLE t1;
338 CREATE TABLE t1
339 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
340 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
341 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
342 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
343 # No such crash injection, statement did not crash, cleaning up
344 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
345 DROP TABLE t1;
346 CREATE TABLE t1
347 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
348 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
349 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
350 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
351 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
352 DROP TABLE t1;
353 CREATE TABLE t1
354 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
355 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
356 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
357 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
358 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
359 DROP TABLE t1;
360 CREATE TABLE t1
361 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
362 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
363 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
364 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
365 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
366 DROP TABLE t1;
367 CREATE TABLE t1
368 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
369 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
370 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
371 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
372 # No such crash injection, statement did not crash, cleaning up
373 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
374 DROP TABLE t1;
375 CREATE TABLE t1
376 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
377 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
378 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
379 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
380 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
381 DROP TABLE t1;
382 CREATE TABLE t1
383 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
384 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
385 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
386 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
387 # No such crash injection, statement did not crash, cleaning up
388 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
389 DROP TABLE t1;
390 CREATE TABLE t1
391 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
392 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
393 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
394 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
395 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
396 DROP TABLE t1;
397 CREATE TABLE t1
398 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
399 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
400 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
401 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
402 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
403 DROP TABLE t1;
404 CREATE TABLE t1
405 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
406 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
407 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
408 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
409 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
410 DROP TABLE t1;
411 CREATE TABLE t1
412 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c));
413 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
414 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
415 ALTER TABLE t1 DROP INDEX b, DROP INDEX c, ADD INDEX( c, b), ALGORITHM=INPLACE;
416 # No such crash injection, statement did not crash, cleaning up
417 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
418 DROP TABLE t1;
419 CREATE TABLE t1
420 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
421 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
422 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
423 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
424 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
425 DROP TABLE t1;
426 CREATE TABLE t1
427 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
428 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
429 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
430 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
431 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
432 DROP TABLE t1;
433 CREATE TABLE t1
434 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
435 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
436 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
437 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
438 # No such crash injection, statement did not crash, cleaning up
439 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
440 DROP TABLE t1;
441 CREATE TABLE t1
442 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
443 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
444 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
445 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
446 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
447 DROP TABLE t1;
448 CREATE TABLE t1
449 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
450 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
451 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
452 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
453 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
454 DROP TABLE t1;
455 CREATE TABLE t1
456 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
457 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
458 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
459 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
460 # No such crash injection, statement did not crash, cleaning up
461 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
462 DROP TABLE t1;
463 CREATE TABLE t1
464 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
465 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
466 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
467 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
468 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
469 DROP TABLE t1;
470 CREATE TABLE t1
471 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
472 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
473 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
474 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
475 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
476 DROP TABLE t1;
477 CREATE TABLE t1
478 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
479 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
480 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
481 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
482 # No such crash injection, statement did not crash, cleaning up
483 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
484 DROP TABLE t1;
485 CREATE TABLE t1
486 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
487 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
488 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
489 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
490 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
491 DROP TABLE t1;
492 CREATE TABLE t1
493 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
494 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
495 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
496 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
497 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
498 DROP TABLE t1;
499 CREATE TABLE t1
500 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
501 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
502 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
503 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
504 # No such crash injection, statement did not crash, cleaning up
505 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
506 DROP TABLE t1;
507 CREATE TABLE t1
508 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
509 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
510 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
511 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
512 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
513 DROP TABLE t1;
514 CREATE TABLE t1
515 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
516 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
517 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
518 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
519 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
520 DROP TABLE t1;
521 CREATE TABLE t1
522 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
523 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
524 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
525 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
526 # No such crash injection, statement did not crash, cleaning up
527 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
528 DROP TABLE t1;
529 CREATE TABLE t1
530 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
531 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
532 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
533 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
534 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
535 DROP TABLE t1;
536 CREATE TABLE t1
537 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
538 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
539 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
540 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
541 # No such crash injection, statement did not crash, cleaning up
542 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
543 DROP TABLE t1;
544 CREATE TABLE t1
545 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
546 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
547 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
548 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
549 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
550 DROP TABLE t1;
551 CREATE TABLE t1
552 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
553 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
554 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
555 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
556 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
557 DROP TABLE t1;
558 CREATE TABLE t1
559 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
560 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
561 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
562 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
563 # No such crash injection, statement did not crash, cleaning up
564 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
565 DROP TABLE t1;
566 CREATE TABLE t1
567 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
568 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
569 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
570 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
571 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
572 DROP TABLE t1;
573 CREATE TABLE t1
574 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
575 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
576 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
577 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
578 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
579 DROP TABLE t1;
580 CREATE TABLE t1
581 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
582 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
583 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
584 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
585 # No such crash injection, statement did not crash, cleaning up
586 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
587 DROP TABLE t1;
588 CREATE TABLE t1
589 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
590 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
591 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
592 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
593 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
594 DROP TABLE t1;
595 CREATE TABLE t1
596 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
597 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
598 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
599 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
600 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
601 DROP TABLE t1;
602 CREATE TABLE t1
603 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
604 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
605 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
606 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
607 # No such crash injection, statement did not crash, cleaning up
608 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
609 DROP TABLE t1;
610 CREATE TABLE t1
611 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
612 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
613 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
614 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
615 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
616 DROP TABLE t1;
617 CREATE TABLE t1
618 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
619 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
620 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
621 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
622 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
623 DROP TABLE t1;
624 CREATE TABLE t1
625 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
626 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
627 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
628 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
629 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
630 DROP TABLE t1;
631 CREATE TABLE t1
632 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL);
633 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
634 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
635 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
636 # No such crash injection, statement did not crash, cleaning up
637 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
638 DROP TABLE t1;
639 SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;