Debian Codegraph @

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

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