Debian Codegraph @

mysql-test/suite/innodb/r/ddl_crash_alter_table_partition_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)) ENGINE=InnoDB TABLESPACE ts2
5 PARTITION BY RANGE(a) PARTITIONS 3
6 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
7 PARTITION p2 VALUES LESS THAN (5),
8 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
9 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
10 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
11 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
12 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
13 DROP TABLE t1;
14 CREATE TABLE t1
15 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
16 PARTITION BY RANGE(a) PARTITIONS 3
17 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
18 PARTITION p2 VALUES LESS THAN (5),
19 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
20 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
21 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
22 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
23 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
24 DROP TABLE t1;
25 CREATE TABLE t1
26 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
27 PARTITION BY RANGE(a) PARTITIONS 3
28 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
29 PARTITION p2 VALUES LESS THAN (5),
30 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
31 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
32 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
33 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
34 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
35 DROP TABLE t1;
36 CREATE TABLE t1
37 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
38 PARTITION BY RANGE(a) PARTITIONS 3
39 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
40 PARTITION p2 VALUES LESS THAN (5),
41 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
42 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
43 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
44 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
45 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
46 DROP TABLE t1;
47 CREATE TABLE t1
48 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
49 PARTITION BY RANGE(a) PARTITIONS 3
50 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
51 PARTITION p2 VALUES LESS THAN (5),
52 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
53 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
54 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
55 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
56 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
57 DROP TABLE t1;
58 CREATE TABLE t1
59 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
60 PARTITION BY RANGE(a) PARTITIONS 3
61 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
62 PARTITION p2 VALUES LESS THAN (5),
63 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
64 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
65 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
66 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
67 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
68 DROP TABLE t1;
69 CREATE TABLE t1
70 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
71 PARTITION BY RANGE(a) PARTITIONS 3
72 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
73 PARTITION p2 VALUES LESS THAN (5),
74 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
75 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
76 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
77 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
78 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
79 DROP TABLE t1;
80 CREATE TABLE t1
81 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
82 PARTITION BY RANGE(a) PARTITIONS 3
83 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
84 PARTITION p2 VALUES LESS THAN (5),
85 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
86 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
87 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8';
88 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
89 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8';
90 DROP TABLE t1;
91 CREATE TABLE t1
92 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
93 PARTITION BY RANGE(a) PARTITIONS 3
94 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
95 PARTITION p2 VALUES LESS THAN (5),
96 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
97 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
98 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_9';
99 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
100 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_9';
101 DROP TABLE t1;
102 CREATE TABLE t1
103 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
104 PARTITION BY RANGE(a) PARTITIONS 3
105 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
106 PARTITION p2 VALUES LESS THAN (5),
107 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
108 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
109 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_10';
110 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
111 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_10';
112 DROP TABLE t1;
113 CREATE TABLE t1
114 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
115 PARTITION BY RANGE(a) PARTITIONS 3
116 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
117 PARTITION p2 VALUES LESS THAN (5),
118 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
119 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
120 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_11';
121 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
122 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_11';
123 DROP TABLE t1;
124 CREATE TABLE t1
125 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
126 PARTITION BY RANGE(a) PARTITIONS 3
127 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
128 PARTITION p2 VALUES LESS THAN (5),
129 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
130 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
131 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_12';
132 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
133 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_12';
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)) ENGINE=InnoDB TABLESPACE ts2
137 PARTITION BY RANGE(a) PARTITIONS 3
138 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
139 PARTITION p2 VALUES LESS THAN (5),
140 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
141 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
142 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_13';
143 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
144 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_13';
145 DROP TABLE t1;
146 CREATE TABLE t1
147 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
148 PARTITION BY RANGE(a) PARTITIONS 3
149 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
150 PARTITION p2 VALUES LESS THAN (5),
151 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
152 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
153 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_14';
154 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
155 # No such crash injection, statement did not crash, cleaning up
156 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_14';
157 DROP TABLE t1;
158 CREATE TABLE t1
159 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
160 PARTITION BY RANGE(a) PARTITIONS 3
161 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
162 PARTITION p2 VALUES LESS THAN (5),
163 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
164 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
165 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
166 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
167 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
168 DROP TABLE t1;
169 CREATE TABLE t1
170 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
171 PARTITION BY RANGE(a) PARTITIONS 3
172 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
173 PARTITION p2 VALUES LESS THAN (5),
174 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
175 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
176 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
177 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
178 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
179 DROP TABLE t1;
180 CREATE TABLE t1
181 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
182 PARTITION BY RANGE(a) PARTITIONS 3
183 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
184 PARTITION p2 VALUES LESS THAN (5),
185 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
186 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
187 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
188 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
189 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
190 DROP TABLE t1;
191 CREATE TABLE t1
192 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
193 PARTITION BY RANGE(a) PARTITIONS 3
194 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
195 PARTITION p2 VALUES LESS THAN (5),
196 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
197 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
198 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
199 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
200 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
201 DROP TABLE t1;
202 CREATE TABLE t1
203 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
204 PARTITION BY RANGE(a) PARTITIONS 3
205 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
206 PARTITION p2 VALUES LESS THAN (5),
207 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
208 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
209 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
210 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
211 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
212 DROP TABLE t1;
213 CREATE TABLE t1
214 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
215 PARTITION BY RANGE(a) PARTITIONS 3
216 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
217 PARTITION p2 VALUES LESS THAN (5),
218 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
219 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
220 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
221 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
222 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
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)) ENGINE=InnoDB TABLESPACE ts2
226 PARTITION BY RANGE(a) PARTITIONS 3
227 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
228 PARTITION p2 VALUES LESS THAN (5),
229 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
230 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
231 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
232 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
233 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
234 DROP TABLE t1;
235 CREATE TABLE t1
236 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
237 PARTITION BY RANGE(a) PARTITIONS 3
238 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
239 PARTITION p2 VALUES LESS THAN (5),
240 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
241 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
242 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8';
243 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
244 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8';
245 DROP TABLE t1;
246 CREATE TABLE t1
247 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
248 PARTITION BY RANGE(a) PARTITIONS 3
249 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
250 PARTITION p2 VALUES LESS THAN (5),
251 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
252 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
253 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_9';
254 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
255 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_9';
256 DROP TABLE t1;
257 CREATE TABLE t1
258 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
259 PARTITION BY RANGE(a) PARTITIONS 3
260 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
261 PARTITION p2 VALUES LESS THAN (5),
262 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
263 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
264 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_10';
265 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
266 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_10';
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)) ENGINE=InnoDB TABLESPACE ts2
270 PARTITION BY RANGE(a) PARTITIONS 3
271 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
272 PARTITION p2 VALUES LESS THAN (5),
273 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
274 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
275 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_11';
276 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
277 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_11';
278 DROP TABLE t1;
279 CREATE TABLE t1
280 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
281 PARTITION BY RANGE(a) PARTITIONS 3
282 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
283 PARTITION p2 VALUES LESS THAN (5),
284 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
285 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
286 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_12';
287 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
288 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_12';
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)) ENGINE=InnoDB TABLESPACE ts2
292 PARTITION BY RANGE(a) PARTITIONS 3
293 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
294 PARTITION p2 VALUES LESS THAN (5),
295 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
296 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
297 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_13';
298 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
299 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_13';
300 DROP TABLE t1;
301 CREATE TABLE t1
302 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
303 PARTITION BY RANGE(a) PARTITIONS 3
304 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
305 PARTITION p2 VALUES LESS THAN (5),
306 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
307 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
308 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_14';
309 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
310 # No such crash injection, statement did not crash, cleaning up
311 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_14';
312 DROP TABLE t1;
313 CREATE TABLE t1
314 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
315 PARTITION BY RANGE(a) PARTITIONS 3
316 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
317 PARTITION p2 VALUES LESS THAN (5),
318 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
319 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
320 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
321 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
322 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
323 DROP TABLE t1;
324 CREATE TABLE t1
325 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
326 PARTITION BY RANGE(a) PARTITIONS 3
327 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
328 PARTITION p2 VALUES LESS THAN (5),
329 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
330 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
331 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
332 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
333 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
334 DROP TABLE t1;
335 CREATE TABLE t1
336 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
337 PARTITION BY RANGE(a) PARTITIONS 3
338 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
339 PARTITION p2 VALUES LESS THAN (5),
340 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
341 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
342 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
343 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
344 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
345 DROP TABLE t1;
346 CREATE TABLE t1
347 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
348 PARTITION BY RANGE(a) PARTITIONS 3
349 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
350 PARTITION p2 VALUES LESS THAN (5),
351 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
352 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
353 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
354 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
355 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
356 DROP TABLE t1;
357 CREATE TABLE t1
358 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
359 PARTITION BY RANGE(a) PARTITIONS 3
360 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
361 PARTITION p2 VALUES LESS THAN (5),
362 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
363 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
364 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_5';
365 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
366 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_5';
367 DROP TABLE t1;
368 CREATE TABLE t1
369 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
370 PARTITION BY RANGE(a) PARTITIONS 3
371 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
372 PARTITION p2 VALUES LESS THAN (5),
373 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
374 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
375 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_6';
376 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
377 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_6';
378 DROP TABLE t1;
379 CREATE TABLE t1
380 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
381 PARTITION BY RANGE(a) PARTITIONS 3
382 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
383 PARTITION p2 VALUES LESS THAN (5),
384 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
385 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
386 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_7';
387 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
388 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_7';
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)) ENGINE=InnoDB TABLESPACE ts2
392 PARTITION BY RANGE(a) PARTITIONS 3
393 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
394 PARTITION p2 VALUES LESS THAN (5),
395 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
396 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
397 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_8';
398 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
399 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_8';
400 DROP TABLE t1;
401 CREATE TABLE t1
402 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
403 PARTITION BY RANGE(a) PARTITIONS 3
404 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
405 PARTITION p2 VALUES LESS THAN (5),
406 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
407 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
408 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_9';
409 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
410 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_9';
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)) ENGINE=InnoDB TABLESPACE ts2
414 PARTITION BY RANGE(a) PARTITIONS 3
415 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
416 PARTITION p2 VALUES LESS THAN (5),
417 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
418 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
419 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_10';
420 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
421 # No such crash injection, statement did not crash, cleaning up
422 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_10';
423 DROP TABLE t1;
424 CREATE TABLE t1
425 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
426 PARTITION BY RANGE(a) PARTITIONS 3
427 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
428 PARTITION p2 VALUES LESS THAN (5),
429 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
430 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
431 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
432 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
433 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
434 DROP TABLE t1;
435 CREATE TABLE t1
436 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
437 PARTITION BY RANGE(a) PARTITIONS 3
438 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
439 PARTITION p2 VALUES LESS THAN (5),
440 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
441 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
442 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
443 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
444 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
445 DROP TABLE t1;
446 CREATE TABLE t1
447 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
448 PARTITION BY RANGE(a) PARTITIONS 3
449 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
450 PARTITION p2 VALUES LESS THAN (5),
451 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
452 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
453 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
454 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
455 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
456 DROP TABLE t1;
457 CREATE TABLE t1
458 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
459 PARTITION BY RANGE(a) PARTITIONS 3
460 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
461 PARTITION p2 VALUES LESS THAN (5),
462 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
463 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
464 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
465 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
466 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_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, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
470 PARTITION BY RANGE(a) PARTITIONS 3
471 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
472 PARTITION p2 VALUES LESS THAN (5),
473 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
474 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
475 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
476 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
477 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
478 DROP TABLE t1;
479 CREATE TABLE t1
480 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
481 PARTITION BY RANGE(a) PARTITIONS 3
482 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
483 PARTITION p2 VALUES LESS THAN (5),
484 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
485 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
486 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
487 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
488 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
489 DROP TABLE t1;
490 CREATE TABLE t1
491 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
492 PARTITION BY RANGE(a) PARTITIONS 3
493 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
494 PARTITION p2 VALUES LESS THAN (5),
495 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
496 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
497 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
498 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
499 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
500 DROP TABLE t1;
501 CREATE TABLE t1
502 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
503 PARTITION BY RANGE(a) PARTITIONS 3
504 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
505 PARTITION p2 VALUES LESS THAN (5),
506 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
507 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
508 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
509 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
510 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
511 DROP TABLE t1;
512 CREATE TABLE t1
513 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
514 PARTITION BY RANGE(a) PARTITIONS 3
515 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
516 PARTITION p2 VALUES LESS THAN (5),
517 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
518 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
519 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8';
520 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
521 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8';
522 DROP TABLE t1;
523 CREATE TABLE t1
524 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
525 PARTITION BY RANGE(a) PARTITIONS 3
526 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
527 PARTITION p2 VALUES LESS THAN (5),
528 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
529 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
530 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9';
531 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
532 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9';
533 DROP TABLE t1;
534 CREATE TABLE t1
535 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
536 PARTITION BY RANGE(a) PARTITIONS 3
537 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
538 PARTITION p2 VALUES LESS THAN (5),
539 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
540 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
541 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10';
542 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
543 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10';
544 DROP TABLE t1;
545 CREATE TABLE t1
546 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
547 PARTITION BY RANGE(a) PARTITIONS 3
548 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
549 PARTITION p2 VALUES LESS THAN (5),
550 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
551 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
552 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11';
553 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
554 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11';
555 DROP TABLE t1;
556 CREATE TABLE t1
557 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
558 PARTITION BY RANGE(a) PARTITIONS 3
559 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
560 PARTITION p2 VALUES LESS THAN (5),
561 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
562 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
563 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12';
564 ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system;
565 # No such crash injection, statement did not crash, cleaning up
566 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12';
567 DROP TABLE t1;
568 CREATE TABLE t1
569 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
570 PARTITION BY RANGE(a) PARTITIONS 3
571 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
572 PARTITION p2 VALUES LESS THAN (5),
573 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
574 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
575 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
576 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
577 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
578 DROP TABLE t1;
579 CREATE TABLE t1
580 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
581 PARTITION BY RANGE(a) PARTITIONS 3
582 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
583 PARTITION p2 VALUES LESS THAN (5),
584 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
585 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
586 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
587 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
588 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
589 DROP TABLE t1;
590 CREATE TABLE t1
591 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
592 PARTITION BY RANGE(a) PARTITIONS 3
593 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
594 PARTITION p2 VALUES LESS THAN (5),
595 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
596 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
597 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
598 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
599 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
600 DROP TABLE t1;
601 CREATE TABLE t1
602 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
603 PARTITION BY RANGE(a) PARTITIONS 3
604 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
605 PARTITION p2 VALUES LESS THAN (5),
606 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
607 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
608 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
609 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
610 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
611 DROP TABLE t1;
612 CREATE TABLE t1
613 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
614 PARTITION BY RANGE(a) PARTITIONS 3
615 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
616 PARTITION p2 VALUES LESS THAN (5),
617 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
618 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
619 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
620 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
621 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
622 DROP TABLE t1;
623 CREATE TABLE t1
624 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
625 PARTITION BY RANGE(a) PARTITIONS 3
626 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
627 PARTITION p2 VALUES LESS THAN (5),
628 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
629 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
630 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
631 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
632 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
633 DROP TABLE t1;
634 CREATE TABLE t1
635 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
636 PARTITION BY RANGE(a) PARTITIONS 3
637 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
638 PARTITION p2 VALUES LESS THAN (5),
639 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
640 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
641 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
642 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
643 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
644 DROP TABLE t1;
645 CREATE TABLE t1
646 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
647 PARTITION BY RANGE(a) PARTITIONS 3
648 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
649 PARTITION p2 VALUES LESS THAN (5),
650 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
651 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
652 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8';
653 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
654 # No such crash injection, statement did not crash, cleaning up
655 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8';
656 DROP TABLE t1;
657 CREATE TABLE t1
658 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
659 PARTITION BY RANGE(a) PARTITIONS 3
660 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
661 PARTITION p2 VALUES LESS THAN (5),
662 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
663 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
664 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
665 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
666 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
667 DROP TABLE t1;
668 CREATE TABLE t1
669 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
670 PARTITION BY RANGE(a) PARTITIONS 3
671 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
672 PARTITION p2 VALUES LESS THAN (5),
673 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
674 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
675 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
676 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
677 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
678 DROP TABLE t1;
679 CREATE TABLE t1
680 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
681 PARTITION BY RANGE(a) PARTITIONS 3
682 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
683 PARTITION p2 VALUES LESS THAN (5),
684 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
685 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
686 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
687 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
688 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
689 DROP TABLE t1;
690 CREATE TABLE t1
691 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
692 PARTITION BY RANGE(a) PARTITIONS 3
693 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
694 PARTITION p2 VALUES LESS THAN (5),
695 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
696 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
697 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
698 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
699 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
700 DROP TABLE t1;
701 CREATE TABLE t1
702 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
703 PARTITION BY RANGE(a) PARTITIONS 3
704 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
705 PARTITION p2 VALUES LESS THAN (5),
706 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
707 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
708 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
709 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
710 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
711 DROP TABLE t1;
712 CREATE TABLE t1
713 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
714 PARTITION BY RANGE(a) PARTITIONS 3
715 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
716 PARTITION p2 VALUES LESS THAN (5),
717 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
718 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
719 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
720 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
721 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
722 DROP TABLE t1;
723 CREATE TABLE t1
724 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
725 PARTITION BY RANGE(a) PARTITIONS 3
726 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
727 PARTITION p2 VALUES LESS THAN (5),
728 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
729 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
730 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
731 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
732 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
733 DROP TABLE t1;
734 CREATE TABLE t1
735 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
736 PARTITION BY RANGE(a) PARTITIONS 3
737 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
738 PARTITION p2 VALUES LESS THAN (5),
739 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
740 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
741 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8';
742 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
743 # No such crash injection, statement did not crash, cleaning up
744 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8';
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(c)) ENGINE=InnoDB TABLESPACE ts2
748 PARTITION BY RANGE(a) PARTITIONS 3
749 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
750 PARTITION p2 VALUES LESS THAN (5),
751 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
752 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
753 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
754 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
755 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
756 DROP TABLE t1;
757 CREATE TABLE t1
758 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
759 PARTITION BY RANGE(a) PARTITIONS 3
760 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
761 PARTITION p2 VALUES LESS THAN (5),
762 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
763 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
764 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
765 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
766 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_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(c)) ENGINE=InnoDB TABLESPACE ts2
770 PARTITION BY RANGE(a) PARTITIONS 3
771 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
772 PARTITION p2 VALUES LESS THAN (5),
773 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
774 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
775 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
776 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
777 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
778 DROP TABLE t1;
779 CREATE TABLE t1
780 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
781 PARTITION BY RANGE(a) PARTITIONS 3
782 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
783 PARTITION p2 VALUES LESS THAN (5),
784 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
785 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
786 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
787 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
788 # No such crash injection, statement did not crash, cleaning up
789 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
790 DROP TABLE t1;
791 CREATE TABLE t1
792 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
793 PARTITION BY RANGE(a) PARTITIONS 3
794 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
795 PARTITION p2 VALUES LESS THAN (5),
796 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
797 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
798 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
799 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
800 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
801 DROP TABLE t1;
802 CREATE TABLE t1
803 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
804 PARTITION BY RANGE(a) PARTITIONS 3
805 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
806 PARTITION p2 VALUES LESS THAN (5),
807 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
808 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
809 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
810 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
811 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
812 DROP TABLE t1;
813 CREATE TABLE t1
814 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
815 PARTITION BY RANGE(a) PARTITIONS 3
816 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
817 PARTITION p2 VALUES LESS THAN (5),
818 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
819 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
820 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
821 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
822 # No such crash injection, statement did not crash, cleaning up
823 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_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(c)) ENGINE=InnoDB TABLESPACE ts2
827 PARTITION BY RANGE(a) PARTITIONS 3
828 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
829 PARTITION p2 VALUES LESS THAN (5),
830 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
831 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
832 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
833 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
834 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
835 DROP TABLE t1;
836 CREATE TABLE t1
837 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
838 PARTITION BY RANGE(a) PARTITIONS 3
839 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
840 PARTITION p2 VALUES LESS THAN (5),
841 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
842 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
843 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
844 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
845 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
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(c)) ENGINE=InnoDB TABLESPACE ts2
849 PARTITION BY RANGE(a) PARTITIONS 3
850 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
851 PARTITION p2 VALUES LESS THAN (5),
852 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
853 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
854 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
855 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
856 # No such crash injection, statement did not crash, cleaning up
857 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
858 DROP TABLE t1;
859 CREATE TABLE t1
860 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
861 PARTITION BY RANGE(a) PARTITIONS 3
862 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
863 PARTITION p2 VALUES LESS THAN (5),
864 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
865 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
866 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
867 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
868 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
869 DROP TABLE t1;
870 CREATE TABLE t1
871 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
872 PARTITION BY RANGE(a) PARTITIONS 3
873 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
874 PARTITION p2 VALUES LESS THAN (5),
875 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
876 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
877 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
878 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
879 # No such crash injection, statement did not crash, cleaning up
880 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
881 DROP TABLE t1;
882 CREATE TABLE t1
883 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
884 PARTITION BY RANGE(a) PARTITIONS 3
885 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
886 PARTITION p2 VALUES LESS THAN (5),
887 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
888 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
889 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
890 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
891 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
892 DROP TABLE t1;
893 CREATE TABLE t1
894 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
895 PARTITION BY RANGE(a) PARTITIONS 3
896 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
897 PARTITION p2 VALUES LESS THAN (5),
898 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
899 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
900 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
901 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
902 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
903 DROP TABLE t1;
904 CREATE TABLE t1
905 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
906 PARTITION BY RANGE(a) PARTITIONS 3
907 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
908 PARTITION p2 VALUES LESS THAN (5),
909 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
910 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
911 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
912 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
913 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
914 DROP TABLE t1;
915 CREATE TABLE t1
916 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
917 PARTITION BY RANGE(a) PARTITIONS 3
918 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
919 PARTITION p2 VALUES LESS THAN (5),
920 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
921 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
922 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
923 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
924 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
925 DROP TABLE t1;
926 CREATE TABLE t1
927 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
928 PARTITION BY RANGE(a) PARTITIONS 3
929 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
930 PARTITION p2 VALUES LESS THAN (5),
931 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
932 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
933 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
934 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
935 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
936 DROP TABLE t1;
937 CREATE TABLE t1
938 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
939 PARTITION BY RANGE(a) PARTITIONS 3
940 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
941 PARTITION p2 VALUES LESS THAN (5),
942 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
943 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
944 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
945 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
946 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
947 DROP TABLE t1;
948 CREATE TABLE t1
949 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
950 PARTITION BY RANGE(a) PARTITIONS 3
951 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
952 PARTITION p2 VALUES LESS THAN (5),
953 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
954 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
955 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
956 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
957 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
958 DROP TABLE t1;
959 CREATE TABLE t1
960 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
961 PARTITION BY RANGE(a) PARTITIONS 3
962 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
963 PARTITION p2 VALUES LESS THAN (5),
964 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
965 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
966 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
967 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
968 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
969 DROP TABLE t1;
970 CREATE TABLE t1
971 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
972 PARTITION BY RANGE(a) PARTITIONS 3
973 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
974 PARTITION p2 VALUES LESS THAN (5),
975 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
976 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
977 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8';
978 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
979 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8';
980 DROP TABLE t1;
981 CREATE TABLE t1
982 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
983 PARTITION BY RANGE(a) PARTITIONS 3
984 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
985 PARTITION p2 VALUES LESS THAN (5),
986 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
987 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
988 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9';
989 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
990 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9';
991 DROP TABLE t1;
992 CREATE TABLE t1
993 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
994 PARTITION BY RANGE(a) PARTITIONS 3
995 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
996 PARTITION p2 VALUES LESS THAN (5),
997 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
998 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
999 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10';
1000 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1001 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10';
1002 DROP TABLE t1;
1003 CREATE TABLE t1
1004 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1005 PARTITION BY RANGE(a) PARTITIONS 3
1006 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1007 PARTITION p2 VALUES LESS THAN (5),
1008 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1009 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1010 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11';
1011 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1012 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11';
1013 DROP TABLE t1;
1014 CREATE TABLE t1
1015 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1016 PARTITION BY RANGE(a) PARTITIONS 3
1017 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1018 PARTITION p2 VALUES LESS THAN (5),
1019 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1020 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1021 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12';
1022 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1023 # No such crash injection, statement did not crash, cleaning up
1024 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12';
1025 DROP TABLE t1;
1026 CREATE TABLE t1
1027 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1028 PARTITION BY RANGE(a) PARTITIONS 3
1029 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1030 PARTITION p2 VALUES LESS THAN (5),
1031 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1032 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1033 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
1034 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1035 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
1036 DROP TABLE t1;
1037 CREATE TABLE t1
1038 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1039 PARTITION BY RANGE(a) PARTITIONS 3
1040 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1041 PARTITION p2 VALUES LESS THAN (5),
1042 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1043 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1044 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
1045 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1046 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
1047 DROP TABLE t1;
1048 CREATE TABLE t1
1049 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1050 PARTITION BY RANGE(a) PARTITIONS 3
1051 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1052 PARTITION p2 VALUES LESS THAN (5),
1053 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1054 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1055 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
1056 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1057 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
1058 DROP TABLE t1;
1059 CREATE TABLE t1
1060 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1061 PARTITION BY RANGE(a) PARTITIONS 3
1062 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1063 PARTITION p2 VALUES LESS THAN (5),
1064 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1065 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1066 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
1067 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1068 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
1069 DROP TABLE t1;
1070 CREATE TABLE t1
1071 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1072 PARTITION BY RANGE(a) PARTITIONS 3
1073 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1074 PARTITION p2 VALUES LESS THAN (5),
1075 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1076 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1077 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
1078 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1079 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
1080 DROP TABLE t1;
1081 CREATE TABLE t1
1082 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1083 PARTITION BY RANGE(a) PARTITIONS 3
1084 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1085 PARTITION p2 VALUES LESS THAN (5),
1086 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1087 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1088 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
1089 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1090 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
1091 DROP TABLE t1;
1092 CREATE TABLE t1
1093 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1094 PARTITION BY RANGE(a) PARTITIONS 3
1095 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1096 PARTITION p2 VALUES LESS THAN (5),
1097 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1098 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1099 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7';
1100 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1101 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7';
1102 DROP TABLE t1;
1103 CREATE TABLE t1
1104 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1105 PARTITION BY RANGE(a) PARTITIONS 3
1106 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1107 PARTITION p2 VALUES LESS THAN (5),
1108 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1109 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1110 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8';
1111 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1112 # No such crash injection, statement did not crash, cleaning up
1113 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8';
1114 DROP TABLE t1;
1115 CREATE TABLE t1
1116 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1117 PARTITION BY RANGE(a) PARTITIONS 3
1118 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1119 PARTITION p2 VALUES LESS THAN (5),
1120 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1121 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1122 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
1123 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1124 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
1125 DROP TABLE t1;
1126 CREATE TABLE t1
1127 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1128 PARTITION BY RANGE(a) PARTITIONS 3
1129 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1130 PARTITION p2 VALUES LESS THAN (5),
1131 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1132 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1133 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
1134 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1135 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
1136 DROP TABLE t1;
1137 CREATE TABLE t1
1138 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1139 PARTITION BY RANGE(a) PARTITIONS 3
1140 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1141 PARTITION p2 VALUES LESS THAN (5),
1142 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1143 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1144 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
1145 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1146 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
1147 DROP TABLE t1;
1148 CREATE TABLE t1
1149 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1150 PARTITION BY RANGE(a) PARTITIONS 3
1151 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1152 PARTITION p2 VALUES LESS THAN (5),
1153 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1154 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1155 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
1156 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1157 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
1158 DROP TABLE t1;
1159 CREATE TABLE t1
1160 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1161 PARTITION BY RANGE(a) PARTITIONS 3
1162 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1163 PARTITION p2 VALUES LESS THAN (5),
1164 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1165 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1166 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
1167 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1168 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
1169 DROP TABLE t1;
1170 CREATE TABLE t1
1171 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1172 PARTITION BY RANGE(a) PARTITIONS 3
1173 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1174 PARTITION p2 VALUES LESS THAN (5),
1175 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1176 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1177 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
1178 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1179 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
1180 DROP TABLE t1;
1181 CREATE TABLE t1
1182 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1183 PARTITION BY RANGE(a) PARTITIONS 3
1184 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1185 PARTITION p2 VALUES LESS THAN (5),
1186 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1187 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1188 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7';
1189 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1190 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7';
1191 DROP TABLE t1;
1192 CREATE TABLE t1
1193 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1194 PARTITION BY RANGE(a) PARTITIONS 3
1195 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1196 PARTITION p2 VALUES LESS THAN (5),
1197 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1198 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1199 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8';
1200 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1201 # No such crash injection, statement did not crash, cleaning up
1202 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8';
1203 DROP TABLE t1;
1204 CREATE TABLE t1
1205 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1206 PARTITION BY RANGE(a) PARTITIONS 3
1207 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1208 PARTITION p2 VALUES LESS THAN (5),
1209 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1210 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1211 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
1212 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1213 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
1214 DROP TABLE t1;
1215 CREATE TABLE t1
1216 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1217 PARTITION BY RANGE(a) PARTITIONS 3
1218 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1219 PARTITION p2 VALUES LESS THAN (5),
1220 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1221 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1222 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
1223 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1224 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
1225 DROP TABLE t1;
1226 CREATE TABLE t1
1227 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1228 PARTITION BY RANGE(a) PARTITIONS 3
1229 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1230 PARTITION p2 VALUES LESS THAN (5),
1231 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1232 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1233 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
1234 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1235 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
1236 DROP TABLE t1;
1237 CREATE TABLE t1
1238 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1239 PARTITION BY RANGE(a) PARTITIONS 3
1240 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1241 PARTITION p2 VALUES LESS THAN (5),
1242 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1243 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1244 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
1245 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1246 # No such crash injection, statement did not crash, cleaning up
1247 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
1248 DROP TABLE t1;
1249 CREATE TABLE t1
1250 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1251 PARTITION BY RANGE(a) PARTITIONS 3
1252 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1253 PARTITION p2 VALUES LESS THAN (5),
1254 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1255 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1256 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
1257 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1258 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
1259 DROP TABLE t1;
1260 CREATE TABLE t1
1261 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1262 PARTITION BY RANGE(a) PARTITIONS 3
1263 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1264 PARTITION p2 VALUES LESS THAN (5),
1265 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1266 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1267 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
1268 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1269 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
1270 DROP TABLE t1;
1271 CREATE TABLE t1
1272 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1273 PARTITION BY RANGE(a) PARTITIONS 3
1274 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1275 PARTITION p2 VALUES LESS THAN (5),
1276 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1277 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1278 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
1279 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1280 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
1281 DROP TABLE t1;
1282 CREATE TABLE t1
1283 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1284 PARTITION BY RANGE(a) PARTITIONS 3
1285 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1286 PARTITION p2 VALUES LESS THAN (5),
1287 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1288 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1289 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
1290 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1291 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
1292 DROP TABLE t1;
1293 CREATE TABLE t1
1294 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1295 PARTITION BY RANGE(a) PARTITIONS 3
1296 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1297 PARTITION p2 VALUES LESS THAN (5),
1298 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1299 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1300 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
1301 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1302 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
1303 DROP TABLE t1;
1304 CREATE TABLE t1
1305 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1306 PARTITION BY RANGE(a) PARTITIONS 3
1307 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1308 PARTITION p2 VALUES LESS THAN (5),
1309 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1310 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1311 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
1312 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1313 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
1314 DROP TABLE t1;
1315 CREATE TABLE t1
1316 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1317 PARTITION BY RANGE(a) PARTITIONS 3
1318 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1319 PARTITION p2 VALUES LESS THAN (5),
1320 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1321 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1322 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
1323 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1324 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
1325 DROP TABLE t1;
1326 CREATE TABLE t1
1327 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1328 PARTITION BY RANGE(a) PARTITIONS 3
1329 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1330 PARTITION p2 VALUES LESS THAN (5),
1331 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1332 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1333 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
1334 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1335 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
1336 DROP TABLE t1;
1337 CREATE TABLE t1
1338 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1339 PARTITION BY RANGE(a) PARTITIONS 3
1340 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1341 PARTITION p2 VALUES LESS THAN (5),
1342 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1343 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1344 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8';
1345 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1346 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8';
1347 DROP TABLE t1;
1348 CREATE TABLE t1
1349 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1350 PARTITION BY RANGE(a) PARTITIONS 3
1351 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1352 PARTITION p2 VALUES LESS THAN (5),
1353 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1354 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1355 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9';
1356 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1357 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9';
1358 DROP TABLE t1;
1359 CREATE TABLE t1
1360 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1361 PARTITION BY RANGE(a) PARTITIONS 3
1362 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1363 PARTITION p2 VALUES LESS THAN (5),
1364 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1365 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1366 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10';
1367 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1368 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10';
1369 DROP TABLE t1;
1370 CREATE TABLE t1
1371 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1372 PARTITION BY RANGE(a) PARTITIONS 3
1373 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1374 PARTITION p2 VALUES LESS THAN (5),
1375 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1376 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1377 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11';
1378 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1379 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11';
1380 DROP TABLE t1;
1381 CREATE TABLE t1
1382 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
1383 PARTITION BY RANGE(a) PARTITIONS 3
1384 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1385 PARTITION p2 VALUES LESS THAN (5),
1386 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1387 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1388 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12';
1389 ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table;
1390 # No such crash injection, statement did not crash, cleaning up
1391 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12';
1392 DROP TABLE t1;
1393 CREATE TABLE t1
1394 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1395 PARTITION BY RANGE(a) PARTITIONS 3
1396 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1397 PARTITION p2 VALUES LESS THAN (5),
1398 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1399 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1400 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1';
1401 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1402 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1';
1403 DROP TABLE t1;
1404 CREATE TABLE t1
1405 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1406 PARTITION BY RANGE(a) PARTITIONS 3
1407 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1408 PARTITION p2 VALUES LESS THAN (5),
1409 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1410 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1411 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2';
1412 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1413 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2';
1414 DROP TABLE t1;
1415 CREATE TABLE t1
1416 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1417 PARTITION BY RANGE(a) PARTITIONS 3
1418 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1419 PARTITION p2 VALUES LESS THAN (5),
1420 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1421 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1422 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3';
1423 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1424 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3';
1425 DROP TABLE t1;
1426 CREATE TABLE t1
1427 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1428 PARTITION BY RANGE(a) PARTITIONS 3
1429 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1430 PARTITION p2 VALUES LESS THAN (5),
1431 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1432 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1433 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4';
1434 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1435 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4';
1436 DROP TABLE t1;
1437 CREATE TABLE t1
1438 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1439 PARTITION BY RANGE(a) PARTITIONS 3
1440 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1441 PARTITION p2 VALUES LESS THAN (5),
1442 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1443 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1444 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5';
1445 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1446 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5';
1447 DROP TABLE t1;
1448 CREATE TABLE t1
1449 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1450 PARTITION BY RANGE(a) PARTITIONS 3
1451 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1452 PARTITION p2 VALUES LESS THAN (5),
1453 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1454 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1455 SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6';
1456 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1457 # No such crash injection, statement did not crash, cleaning up
1458 SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6';
1459 DROP TABLE t1;
1460 CREATE TABLE t1
1461 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1462 PARTITION BY RANGE(a) PARTITIONS 3
1463 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1464 PARTITION p2 VALUES LESS THAN (5),
1465 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1466 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1467 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1';
1468 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1469 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1';
1470 DROP TABLE t1;
1471 CREATE TABLE t1
1472 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1473 PARTITION BY RANGE(a) PARTITIONS 3
1474 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1475 PARTITION p2 VALUES LESS THAN (5),
1476 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1477 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1478 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2';
1479 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1480 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2';
1481 DROP TABLE t1;
1482 CREATE TABLE t1
1483 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1484 PARTITION BY RANGE(a) PARTITIONS 3
1485 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1486 PARTITION p2 VALUES LESS THAN (5),
1487 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1488 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1489 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3';
1490 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1491 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3';
1492 DROP TABLE t1;
1493 CREATE TABLE t1
1494 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1495 PARTITION BY RANGE(a) PARTITIONS 3
1496 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1497 PARTITION p2 VALUES LESS THAN (5),
1498 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1499 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1500 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4';
1501 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1502 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4';
1503 DROP TABLE t1;
1504 CREATE TABLE t1
1505 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1506 PARTITION BY RANGE(a) PARTITIONS 3
1507 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1508 PARTITION p2 VALUES LESS THAN (5),
1509 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1510 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1511 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5';
1512 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1513 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5';
1514 DROP TABLE t1;
1515 CREATE TABLE t1
1516 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1517 PARTITION BY RANGE(a) PARTITIONS 3
1518 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1519 PARTITION p2 VALUES LESS THAN (5),
1520 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1521 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1522 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6';
1523 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1524 # No such crash injection, statement did not crash, cleaning up
1525 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6';
1526 DROP TABLE t1;
1527 CREATE TABLE t1
1528 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1529 PARTITION BY RANGE(a) PARTITIONS 3
1530 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1531 PARTITION p2 VALUES LESS THAN (5),
1532 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1533 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1534 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1';
1535 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1536 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1';
1537 DROP TABLE t1;
1538 CREATE TABLE t1
1539 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1540 PARTITION BY RANGE(a) PARTITIONS 3
1541 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1542 PARTITION p2 VALUES LESS THAN (5),
1543 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1544 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1545 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2';
1546 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1547 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2';
1548 DROP TABLE t1;
1549 CREATE TABLE t1
1550 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1551 PARTITION BY RANGE(a) PARTITIONS 3
1552 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1553 PARTITION p2 VALUES LESS THAN (5),
1554 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1555 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1556 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3';
1557 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1558 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3';
1559 DROP TABLE t1;
1560 CREATE TABLE t1
1561 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1562 PARTITION BY RANGE(a) PARTITIONS 3
1563 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1564 PARTITION p2 VALUES LESS THAN (5),
1565 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1566 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1567 SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4';
1568 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1569 # No such crash injection, statement did not crash, cleaning up
1570 SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4';
1571 DROP TABLE t1;
1572 CREATE TABLE t1
1573 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1574 PARTITION BY RANGE(a) PARTITIONS 3
1575 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1576 PARTITION p2 VALUES LESS THAN (5),
1577 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1578 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1579 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1';
1580 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1581 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1';
1582 DROP TABLE t1;
1583 CREATE TABLE t1
1584 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1585 PARTITION BY RANGE(a) PARTITIONS 3
1586 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1587 PARTITION p2 VALUES LESS THAN (5),
1588 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1589 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1590 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2';
1591 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1592 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2';
1593 DROP TABLE t1;
1594 CREATE TABLE t1
1595 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1596 PARTITION BY RANGE(a) PARTITIONS 3
1597 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1598 PARTITION p2 VALUES LESS THAN (5),
1599 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1600 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1601 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3';
1602 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1603 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3';
1604 DROP TABLE t1;
1605 CREATE TABLE t1
1606 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1607 PARTITION BY RANGE(a) PARTITIONS 3
1608 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1609 PARTITION p2 VALUES LESS THAN (5),
1610 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1611 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1612 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_4';
1613 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1614 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_4';
1615 DROP TABLE t1;
1616 CREATE TABLE t1
1617 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1618 PARTITION BY RANGE(a) PARTITIONS 3
1619 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1620 PARTITION p2 VALUES LESS THAN (5),
1621 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1622 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1623 SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_5';
1624 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1625 # No such crash injection, statement did not crash, cleaning up
1626 SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_5';
1627 DROP TABLE t1;
1628 CREATE TABLE t1
1629 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1630 PARTITION BY RANGE(a) PARTITIONS 3
1631 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1632 PARTITION p2 VALUES LESS THAN (5),
1633 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1634 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1635 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1';
1636 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1637 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1';
1638 DROP TABLE t1;
1639 CREATE TABLE t1
1640 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1641 PARTITION BY RANGE(a) PARTITIONS 3
1642 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1643 PARTITION p2 VALUES LESS THAN (5),
1644 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1645 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1646 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2';
1647 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1648 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2';
1649 DROP TABLE t1;
1650 CREATE TABLE t1
1651 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1652 PARTITION BY RANGE(a) PARTITIONS 3
1653 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1654 PARTITION p2 VALUES LESS THAN (5),
1655 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1656 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1657 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3';
1658 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1659 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3';
1660 DROP TABLE t1;
1661 CREATE TABLE t1
1662 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1663 PARTITION BY RANGE(a) PARTITIONS 3
1664 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1665 PARTITION p2 VALUES LESS THAN (5),
1666 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1667 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1668 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_4';
1669 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1670 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_4';
1671 DROP TABLE t1;
1672 CREATE TABLE t1
1673 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1674 PARTITION BY RANGE(a) PARTITIONS 3
1675 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1676 PARTITION p2 VALUES LESS THAN (5),
1677 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1678 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1679 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_5';
1680 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1681 # No such crash injection, statement did not crash, cleaning up
1682 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_5';
1683 DROP TABLE t1;
1684 CREATE TABLE t1
1685 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1686 PARTITION BY RANGE(a) PARTITIONS 3
1687 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1688 PARTITION p2 VALUES LESS THAN (5),
1689 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1690 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1691 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1';
1692 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1693 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1';
1694 DROP TABLE t1;
1695 CREATE TABLE t1
1696 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1697 PARTITION BY RANGE(a) PARTITIONS 3
1698 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1699 PARTITION p2 VALUES LESS THAN (5),
1700 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1701 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1702 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2';
1703 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1704 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2';
1705 DROP TABLE t1;
1706 CREATE TABLE t1
1707 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1708 PARTITION BY RANGE(a) PARTITIONS 3
1709 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1710 PARTITION p2 VALUES LESS THAN (5),
1711 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1712 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1713 SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_3';
1714 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1715 # No such crash injection, statement did not crash, cleaning up
1716 SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_3';
1717 DROP TABLE t1;
1718 CREATE TABLE t1
1719 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1720 PARTITION BY RANGE(a) PARTITIONS 3
1721 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1722 PARTITION p2 VALUES LESS THAN (5),
1723 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1724 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1725 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
1726 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1727 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
1728 DROP TABLE t1;
1729 CREATE TABLE t1
1730 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1731 PARTITION BY RANGE(a) PARTITIONS 3
1732 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1733 PARTITION p2 VALUES LESS THAN (5),
1734 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1735 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1736 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
1737 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1738 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
1739 DROP TABLE t1;
1740 CREATE TABLE t1
1741 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1742 PARTITION BY RANGE(a) PARTITIONS 3
1743 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1744 PARTITION p2 VALUES LESS THAN (5),
1745 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1746 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1747 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2';
1748 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1749 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2';
1750 DROP TABLE t1;
1751 CREATE TABLE t1
1752 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1753 PARTITION BY RANGE(a) PARTITIONS 3
1754 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1755 PARTITION p2 VALUES LESS THAN (5),
1756 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1757 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1758 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3';
1759 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1760 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3';
1761 DROP TABLE t1;
1762 CREATE TABLE t1
1763 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1764 PARTITION BY RANGE(a) PARTITIONS 3
1765 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1766 PARTITION p2 VALUES LESS THAN (5),
1767 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1768 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1769 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4';
1770 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1771 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4';
1772 DROP TABLE t1;
1773 CREATE TABLE t1
1774 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1775 PARTITION BY RANGE(a) PARTITIONS 3
1776 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1777 PARTITION p2 VALUES LESS THAN (5),
1778 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1779 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1780 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5';
1781 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1782 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5';
1783 DROP TABLE t1;
1784 CREATE TABLE t1
1785 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1786 PARTITION BY RANGE(a) PARTITIONS 3
1787 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1788 PARTITION p2 VALUES LESS THAN (5),
1789 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1790 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1791 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6';
1792 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1793 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6';
1794 DROP TABLE t1;
1795 CREATE TABLE t1
1796 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1797 PARTITION BY RANGE(a) PARTITIONS 3
1798 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1799 PARTITION p2 VALUES LESS THAN (5),
1800 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1801 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1802 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7';
1803 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1804 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7';
1805 DROP TABLE t1;
1806 CREATE TABLE t1
1807 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1808 PARTITION BY RANGE(a) PARTITIONS 3
1809 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1810 PARTITION p2 VALUES LESS THAN (5),
1811 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1812 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1813 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8';
1814 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1815 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8';
1816 DROP TABLE t1;
1817 CREATE TABLE t1
1818 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1819 PARTITION BY RANGE(a) PARTITIONS 3
1820 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1821 PARTITION p2 VALUES LESS THAN (5),
1822 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1823 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1824 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9';
1825 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1826 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9';
1827 DROP TABLE t1;
1828 CREATE TABLE t1
1829 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1830 PARTITION BY RANGE(a) PARTITIONS 3
1831 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1832 PARTITION p2 VALUES LESS THAN (5),
1833 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1834 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1835 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10';
1836 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1837 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10';
1838 DROP TABLE t1;
1839 CREATE TABLE t1
1840 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
1841 PARTITION BY RANGE(a) PARTITIONS 3
1842 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
1843 PARTITION p2 VALUES LESS THAN (5),
1844 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
1845 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
1846 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11';
1847 ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1;
1848 # No such crash injection, statement did not crash, cleaning up
1849 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11';
1850 DROP TABLE t1;
1851 DROP TABLESPACE ts1;
1852 DROP TABLESPACE ts2;
1853 SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;