Debian Codegraph @

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

raw
1 CREATE TABLE t1
2 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
3 PARTITION BY HASH(a) PARTITIONS 3;
4 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
5 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
6 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
7 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
8 DROP TABLE t1;
9 CREATE TABLE t1
10 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
11 PARTITION BY HASH(a) PARTITIONS 3;
12 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
13 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
14 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
15 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
16 DROP TABLE t1;
17 CREATE TABLE t1
18 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
19 PARTITION BY HASH(a) PARTITIONS 3;
20 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
21 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
22 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
23 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
24 DROP TABLE t1;
25 CREATE TABLE t1
26 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
27 PARTITION BY HASH(a) PARTITIONS 3;
28 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
29 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
30 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
31 # No such crash injection, statement did not crash, cleaning up
32 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
33 DROP TABLE t1;
34 CREATE TABLE t1
35 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
36 PARTITION BY HASH(a) PARTITIONS 3;
37 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
38 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
39 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
40 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
41 DROP TABLE t1;
42 CREATE TABLE t1
43 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
44 PARTITION BY HASH(a) PARTITIONS 3;
45 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
46 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
47 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
48 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
49 DROP TABLE t1;
50 CREATE TABLE t1
51 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
52 PARTITION BY HASH(a) PARTITIONS 3;
53 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
54 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
55 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
56 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
57 DROP TABLE t1;
58 CREATE TABLE t1
59 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
60 PARTITION BY HASH(a) PARTITIONS 3;
61 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
62 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
63 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
64 # No such crash injection, statement did not crash, cleaning up
65 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
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 PARTITION BY HASH(a) PARTITIONS 3;
70 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
71 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
72 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
73 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_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 PARTITION BY HASH(a) PARTITIONS 3;
78 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
79 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
80 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
81 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
82 DROP TABLE t1;
83 CREATE TABLE t1
84 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
85 PARTITION BY HASH(a) PARTITIONS 3;
86 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
87 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
88 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
89 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
90 DROP TABLE t1;
91 CREATE TABLE t1
92 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
93 PARTITION BY HASH(a) PARTITIONS 3;
94 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
95 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
96 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
97 # No such crash injection, statement did not crash, cleaning up
98 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
99 DROP TABLE t1;
100 CREATE TABLE t1
101 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
102 PARTITION BY HASH(a) PARTITIONS 3;
103 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
104 SET SESSION DEBUG = '+d,ddl_log_crash_after_drop_log_1';
105 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
106 # No such crash injection, statement did not crash, cleaning up
107 SET SESSION DEBUG = '-d,ddl_log_crash_after_drop_log_1';
108 DROP TABLE t1;
109 CREATE TABLE t1
110 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
111 PARTITION BY HASH(a) PARTITIONS 3;
112 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
113 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
114 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
115 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
116 DROP TABLE t1;
117 CREATE TABLE t1
118 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
119 PARTITION BY HASH(a) PARTITIONS 3;
120 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
121 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
122 ALTER TABLE t1 ADD INDEX (b), ALGORITHM=INPLACE;
123 # No such crash injection, statement did not crash, cleaning up
124 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
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 PARTITION BY HASH(a) PARTITIONS 3;
129 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
130 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
131 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
132 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
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 PARTITION BY HASH(a) PARTITIONS 3;
137 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
138 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
139 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
140 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
141 DROP TABLE t1;
142 CREATE TABLE t1
143 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
144 PARTITION BY HASH(a) PARTITIONS 3;
145 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
146 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
147 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
148 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
149 DROP TABLE t1;
150 CREATE TABLE t1
151 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
152 PARTITION BY HASH(a) PARTITIONS 3;
153 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
154 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
155 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
156 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
157 DROP TABLE t1;
158 CREATE TABLE t1
159 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
160 PARTITION BY HASH(a) PARTITIONS 3;
161 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
162 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
163 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
164 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
165 DROP TABLE t1;
166 CREATE TABLE t1
167 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
168 PARTITION BY HASH(a) PARTITIONS 3;
169 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
170 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
171 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
172 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
173 DROP TABLE t1;
174 CREATE TABLE t1
175 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
176 PARTITION BY HASH(a) PARTITIONS 3;
177 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
178 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
179 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
180 # No such crash injection, statement did not crash, cleaning up
181 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
182 DROP TABLE t1;
183 CREATE TABLE t1
184 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
185 PARTITION BY HASH(a) PARTITIONS 3;
186 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
187 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
188 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
189 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
190 DROP TABLE t1;
191 CREATE TABLE t1
192 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
193 PARTITION BY HASH(a) PARTITIONS 3;
194 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
195 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
196 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
197 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
198 DROP TABLE t1;
199 CREATE TABLE t1
200 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
201 PARTITION BY HASH(a) PARTITIONS 3;
202 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
203 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
204 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
205 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
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 PARTITION BY HASH(a) PARTITIONS 3;
210 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
211 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
212 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
213 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
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 PARTITION BY HASH(a) PARTITIONS 3;
218 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
219 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
220 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
221 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
222 DROP TABLE t1;
223 CREATE TABLE t1
224 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
225 PARTITION BY HASH(a) PARTITIONS 3;
226 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
227 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
228 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
229 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
230 DROP TABLE t1;
231 CREATE TABLE t1
232 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
233 PARTITION BY HASH(a) PARTITIONS 3;
234 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
235 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
236 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
237 # No such crash injection, statement did not crash, cleaning up
238 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
239 DROP TABLE t1;
240 CREATE TABLE t1
241 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
242 PARTITION BY HASH(a) PARTITIONS 3;
243 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
244 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
245 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
246 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
247 DROP TABLE t1;
248 CREATE TABLE t1
249 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
250 PARTITION BY HASH(a) PARTITIONS 3;
251 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
252 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
253 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
254 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
255 DROP TABLE t1;
256 CREATE TABLE t1
257 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
258 PARTITION BY HASH(a) PARTITIONS 3;
259 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
260 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
261 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
262 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
263 DROP TABLE t1;
264 CREATE TABLE t1
265 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
266 PARTITION BY HASH(a) PARTITIONS 3;
267 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
268 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
269 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
270 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
271 DROP TABLE t1;
272 CREATE TABLE t1
273 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
274 PARTITION BY HASH(a) PARTITIONS 3;
275 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
276 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_5';
277 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
278 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_5';
279 DROP TABLE t1;
280 CREATE TABLE t1
281 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
282 PARTITION BY HASH(a) PARTITIONS 3;
283 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
284 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_6';
285 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
286 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_6';
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 PARTITION BY HASH(a) PARTITIONS 3;
291 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
292 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_7';
293 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
294 # No such crash injection, statement did not crash, cleaning up
295 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_7';
296 DROP TABLE t1;
297 CREATE TABLE t1
298 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
299 PARTITION BY HASH(a) PARTITIONS 3;
300 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
301 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
302 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
303 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
304 DROP TABLE t1;
305 CREATE TABLE t1
306 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
307 PARTITION BY HASH(a) PARTITIONS 3;
308 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
309 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
310 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
311 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
312 DROP TABLE t1;
313 CREATE TABLE t1
314 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
315 PARTITION BY HASH(a) PARTITIONS 3;
316 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
317 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
318 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
319 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
320 DROP TABLE t1;
321 CREATE TABLE t1
322 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
323 PARTITION BY HASH(a) PARTITIONS 3;
324 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
325 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_4';
326 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
327 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_4';
328 DROP TABLE t1;
329 CREATE TABLE t1
330 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
331 PARTITION BY HASH(a) PARTITIONS 3;
332 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
333 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_5';
334 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
335 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_5';
336 DROP TABLE t1;
337 CREATE TABLE t1
338 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
339 PARTITION BY HASH(a) PARTITIONS 3;
340 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
341 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_6';
342 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
343 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_6';
344 DROP TABLE t1;
345 CREATE TABLE t1
346 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
347 PARTITION BY HASH(a) PARTITIONS 3;
348 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
349 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_7';
350 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
351 # No such crash injection, statement did not crash, cleaning up
352 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_7';
353 DROP TABLE t1;
354 CREATE TABLE t1
355 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
356 PARTITION BY HASH(a) PARTITIONS 3;
357 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
358 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
359 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
360 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
361 DROP TABLE t1;
362 CREATE TABLE t1
363 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
364 PARTITION BY HASH(a) PARTITIONS 3;
365 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
366 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
367 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
368 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
369 DROP TABLE t1;
370 CREATE TABLE t1
371 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
372 PARTITION BY HASH(a) PARTITIONS 3;
373 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
374 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
375 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
376 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
377 DROP TABLE t1;
378 CREATE TABLE t1
379 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
380 PARTITION BY HASH(a) PARTITIONS 3;
381 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
382 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_4';
383 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
384 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_4';
385 DROP TABLE t1;
386 CREATE TABLE t1
387 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
388 PARTITION BY HASH(a) PARTITIONS 3;
389 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
390 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_5';
391 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
392 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_5';
393 DROP TABLE t1;
394 CREATE TABLE t1
395 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
396 PARTITION BY HASH(a) PARTITIONS 3;
397 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
398 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_6';
399 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
400 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_6';
401 DROP TABLE t1;
402 CREATE TABLE t1
403 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
404 PARTITION BY HASH(a) PARTITIONS 3;
405 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
406 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_7';
407 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
408 # No such crash injection, statement did not crash, cleaning up
409 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_7';
410 DROP TABLE t1;
411 CREATE TABLE t1
412 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
413 PARTITION BY HASH(a) PARTITIONS 3;
414 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
415 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
416 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
417 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
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 PARTITION BY HASH(a) PARTITIONS 3;
422 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
423 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
424 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
425 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
426 DROP TABLE t1;
427 CREATE TABLE t1
428 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
429 PARTITION BY HASH(a) PARTITIONS 3;
430 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
431 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_3';
432 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
433 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_3';
434 DROP TABLE t1;
435 CREATE TABLE t1
436 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
437 PARTITION BY HASH(a) PARTITIONS 3;
438 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
439 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_4';
440 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
441 # No such crash injection, statement did not crash, cleaning up
442 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_4';
443 DROP TABLE t1;
444 CREATE TABLE t1
445 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
446 PARTITION BY HASH(a) PARTITIONS 3;
447 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
448 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
449 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
450 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
451 DROP TABLE t1;
452 CREATE TABLE t1
453 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
454 PARTITION BY HASH(a) PARTITIONS 3;
455 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
456 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
457 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
458 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
459 DROP TABLE t1;
460 CREATE TABLE t1
461 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
462 PARTITION BY HASH(a) PARTITIONS 3;
463 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
464 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
465 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
466 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
467 DROP TABLE t1;
468 CREATE TABLE t1
469 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
470 PARTITION BY HASH(a) PARTITIONS 3;
471 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
472 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_4';
473 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
474 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_4';
475 DROP TABLE t1;
476 CREATE TABLE t1
477 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
478 PARTITION BY HASH(a) PARTITIONS 3;
479 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
480 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_5';
481 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
482 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_5';
483 DROP TABLE t1;
484 CREATE TABLE t1
485 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
486 PARTITION BY HASH(a) PARTITIONS 3;
487 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
488 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_6';
489 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
490 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_6';
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 PARTITION BY HASH(a) PARTITIONS 3;
495 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
496 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_7';
497 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
498 # No such crash injection, statement did not crash, cleaning up
499 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_7';
500 DROP TABLE t1;
501 CREATE TABLE t1
502 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
503 PARTITION BY HASH(a) PARTITIONS 3;
504 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
505 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
506 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
507 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
508 DROP TABLE t1;
509 CREATE TABLE t1
510 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
511 PARTITION BY HASH(a) PARTITIONS 3;
512 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
513 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
514 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
515 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
516 DROP TABLE t1;
517 CREATE TABLE t1
518 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
519 PARTITION BY HASH(a) PARTITIONS 3;
520 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
521 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
522 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
523 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
524 DROP TABLE t1;
525 CREATE TABLE t1
526 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
527 PARTITION BY HASH(a) PARTITIONS 3;
528 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
529 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_4';
530 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
531 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_4';
532 DROP TABLE t1;
533 CREATE TABLE t1
534 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
535 PARTITION BY HASH(a) PARTITIONS 3;
536 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
537 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_5';
538 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
539 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_5';
540 DROP TABLE t1;
541 CREATE TABLE t1
542 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
543 PARTITION BY HASH(a) PARTITIONS 3;
544 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
545 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_6';
546 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
547 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_6';
548 DROP TABLE t1;
549 CREATE TABLE t1
550 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
551 PARTITION BY HASH(a) PARTITIONS 3;
552 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
553 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_7';
554 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
555 # No such crash injection, statement did not crash, cleaning up
556 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_7';
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 PARTITION BY HASH(a) PARTITIONS 3;
561 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
562 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
563 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
564 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
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 PARTITION BY HASH(a) PARTITIONS 3;
569 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
570 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
571 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
572 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
573 DROP TABLE t1;
574 CREATE TABLE t1
575 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
576 PARTITION BY HASH(a) PARTITIONS 3;
577 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
578 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
579 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
580 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
581 DROP TABLE t1;
582 CREATE TABLE t1
583 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
584 PARTITION BY HASH(a) PARTITIONS 3;
585 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
586 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_4';
587 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
588 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_4';
589 DROP TABLE t1;
590 CREATE TABLE t1
591 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
592 PARTITION BY HASH(a) PARTITIONS 3;
593 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
594 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_5';
595 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
596 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_5';
597 DROP TABLE t1;
598 CREATE TABLE t1
599 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
600 PARTITION BY HASH(a) PARTITIONS 3;
601 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
602 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_6';
603 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
604 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_6';
605 DROP TABLE t1;
606 CREATE TABLE t1
607 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
608 PARTITION BY HASH(a) PARTITIONS 3;
609 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
610 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_7';
611 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
612 # No such crash injection, statement did not crash, cleaning up
613 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_7';
614 DROP TABLE t1;
615 CREATE TABLE t1
616 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
617 PARTITION BY HASH(a) PARTITIONS 3;
618 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
619 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
620 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
621 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
622 DROP TABLE t1;
623 CREATE TABLE t1
624 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
625 PARTITION BY HASH(a) PARTITIONS 3;
626 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
627 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
628 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
629 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
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 PARTITION BY HASH(a) PARTITIONS 3;
634 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
635 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
636 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
637 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
638 DROP TABLE t1;
639 CREATE TABLE t1
640 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
641 PARTITION BY HASH(a) PARTITIONS 3;
642 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
643 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
644 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
645 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
646 DROP TABLE t1;
647 CREATE TABLE t1
648 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
649 PARTITION BY HASH(a) PARTITIONS 3;
650 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
651 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
652 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
653 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
654 DROP TABLE t1;
655 CREATE TABLE t1
656 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
657 PARTITION BY HASH(a) PARTITIONS 3;
658 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
659 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
660 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
661 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
662 DROP TABLE t1;
663 CREATE TABLE t1
664 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
665 PARTITION BY HASH(a) PARTITIONS 3;
666 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
667 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
668 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
669 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
670 DROP TABLE t1;
671 CREATE TABLE t1
672 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
673 PARTITION BY HASH(a) PARTITIONS 3;
674 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
675 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
676 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
677 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
678 DROP TABLE t1;
679 CREATE TABLE t1
680 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
681 PARTITION BY HASH(a) PARTITIONS 3;
682 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
683 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8';
684 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
685 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8';
686 DROP TABLE t1;
687 CREATE TABLE t1
688 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
689 PARTITION BY HASH(a) PARTITIONS 3;
690 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
691 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9';
692 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
693 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9';
694 DROP TABLE t1;
695 CREATE TABLE t1
696 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
697 PARTITION BY HASH(a) PARTITIONS 3;
698 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
699 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10';
700 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=INPLACE;
701 # No such crash injection, statement did not crash, cleaning up
702 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10';
703 DROP TABLE t1;
704 CREATE TABLE t1
705 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
706 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
707 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
708 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
709 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
710 DROP TABLE t1;
711 CREATE TABLE t1
712 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
713 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
714 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
715 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
716 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
717 DROP TABLE t1;
718 CREATE TABLE t1
719 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
720 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
721 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
722 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
723 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
724 DROP TABLE t1;
725 CREATE TABLE t1
726 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
727 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
728 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
729 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
730 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
731 DROP TABLE t1;
732 CREATE TABLE t1
733 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
734 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
735 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
736 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
737 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
738 DROP TABLE t1;
739 CREATE TABLE t1
740 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
741 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
742 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
743 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
744 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
745 DROP TABLE t1;
746 CREATE TABLE t1
747 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
748 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
749 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
750 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
751 # No such crash injection, statement did not crash, cleaning up
752 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
753 DROP TABLE t1;
754 CREATE TABLE t1
755 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
756 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
757 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
758 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
759 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
760 DROP TABLE t1;
761 CREATE TABLE t1
762 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
763 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
764 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
765 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
766 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
767 DROP TABLE t1;
768 CREATE TABLE t1
769 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
770 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
771 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
772 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
773 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
774 DROP TABLE t1;
775 CREATE TABLE t1
776 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
777 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
778 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
779 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
780 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
781 DROP TABLE t1;
782 CREATE TABLE t1
783 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
784 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
785 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
786 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
787 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
788 DROP TABLE t1;
789 CREATE TABLE t1
790 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
791 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
792 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
793 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
794 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
795 DROP TABLE t1;
796 CREATE TABLE t1
797 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
798 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
799 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
800 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
801 # No such crash injection, statement did not crash, cleaning up
802 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
803 DROP TABLE t1;
804 CREATE TABLE t1
805 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
806 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
807 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
808 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
809 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
810 DROP TABLE t1;
811 CREATE TABLE t1
812 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
813 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
814 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
815 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
816 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
817 DROP TABLE t1;
818 CREATE TABLE t1
819 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
820 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
821 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
822 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
823 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
824 DROP TABLE t1;
825 CREATE TABLE t1
826 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
827 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
828 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
829 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
830 # No such crash injection, statement did not crash, cleaning up
831 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
832 DROP TABLE t1;
833 CREATE TABLE t1
834 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
835 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
836 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
837 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
838 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
839 DROP TABLE t1;
840 CREATE TABLE t1
841 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
842 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
843 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
844 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
845 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
846 DROP TABLE t1;
847 CREATE TABLE t1
848 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
849 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
850 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
851 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
852 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
853 DROP TABLE t1;
854 CREATE TABLE t1
855 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
856 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
857 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
858 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
859 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
860 DROP TABLE t1;
861 CREATE TABLE t1
862 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(b), KEY(c)) PARTITION BY HASH(a) PARTITIONS 3;
863 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
864 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
865 ALTER TABLE t1 DROP INDEX b, ADD INDEX(c, b), ALGORITHM=INPLACE;
866 # No such crash injection, statement did not crash, cleaning up
867 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
868 DROP TABLE t1;
869 CREATE TABLE t1
870 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
871 PARTITION BY HASH(a) PARTITIONS 3;
872 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
873 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
874 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
875 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
876 DROP TABLE t1;
877 CREATE TABLE t1
878 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
879 PARTITION BY HASH(a) PARTITIONS 3;
880 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
881 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
882 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
883 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
884 DROP TABLE t1;
885 CREATE TABLE t1
886 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
887 PARTITION BY HASH(a) PARTITIONS 3;
888 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
889 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
890 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
891 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
892 DROP TABLE t1;
893 CREATE TABLE t1
894 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
895 PARTITION BY HASH(a) PARTITIONS 3;
896 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
897 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
898 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
899 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
900 DROP TABLE t1;
901 CREATE TABLE t1
902 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
903 PARTITION BY HASH(a) PARTITIONS 3;
904 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
905 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
906 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
907 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
908 DROP TABLE t1;
909 CREATE TABLE t1
910 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
911 PARTITION BY HASH(a) PARTITIONS 3;
912 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
913 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
914 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
915 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
916 DROP TABLE t1;
917 CREATE TABLE t1
918 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
919 PARTITION BY HASH(a) PARTITIONS 3;
920 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
921 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
922 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
923 # No such crash injection, statement did not crash, cleaning up
924 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
925 DROP TABLE t1;
926 CREATE TABLE t1
927 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
928 PARTITION BY HASH(a) PARTITIONS 3;
929 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
930 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
931 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
932 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
933 DROP TABLE t1;
934 CREATE TABLE t1
935 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
936 PARTITION BY HASH(a) PARTITIONS 3;
937 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
938 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
939 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
940 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
941 DROP TABLE t1;
942 CREATE TABLE t1
943 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
944 PARTITION BY HASH(a) PARTITIONS 3;
945 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
946 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
947 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
948 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
949 DROP TABLE t1;
950 CREATE TABLE t1
951 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
952 PARTITION BY HASH(a) PARTITIONS 3;
953 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
954 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
955 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
956 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
957 DROP TABLE t1;
958 CREATE TABLE t1
959 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
960 PARTITION BY HASH(a) PARTITIONS 3;
961 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
962 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
963 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
964 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
965 DROP TABLE t1;
966 CREATE TABLE t1
967 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
968 PARTITION BY HASH(a) PARTITIONS 3;
969 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
970 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
971 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
972 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
973 DROP TABLE t1;
974 CREATE TABLE t1
975 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
976 PARTITION BY HASH(a) PARTITIONS 3;
977 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
978 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
979 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
980 # No such crash injection, statement did not crash, cleaning up
981 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
982 DROP TABLE t1;
983 CREATE TABLE t1
984 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
985 PARTITION BY HASH(a) PARTITIONS 3;
986 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
987 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
988 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
989 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
990 DROP TABLE t1;
991 CREATE TABLE t1
992 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
993 PARTITION BY HASH(a) PARTITIONS 3;
994 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
995 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
996 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
997 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
998 DROP TABLE t1;
999 CREATE TABLE t1
1000 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1001 PARTITION BY HASH(a) PARTITIONS 3;
1002 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1003 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
1004 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1005 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
1006 DROP TABLE t1;
1007 CREATE TABLE t1
1008 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1009 PARTITION BY HASH(a) PARTITIONS 3;
1010 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1011 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
1012 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1013 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
1014 DROP TABLE t1;
1015 CREATE TABLE t1
1016 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1017 PARTITION BY HASH(a) PARTITIONS 3;
1018 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1019 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_5';
1020 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1021 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_5';
1022 DROP TABLE t1;
1023 CREATE TABLE t1
1024 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1025 PARTITION BY HASH(a) PARTITIONS 3;
1026 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1027 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_6';
1028 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1029 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_6';
1030 DROP TABLE t1;
1031 CREATE TABLE t1
1032 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1033 PARTITION BY HASH(a) PARTITIONS 3;
1034 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1035 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_7';
1036 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1037 # No such crash injection, statement did not crash, cleaning up
1038 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_7';
1039 DROP TABLE t1;
1040 CREATE TABLE t1
1041 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1042 PARTITION BY HASH(a) PARTITIONS 3;
1043 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1044 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
1045 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1046 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
1047 DROP TABLE t1;
1048 CREATE TABLE t1
1049 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1050 PARTITION BY HASH(a) PARTITIONS 3;
1051 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1052 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
1053 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1054 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
1055 DROP TABLE t1;
1056 CREATE TABLE t1
1057 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1058 PARTITION BY HASH(a) PARTITIONS 3;
1059 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1060 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
1061 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1062 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
1063 DROP TABLE t1;
1064 CREATE TABLE t1
1065 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1066 PARTITION BY HASH(a) PARTITIONS 3;
1067 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1068 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_4';
1069 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1070 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_4';
1071 DROP TABLE t1;
1072 CREATE TABLE t1
1073 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1074 PARTITION BY HASH(a) PARTITIONS 3;
1075 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1076 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_5';
1077 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1078 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_5';
1079 DROP TABLE t1;
1080 CREATE TABLE t1
1081 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1082 PARTITION BY HASH(a) PARTITIONS 3;
1083 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1084 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_6';
1085 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1086 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_6';
1087 DROP TABLE t1;
1088 CREATE TABLE t1
1089 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1090 PARTITION BY HASH(a) PARTITIONS 3;
1091 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1092 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_7';
1093 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1094 # No such crash injection, statement did not crash, cleaning up
1095 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_7';
1096 DROP TABLE t1;
1097 CREATE TABLE t1
1098 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1099 PARTITION BY HASH(a) PARTITIONS 3;
1100 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1101 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
1102 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1103 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
1104 DROP TABLE t1;
1105 CREATE TABLE t1
1106 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1107 PARTITION BY HASH(a) PARTITIONS 3;
1108 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1109 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
1110 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1111 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
1112 DROP TABLE t1;
1113 CREATE TABLE t1
1114 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1115 PARTITION BY HASH(a) PARTITIONS 3;
1116 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1117 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
1118 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1119 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
1120 DROP TABLE t1;
1121 CREATE TABLE t1
1122 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1123 PARTITION BY HASH(a) PARTITIONS 3;
1124 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1125 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_4';
1126 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1127 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_4';
1128 DROP TABLE t1;
1129 CREATE TABLE t1
1130 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1131 PARTITION BY HASH(a) PARTITIONS 3;
1132 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1133 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_5';
1134 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1135 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_5';
1136 DROP TABLE t1;
1137 CREATE TABLE t1
1138 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1139 PARTITION BY HASH(a) PARTITIONS 3;
1140 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1141 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_6';
1142 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1143 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_6';
1144 DROP TABLE t1;
1145 CREATE TABLE t1
1146 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1147 PARTITION BY HASH(a) PARTITIONS 3;
1148 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1149 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_7';
1150 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1151 # No such crash injection, statement did not crash, cleaning up
1152 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_7';
1153 DROP TABLE t1;
1154 CREATE TABLE t1
1155 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1156 PARTITION BY HASH(a) PARTITIONS 3;
1157 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1158 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
1159 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1160 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
1161 DROP TABLE t1;
1162 CREATE TABLE t1
1163 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1164 PARTITION BY HASH(a) PARTITIONS 3;
1165 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1166 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
1167 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1168 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
1169 DROP TABLE t1;
1170 CREATE TABLE t1
1171 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1172 PARTITION BY HASH(a) PARTITIONS 3;
1173 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1174 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_3';
1175 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1176 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_3';
1177 DROP TABLE t1;
1178 CREATE TABLE t1
1179 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1180 PARTITION BY HASH(a) PARTITIONS 3;
1181 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1182 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_4';
1183 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1184 # No such crash injection, statement did not crash, cleaning up
1185 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_4';
1186 DROP TABLE t1;
1187 CREATE TABLE t1
1188 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1189 PARTITION BY HASH(a) PARTITIONS 3;
1190 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1191 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
1192 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1193 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
1194 DROP TABLE t1;
1195 CREATE TABLE t1
1196 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1197 PARTITION BY HASH(a) PARTITIONS 3;
1198 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1199 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
1200 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1201 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
1202 DROP TABLE t1;
1203 CREATE TABLE t1
1204 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1205 PARTITION BY HASH(a) PARTITIONS 3;
1206 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1207 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
1208 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1209 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
1210 DROP TABLE t1;
1211 CREATE TABLE t1
1212 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1213 PARTITION BY HASH(a) PARTITIONS 3;
1214 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1215 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_4';
1216 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1217 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_4';
1218 DROP TABLE t1;
1219 CREATE TABLE t1
1220 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1221 PARTITION BY HASH(a) PARTITIONS 3;
1222 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1223 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_5';
1224 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1225 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_5';
1226 DROP TABLE t1;
1227 CREATE TABLE t1
1228 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1229 PARTITION BY HASH(a) PARTITIONS 3;
1230 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1231 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_6';
1232 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1233 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_6';
1234 DROP TABLE t1;
1235 CREATE TABLE t1
1236 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1237 PARTITION BY HASH(a) PARTITIONS 3;
1238 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1239 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_7';
1240 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1241 # No such crash injection, statement did not crash, cleaning up
1242 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_7';
1243 DROP TABLE t1;
1244 CREATE TABLE t1
1245 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1246 PARTITION BY HASH(a) PARTITIONS 3;
1247 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1248 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
1249 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1250 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
1251 DROP TABLE t1;
1252 CREATE TABLE t1
1253 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1254 PARTITION BY HASH(a) PARTITIONS 3;
1255 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1256 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
1257 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1258 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
1259 DROP TABLE t1;
1260 CREATE TABLE t1
1261 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1262 PARTITION BY HASH(a) PARTITIONS 3;
1263 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1264 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
1265 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1266 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
1267 DROP TABLE t1;
1268 CREATE TABLE t1
1269 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1270 PARTITION BY HASH(a) PARTITIONS 3;
1271 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1272 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_4';
1273 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1274 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_4';
1275 DROP TABLE t1;
1276 CREATE TABLE t1
1277 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1278 PARTITION BY HASH(a) PARTITIONS 3;
1279 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1280 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_5';
1281 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1282 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_5';
1283 DROP TABLE t1;
1284 CREATE TABLE t1
1285 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1286 PARTITION BY HASH(a) PARTITIONS 3;
1287 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1288 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_6';
1289 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1290 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_6';
1291 DROP TABLE t1;
1292 CREATE TABLE t1
1293 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1294 PARTITION BY HASH(a) PARTITIONS 3;
1295 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1296 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_7';
1297 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1298 # No such crash injection, statement did not crash, cleaning up
1299 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_7';
1300 DROP TABLE t1;
1301 CREATE TABLE t1
1302 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1303 PARTITION BY HASH(a) PARTITIONS 3;
1304 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1305 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
1306 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1307 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
1308 DROP TABLE t1;
1309 CREATE TABLE t1
1310 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1311 PARTITION BY HASH(a) PARTITIONS 3;
1312 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1313 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
1314 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1315 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
1316 DROP TABLE t1;
1317 CREATE TABLE t1
1318 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1319 PARTITION BY HASH(a) PARTITIONS 3;
1320 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1321 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
1322 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1323 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
1324 DROP TABLE t1;
1325 CREATE TABLE t1
1326 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1327 PARTITION BY HASH(a) PARTITIONS 3;
1328 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1329 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_4';
1330 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1331 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_4';
1332 DROP TABLE t1;
1333 CREATE TABLE t1
1334 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1335 PARTITION BY HASH(a) PARTITIONS 3;
1336 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1337 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_5';
1338 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1339 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_5';
1340 DROP TABLE t1;
1341 CREATE TABLE t1
1342 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1343 PARTITION BY HASH(a) PARTITIONS 3;
1344 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1345 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_6';
1346 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1347 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_6';
1348 DROP TABLE t1;
1349 CREATE TABLE t1
1350 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1351 PARTITION BY HASH(a) PARTITIONS 3;
1352 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1353 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_7';
1354 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1355 # No such crash injection, statement did not crash, cleaning up
1356 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_7';
1357 DROP TABLE t1;
1358 CREATE TABLE t1
1359 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1360 PARTITION BY HASH(a) PARTITIONS 3;
1361 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1362 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
1363 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1364 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
1365 DROP TABLE t1;
1366 CREATE TABLE t1
1367 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1368 PARTITION BY HASH(a) PARTITIONS 3;
1369 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1370 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
1371 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1372 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
1373 DROP TABLE t1;
1374 CREATE TABLE t1
1375 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1376 PARTITION BY HASH(a) PARTITIONS 3;
1377 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1378 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
1379 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1380 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
1381 DROP TABLE t1;
1382 CREATE TABLE t1
1383 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1384 PARTITION BY HASH(a) PARTITIONS 3;
1385 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1386 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
1387 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1388 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
1389 DROP TABLE t1;
1390 CREATE TABLE t1
1391 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1392 PARTITION BY HASH(a) PARTITIONS 3;
1393 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1394 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
1395 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1396 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
1397 DROP TABLE t1;
1398 CREATE TABLE t1
1399 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1400 PARTITION BY HASH(a) PARTITIONS 3;
1401 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1402 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
1403 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1404 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
1405 DROP TABLE t1;
1406 CREATE TABLE t1
1407 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1408 PARTITION BY HASH(a) PARTITIONS 3;
1409 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1410 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
1411 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1412 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
1413 DROP TABLE t1;
1414 CREATE TABLE t1
1415 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL)
1416 PARTITION BY HASH(a) PARTITIONS 3;
1417 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1418 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
1419 ALTER TABLE t1 ADD COLUMN d INT NOT NULL, ADD INDEX(b), ALGORITHM=COPY;
1420 # No such crash injection, statement did not crash, cleaning up
1421 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
1422 DROP TABLE t1;
1423 SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;