Debian Codegraph @

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

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