Debian Codegraph @

mysql-test/suite/parts/r/debug_innodb_fail.result

raw
1 call mtr.add_suppression("InnoDB: Warning: allocated tablespace .*, old maximum was");
2 call mtr.add_suppression("table .* does not exist in the InnoDB internal");
3 call mtr.add_suppression("InnoDB: Warning: MariaDB is trying to drop table ");
4 # Test failure recovery in fast_alter_partition_table.
5 #
6 # Bug#53676: Unexpected errors and possible table corruption on
7 # ADD PARTITION and LOCK TABLE
8 # Bug#53770: Server crash at handler.cc:2076 on LOAD DATA
9 # after timed out COALESCE PARTITION
10 # Extended crash recovery testing of fast_alter_partition_table.
11 call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
12 flush tables;
13 # Error recovery testing ADD PARTITION
14 SET @save_dbug=@@debug_dbug;
15 SET SESSION debug_dbug="+d,fail_add_partition_1";
16 CREATE TABLE t1 (a INT, b VARCHAR(64))
17 ENGINE = 'InnoDB'
18 PARTITION BY LIST (a)
19 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
20 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
21 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
22 # d,fail_add_partition_1: BEFORE failure
23 db.opt
24 t1#P#p0.ibd
25 t1#P#p10.ibd
26 t1.frm
27 t1.par
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `a` int(11) DEFAULT NULL,
32 `b` varchar(64) DEFAULT NULL
33 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
34 PARTITION BY LIST (`a`)
35 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
36 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
37 SELECT * FROM t1;
38 a b
39 1 Original from partition p0
40 11 Original from partition p1
41 12 Original from partition p1
42 13 Original from partition p1
43 14 Original from partition p1
44 2 Original from partition p0
45 3 Original from partition p0
46 4 Original from partition p0
47 ALTER TABLE t1 ADD PARTITION
48 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
49 ERROR HY000: Unknown error
50 # d,fail_add_partition_1: AFTER failure
51 db.opt
52 t1#P#p0.ibd
53 t1#P#p10.ibd
54 t1.frm
55 t1.par
56 SHOW CREATE TABLE t1;
57 Table Create Table
58 t1 CREATE TABLE `t1` (
59 `a` int(11) DEFAULT NULL,
60 `b` varchar(64) DEFAULT NULL
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
62 PARTITION BY LIST (`a`)
63 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
64 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
65 SELECT * FROM t1;
66 a b
67 1 Original from partition p0
68 11 Original from partition p1
69 12 Original from partition p1
70 13 Original from partition p1
71 14 Original from partition p1
72 2 Original from partition p0
73 3 Original from partition p0
74 4 Original from partition p0
75 DROP TABLE t1;
76 CREATE TABLE t1 (a INT, b VARCHAR(64))
77 ENGINE = 'InnoDB'
78 PARTITION BY LIST (a)
79 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
80 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
81 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
82 # d,fail_add_partition_1: BEFORE failure (under LOCK TABLE)
83 db.opt
84 t1#P#p0.ibd
85 t1#P#p10.ibd
86 t1.frm
87 t1.par
88 SHOW CREATE TABLE t1;
89 Table Create Table
90 t1 CREATE TABLE `t1` (
91 `a` int(11) DEFAULT NULL,
92 `b` varchar(64) DEFAULT NULL
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
94 PARTITION BY LIST (`a`)
95 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
96 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
97 SELECT * FROM t1;
98 a b
99 1 Original from partition p0
100 11 Original from partition p1
101 12 Original from partition p1
102 13 Original from partition p1
103 14 Original from partition p1
104 2 Original from partition p0
105 3 Original from partition p0
106 4 Original from partition p0
107 LOCK TABLE t1 WRITE;
108 ALTER TABLE t1 ADD PARTITION
109 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
110 ERROR HY000: Unknown error
111 # d,fail_add_partition_1: AFTER failure (under LOCK TABLE)
112 db.opt
113 t1#P#p0.ibd
114 t1#P#p10.ibd
115 t1.frm
116 t1.par
117 SHOW CREATE TABLE t1;
118 Table Create Table
119 t1 CREATE TABLE `t1` (
120 `a` int(11) DEFAULT NULL,
121 `b` varchar(64) DEFAULT NULL
122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
123 PARTITION BY LIST (`a`)
124 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
125 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
126 SELECT * FROM t1;
127 a b
128 1 Original from partition p0
129 11 Original from partition p1
130 12 Original from partition p1
131 13 Original from partition p1
132 14 Original from partition p1
133 2 Original from partition p0
134 3 Original from partition p0
135 4 Original from partition p0
136 UNLOCK TABLES;
137 DROP TABLE t1;
138 SET SESSION debug_dbug=@save_dbug;
139 SET SESSION debug_dbug="+d,fail_add_partition_2";
140 CREATE TABLE t1 (a INT, b VARCHAR(64))
141 ENGINE = 'InnoDB'
142 PARTITION BY LIST (a)
143 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
144 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
145 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
146 # d,fail_add_partition_2: BEFORE failure
147 db.opt
148 t1#P#p0.ibd
149 t1#P#p10.ibd
150 t1.frm
151 t1.par
152 SHOW CREATE TABLE t1;
153 Table Create Table
154 t1 CREATE TABLE `t1` (
155 `a` int(11) DEFAULT NULL,
156 `b` varchar(64) DEFAULT NULL
157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
158 PARTITION BY LIST (`a`)
159 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
160 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
161 SELECT * FROM t1;
162 a b
163 1 Original from partition p0
164 11 Original from partition p1
165 12 Original from partition p1
166 13 Original from partition p1
167 14 Original from partition p1
168 2 Original from partition p0
169 3 Original from partition p0
170 4 Original from partition p0
171 ALTER TABLE t1 ADD PARTITION
172 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
173 ERROR HY000: Unknown error
174 # d,fail_add_partition_2: AFTER failure
175 db.opt
176 t1#P#p0.ibd
177 t1#P#p10.ibd
178 t1.frm
179 t1.par
180 SHOW CREATE TABLE t1;
181 Table Create Table
182 t1 CREATE TABLE `t1` (
183 `a` int(11) DEFAULT NULL,
184 `b` varchar(64) DEFAULT NULL
185 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
186 PARTITION BY LIST (`a`)
187 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
188 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
189 SELECT * FROM t1;
190 a b
191 1 Original from partition p0
192 11 Original from partition p1
193 12 Original from partition p1
194 13 Original from partition p1
195 14 Original from partition p1
196 2 Original from partition p0
197 3 Original from partition p0
198 4 Original from partition p0
199 DROP TABLE t1;
200 CREATE TABLE t1 (a INT, b VARCHAR(64))
201 ENGINE = 'InnoDB'
202 PARTITION BY LIST (a)
203 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
204 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
205 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
206 # d,fail_add_partition_2: BEFORE failure (under LOCK TABLE)
207 db.opt
208 t1#P#p0.ibd
209 t1#P#p10.ibd
210 t1.frm
211 t1.par
212 SHOW CREATE TABLE t1;
213 Table Create Table
214 t1 CREATE TABLE `t1` (
215 `a` int(11) DEFAULT NULL,
216 `b` varchar(64) DEFAULT NULL
217 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
218 PARTITION BY LIST (`a`)
219 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
220 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
221 SELECT * FROM t1;
222 a b
223 1 Original from partition p0
224 11 Original from partition p1
225 12 Original from partition p1
226 13 Original from partition p1
227 14 Original from partition p1
228 2 Original from partition p0
229 3 Original from partition p0
230 4 Original from partition p0
231 LOCK TABLE t1 WRITE;
232 ALTER TABLE t1 ADD PARTITION
233 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
234 ERROR HY000: Unknown error
235 # d,fail_add_partition_2: AFTER failure (under LOCK TABLE)
236 db.opt
237 t1#P#p0.ibd
238 t1#P#p10.ibd
239 t1.frm
240 t1.par
241 SHOW CREATE TABLE t1;
242 Table Create Table
243 t1 CREATE TABLE `t1` (
244 `a` int(11) DEFAULT NULL,
245 `b` varchar(64) DEFAULT NULL
246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
247 PARTITION BY LIST (`a`)
248 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
249 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
250 SELECT * FROM t1;
251 a b
252 1 Original from partition p0
253 11 Original from partition p1
254 12 Original from partition p1
255 13 Original from partition p1
256 14 Original from partition p1
257 2 Original from partition p0
258 3 Original from partition p0
259 4 Original from partition p0
260 UNLOCK TABLES;
261 DROP TABLE t1;
262 SET SESSION debug_dbug=@save_dbug;
263 SET SESSION debug_dbug="+d,fail_add_partition_3";
264 CREATE TABLE t1 (a INT, b VARCHAR(64))
265 ENGINE = 'InnoDB'
266 PARTITION BY LIST (a)
267 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
268 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
269 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
270 # d,fail_add_partition_3: BEFORE failure
271 db.opt
272 t1#P#p0.ibd
273 t1#P#p10.ibd
274 t1.frm
275 t1.par
276 SHOW CREATE TABLE t1;
277 Table Create Table
278 t1 CREATE TABLE `t1` (
279 `a` int(11) DEFAULT NULL,
280 `b` varchar(64) DEFAULT NULL
281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
282 PARTITION BY LIST (`a`)
283 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
284 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
285 SELECT * FROM t1;
286 a b
287 1 Original from partition p0
288 11 Original from partition p1
289 12 Original from partition p1
290 13 Original from partition p1
291 14 Original from partition p1
292 2 Original from partition p0
293 3 Original from partition p0
294 4 Original from partition p0
295 ALTER TABLE t1 ADD PARTITION
296 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
297 ERROR HY000: Unknown error
298 # d,fail_add_partition_3: AFTER failure
299 db.opt
300 t1#P#p0.ibd
301 t1#P#p10.ibd
302 t1.frm
303 t1.par
304 SHOW CREATE TABLE t1;
305 Table Create Table
306 t1 CREATE TABLE `t1` (
307 `a` int(11) DEFAULT NULL,
308 `b` varchar(64) DEFAULT NULL
309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
310 PARTITION BY LIST (`a`)
311 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
312 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
313 SELECT * FROM t1;
314 a b
315 1 Original from partition p0
316 11 Original from partition p1
317 12 Original from partition p1
318 13 Original from partition p1
319 14 Original from partition p1
320 2 Original from partition p0
321 3 Original from partition p0
322 4 Original from partition p0
323 DROP TABLE t1;
324 CREATE TABLE t1 (a INT, b VARCHAR(64))
325 ENGINE = 'InnoDB'
326 PARTITION BY LIST (a)
327 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
328 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
329 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
330 # d,fail_add_partition_3: BEFORE failure (under LOCK TABLE)
331 db.opt
332 t1#P#p0.ibd
333 t1#P#p10.ibd
334 t1.frm
335 t1.par
336 SHOW CREATE TABLE t1;
337 Table Create Table
338 t1 CREATE TABLE `t1` (
339 `a` int(11) DEFAULT NULL,
340 `b` varchar(64) DEFAULT NULL
341 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
342 PARTITION BY LIST (`a`)
343 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
344 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
345 SELECT * FROM t1;
346 a b
347 1 Original from partition p0
348 11 Original from partition p1
349 12 Original from partition p1
350 13 Original from partition p1
351 14 Original from partition p1
352 2 Original from partition p0
353 3 Original from partition p0
354 4 Original from partition p0
355 LOCK TABLE t1 WRITE;
356 ALTER TABLE t1 ADD PARTITION
357 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
358 ERROR HY000: Unknown error
359 # d,fail_add_partition_3: AFTER failure (under LOCK TABLE)
360 db.opt
361 t1#P#p0.ibd
362 t1#P#p10.ibd
363 t1.frm
364 t1.par
365 SHOW CREATE TABLE t1;
366 Table Create Table
367 t1 CREATE TABLE `t1` (
368 `a` int(11) DEFAULT NULL,
369 `b` varchar(64) DEFAULT NULL
370 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
371 PARTITION BY LIST (`a`)
372 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
373 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
374 SELECT * FROM t1;
375 a b
376 1 Original from partition p0
377 11 Original from partition p1
378 12 Original from partition p1
379 13 Original from partition p1
380 14 Original from partition p1
381 2 Original from partition p0
382 3 Original from partition p0
383 4 Original from partition p0
384 UNLOCK TABLES;
385 DROP TABLE t1;
386 SET SESSION debug_dbug=@save_dbug;
387 SET SESSION debug_dbug="+d,fail_add_partition_4";
388 CREATE TABLE t1 (a INT, b VARCHAR(64))
389 ENGINE = 'InnoDB'
390 PARTITION BY LIST (a)
391 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
392 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
393 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
394 # d,fail_add_partition_4: BEFORE failure
395 db.opt
396 t1#P#p0.ibd
397 t1#P#p10.ibd
398 t1.frm
399 t1.par
400 SHOW CREATE TABLE t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `a` int(11) DEFAULT NULL,
404 `b` varchar(64) DEFAULT NULL
405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
406 PARTITION BY LIST (`a`)
407 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
408 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
409 SELECT * FROM t1;
410 a b
411 1 Original from partition p0
412 11 Original from partition p1
413 12 Original from partition p1
414 13 Original from partition p1
415 14 Original from partition p1
416 2 Original from partition p0
417 3 Original from partition p0
418 4 Original from partition p0
419 ALTER TABLE t1 ADD PARTITION
420 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
421 ERROR HY000: Unknown error
422 # d,fail_add_partition_4: AFTER failure
423 db.opt
424 t1#P#p0.ibd
425 t1#P#p10.ibd
426 t1.frm
427 t1.par
428 SHOW CREATE TABLE t1;
429 Table Create Table
430 t1 CREATE TABLE `t1` (
431 `a` int(11) DEFAULT NULL,
432 `b` varchar(64) DEFAULT NULL
433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
434 PARTITION BY LIST (`a`)
435 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
436 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
437 SELECT * FROM t1;
438 a b
439 1 Original from partition p0
440 11 Original from partition p1
441 12 Original from partition p1
442 13 Original from partition p1
443 14 Original from partition p1
444 2 Original from partition p0
445 3 Original from partition p0
446 4 Original from partition p0
447 DROP TABLE t1;
448 CREATE TABLE t1 (a INT, b VARCHAR(64))
449 ENGINE = 'InnoDB'
450 PARTITION BY LIST (a)
451 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
452 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
453 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
454 # d,fail_add_partition_4: BEFORE failure (under LOCK TABLE)
455 db.opt
456 t1#P#p0.ibd
457 t1#P#p10.ibd
458 t1.frm
459 t1.par
460 SHOW CREATE TABLE t1;
461 Table Create Table
462 t1 CREATE TABLE `t1` (
463 `a` int(11) DEFAULT NULL,
464 `b` varchar(64) DEFAULT NULL
465 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
466 PARTITION BY LIST (`a`)
467 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
468 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
469 SELECT * FROM t1;
470 a b
471 1 Original from partition p0
472 11 Original from partition p1
473 12 Original from partition p1
474 13 Original from partition p1
475 14 Original from partition p1
476 2 Original from partition p0
477 3 Original from partition p0
478 4 Original from partition p0
479 LOCK TABLE t1 WRITE;
480 ALTER TABLE t1 ADD PARTITION
481 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
482 ERROR HY000: Unknown error
483 # d,fail_add_partition_4: AFTER failure (under LOCK TABLE)
484 db.opt
485 t1#P#p0.ibd
486 t1#P#p10.ibd
487 t1.frm
488 t1.par
489 SHOW CREATE TABLE t1;
490 Table Create Table
491 t1 CREATE TABLE `t1` (
492 `a` int(11) DEFAULT NULL,
493 `b` varchar(64) DEFAULT NULL
494 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
495 PARTITION BY LIST (`a`)
496 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
497 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
498 SELECT * FROM t1;
499 a b
500 1 Original from partition p0
501 11 Original from partition p1
502 12 Original from partition p1
503 13 Original from partition p1
504 14 Original from partition p1
505 2 Original from partition p0
506 3 Original from partition p0
507 4 Original from partition p0
508 UNLOCK TABLES;
509 DROP TABLE t1;
510 SET SESSION debug_dbug=@save_dbug;
511 SET SESSION debug_dbug="+d,fail_add_partition_5";
512 CREATE TABLE t1 (a INT, b VARCHAR(64))
513 ENGINE = 'InnoDB'
514 PARTITION BY LIST (a)
515 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
516 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
517 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
518 # d,fail_add_partition_5: BEFORE failure
519 db.opt
520 t1#P#p0.ibd
521 t1#P#p10.ibd
522 t1.frm
523 t1.par
524 SHOW CREATE TABLE t1;
525 Table Create Table
526 t1 CREATE TABLE `t1` (
527 `a` int(11) DEFAULT NULL,
528 `b` varchar(64) DEFAULT NULL
529 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
530 PARTITION BY LIST (`a`)
531 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
532 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
533 SELECT * FROM t1;
534 a b
535 1 Original from partition p0
536 11 Original from partition p1
537 12 Original from partition p1
538 13 Original from partition p1
539 14 Original from partition p1
540 2 Original from partition p0
541 3 Original from partition p0
542 4 Original from partition p0
543 ALTER TABLE t1 ADD PARTITION
544 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
545 ERROR HY000: Unknown error
546 # d,fail_add_partition_5: AFTER failure
547 db.opt
548 t1#P#p0.ibd
549 t1#P#p10.ibd
550 t1.frm
551 t1.par
552 SHOW CREATE TABLE t1;
553 Table Create Table
554 t1 CREATE TABLE `t1` (
555 `a` int(11) DEFAULT NULL,
556 `b` varchar(64) DEFAULT NULL
557 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
558 PARTITION BY LIST (`a`)
559 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
560 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
561 SELECT * FROM t1;
562 a b
563 1 Original from partition p0
564 11 Original from partition p1
565 12 Original from partition p1
566 13 Original from partition p1
567 14 Original from partition p1
568 2 Original from partition p0
569 3 Original from partition p0
570 4 Original from partition p0
571 DROP TABLE t1;
572 CREATE TABLE t1 (a INT, b VARCHAR(64))
573 ENGINE = 'InnoDB'
574 PARTITION BY LIST (a)
575 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
576 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
577 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
578 # d,fail_add_partition_5: BEFORE failure (under LOCK TABLE)
579 db.opt
580 t1#P#p0.ibd
581 t1#P#p10.ibd
582 t1.frm
583 t1.par
584 SHOW CREATE TABLE t1;
585 Table Create Table
586 t1 CREATE TABLE `t1` (
587 `a` int(11) DEFAULT NULL,
588 `b` varchar(64) DEFAULT NULL
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
590 PARTITION BY LIST (`a`)
591 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
592 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
593 SELECT * FROM t1;
594 a b
595 1 Original from partition p0
596 11 Original from partition p1
597 12 Original from partition p1
598 13 Original from partition p1
599 14 Original from partition p1
600 2 Original from partition p0
601 3 Original from partition p0
602 4 Original from partition p0
603 LOCK TABLE t1 WRITE;
604 ALTER TABLE t1 ADD PARTITION
605 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
606 ERROR HY000: Unknown error
607 # d,fail_add_partition_5: AFTER failure (under LOCK TABLE)
608 db.opt
609 t1#P#p0.ibd
610 t1#P#p10.ibd
611 t1.frm
612 t1.par
613 SHOW CREATE TABLE t1;
614 Table Create Table
615 t1 CREATE TABLE `t1` (
616 `a` int(11) DEFAULT NULL,
617 `b` varchar(64) DEFAULT NULL
618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
619 PARTITION BY LIST (`a`)
620 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
621 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
622 SELECT * FROM t1;
623 a b
624 1 Original from partition p0
625 11 Original from partition p1
626 12 Original from partition p1
627 13 Original from partition p1
628 14 Original from partition p1
629 2 Original from partition p0
630 3 Original from partition p0
631 4 Original from partition p0
632 UNLOCK TABLES;
633 DROP TABLE t1;
634 SET SESSION debug_dbug=@save_dbug;
635 SET SESSION debug_dbug="+d,fail_add_partition_6";
636 CREATE TABLE t1 (a INT, b VARCHAR(64))
637 ENGINE = 'InnoDB'
638 PARTITION BY LIST (a)
639 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
640 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
641 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
642 # d,fail_add_partition_6: BEFORE failure
643 db.opt
644 t1#P#p0.ibd
645 t1#P#p10.ibd
646 t1.frm
647 t1.par
648 SHOW CREATE TABLE t1;
649 Table Create Table
650 t1 CREATE TABLE `t1` (
651 `a` int(11) DEFAULT NULL,
652 `b` varchar(64) DEFAULT NULL
653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
654 PARTITION BY LIST (`a`)
655 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
656 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
657 SELECT * FROM t1;
658 a b
659 1 Original from partition p0
660 11 Original from partition p1
661 12 Original from partition p1
662 13 Original from partition p1
663 14 Original from partition p1
664 2 Original from partition p0
665 3 Original from partition p0
666 4 Original from partition p0
667 ALTER TABLE t1 ADD PARTITION
668 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
669 ERROR HY000: Unknown error
670 # d,fail_add_partition_6: AFTER failure
671 db.opt
672 t1#P#p0.ibd
673 t1#P#p10.ibd
674 t1.frm
675 t1.par
676 SHOW CREATE TABLE t1;
677 Table Create Table
678 t1 CREATE TABLE `t1` (
679 `a` int(11) DEFAULT NULL,
680 `b` varchar(64) DEFAULT NULL
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
682 PARTITION BY LIST (`a`)
683 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
684 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
685 SELECT * FROM t1;
686 a b
687 1 Original from partition p0
688 11 Original from partition p1
689 12 Original from partition p1
690 13 Original from partition p1
691 14 Original from partition p1
692 2 Original from partition p0
693 3 Original from partition p0
694 4 Original from partition p0
695 DROP TABLE t1;
696 CREATE TABLE t1 (a INT, b VARCHAR(64))
697 ENGINE = 'InnoDB'
698 PARTITION BY LIST (a)
699 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
700 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
701 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
702 # d,fail_add_partition_6: BEFORE failure (under LOCK TABLE)
703 db.opt
704 t1#P#p0.ibd
705 t1#P#p10.ibd
706 t1.frm
707 t1.par
708 SHOW CREATE TABLE t1;
709 Table Create Table
710 t1 CREATE TABLE `t1` (
711 `a` int(11) DEFAULT NULL,
712 `b` varchar(64) DEFAULT NULL
713 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
714 PARTITION BY LIST (`a`)
715 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
716 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
717 SELECT * FROM t1;
718 a b
719 1 Original from partition p0
720 11 Original from partition p1
721 12 Original from partition p1
722 13 Original from partition p1
723 14 Original from partition p1
724 2 Original from partition p0
725 3 Original from partition p0
726 4 Original from partition p0
727 LOCK TABLE t1 WRITE;
728 ALTER TABLE t1 ADD PARTITION
729 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
730 ERROR HY000: Unknown error
731 # d,fail_add_partition_6: AFTER failure (under LOCK TABLE)
732 db.opt
733 t1#P#p0.ibd
734 t1#P#p10.ibd
735 t1.frm
736 t1.par
737 SHOW CREATE TABLE t1;
738 Table Create Table
739 t1 CREATE TABLE `t1` (
740 `a` int(11) DEFAULT NULL,
741 `b` varchar(64) DEFAULT NULL
742 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
743 PARTITION BY LIST (`a`)
744 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
745 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
746 SELECT * FROM t1;
747 a b
748 1 Original from partition p0
749 11 Original from partition p1
750 12 Original from partition p1
751 13 Original from partition p1
752 14 Original from partition p1
753 2 Original from partition p0
754 3 Original from partition p0
755 4 Original from partition p0
756 UNLOCK TABLES;
757 DROP TABLE t1;
758 SET SESSION debug_dbug=@save_dbug;
759 SET SESSION debug_dbug="+d,fail_add_partition_7";
760 CREATE TABLE t1 (a INT, b VARCHAR(64))
761 ENGINE = 'InnoDB'
762 PARTITION BY LIST (a)
763 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
764 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
765 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
766 # d,fail_add_partition_7: BEFORE failure
767 db.opt
768 t1#P#p0.ibd
769 t1#P#p10.ibd
770 t1.frm
771 t1.par
772 SHOW CREATE TABLE t1;
773 Table Create Table
774 t1 CREATE TABLE `t1` (
775 `a` int(11) DEFAULT NULL,
776 `b` varchar(64) DEFAULT NULL
777 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
778 PARTITION BY LIST (`a`)
779 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
780 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
781 SELECT * FROM t1;
782 a b
783 1 Original from partition p0
784 11 Original from partition p1
785 12 Original from partition p1
786 13 Original from partition p1
787 14 Original from partition p1
788 2 Original from partition p0
789 3 Original from partition p0
790 4 Original from partition p0
791 ALTER TABLE t1 ADD PARTITION
792 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
793 ERROR HY000: Unknown error
794 # d,fail_add_partition_7: AFTER failure
795 db.opt
796 t1#P#p0.ibd
797 t1#P#p10.ibd
798 t1.frm
799 t1.par
800 SHOW CREATE TABLE t1;
801 Table Create Table
802 t1 CREATE TABLE `t1` (
803 `a` int(11) DEFAULT NULL,
804 `b` varchar(64) DEFAULT NULL
805 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
806 PARTITION BY LIST (`a`)
807 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
808 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
809 SELECT * FROM t1;
810 a b
811 1 Original from partition p0
812 11 Original from partition p1
813 12 Original from partition p1
814 13 Original from partition p1
815 14 Original from partition p1
816 2 Original from partition p0
817 3 Original from partition p0
818 4 Original from partition p0
819 DROP TABLE t1;
820 CREATE TABLE t1 (a INT, b VARCHAR(64))
821 ENGINE = 'InnoDB'
822 PARTITION BY LIST (a)
823 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
824 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
825 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
826 # d,fail_add_partition_7: BEFORE failure (under LOCK TABLE)
827 db.opt
828 t1#P#p0.ibd
829 t1#P#p10.ibd
830 t1.frm
831 t1.par
832 SHOW CREATE TABLE t1;
833 Table Create Table
834 t1 CREATE TABLE `t1` (
835 `a` int(11) DEFAULT NULL,
836 `b` varchar(64) DEFAULT NULL
837 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
838 PARTITION BY LIST (`a`)
839 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
840 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
841 SELECT * FROM t1;
842 a b
843 1 Original from partition p0
844 11 Original from partition p1
845 12 Original from partition p1
846 13 Original from partition p1
847 14 Original from partition p1
848 2 Original from partition p0
849 3 Original from partition p0
850 4 Original from partition p0
851 LOCK TABLE t1 WRITE;
852 ALTER TABLE t1 ADD PARTITION
853 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
854 ERROR HY000: Unknown error
855 # d,fail_add_partition_7: AFTER failure (under LOCK TABLE)
856 db.opt
857 t1#P#p0.ibd
858 t1#P#p10.ibd
859 t1.frm
860 t1.par
861 SHOW CREATE TABLE t1;
862 Table Create Table
863 t1 CREATE TABLE `t1` (
864 `a` int(11) DEFAULT NULL,
865 `b` varchar(64) DEFAULT NULL
866 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
867 PARTITION BY LIST (`a`)
868 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
869 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
870 SELECT * FROM t1;
871 a b
872 1 Original from partition p0
873 11 Original from partition p1
874 12 Original from partition p1
875 13 Original from partition p1
876 14 Original from partition p1
877 2 Original from partition p0
878 3 Original from partition p0
879 4 Original from partition p0
880 UNLOCK TABLES;
881 DROP TABLE t1;
882 SET SESSION debug_dbug=@save_dbug;
883 SET SESSION debug_dbug="+d,fail_add_partition_8";
884 CREATE TABLE t1 (a INT, b VARCHAR(64))
885 ENGINE = 'InnoDB'
886 PARTITION BY LIST (a)
887 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
888 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
889 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
890 # d,fail_add_partition_8: BEFORE failure
891 db.opt
892 t1#P#p0.ibd
893 t1#P#p10.ibd
894 t1.frm
895 t1.par
896 SHOW CREATE TABLE t1;
897 Table Create Table
898 t1 CREATE TABLE `t1` (
899 `a` int(11) DEFAULT NULL,
900 `b` varchar(64) DEFAULT NULL
901 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
902 PARTITION BY LIST (`a`)
903 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
904 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
905 SELECT * FROM t1;
906 a b
907 1 Original from partition p0
908 11 Original from partition p1
909 12 Original from partition p1
910 13 Original from partition p1
911 14 Original from partition p1
912 2 Original from partition p0
913 3 Original from partition p0
914 4 Original from partition p0
915 ALTER TABLE t1 ADD PARTITION
916 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
917 ERROR HY000: Unknown error
918 # d,fail_add_partition_8: AFTER failure
919 db.opt
920 t1#P#p0.ibd
921 t1#P#p10.ibd
922 t1#P#p20.ibd
923 t1.frm
924 t1.par
925 SHOW CREATE TABLE t1;
926 Table Create Table
927 t1 CREATE TABLE `t1` (
928 `a` int(11) DEFAULT NULL,
929 `b` varchar(64) DEFAULT NULL
930 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
931 PARTITION BY LIST (`a`)
932 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
933 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
934 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
935 SELECT * FROM t1;
936 a b
937 1 Original from partition p0
938 11 Original from partition p1
939 12 Original from partition p1
940 13 Original from partition p1
941 14 Original from partition p1
942 2 Original from partition p0
943 3 Original from partition p0
944 4 Original from partition p0
945 DROP TABLE t1;
946 CREATE TABLE t1 (a INT, b VARCHAR(64))
947 ENGINE = 'InnoDB'
948 PARTITION BY LIST (a)
949 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
950 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
951 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
952 # d,fail_add_partition_8: BEFORE failure (under LOCK TABLE)
953 db.opt
954 t1#P#p0.ibd
955 t1#P#p10.ibd
956 t1.frm
957 t1.par
958 SHOW CREATE TABLE t1;
959 Table Create Table
960 t1 CREATE TABLE `t1` (
961 `a` int(11) DEFAULT NULL,
962 `b` varchar(64) DEFAULT NULL
963 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
964 PARTITION BY LIST (`a`)
965 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
966 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
967 SELECT * FROM t1;
968 a b
969 1 Original from partition p0
970 11 Original from partition p1
971 12 Original from partition p1
972 13 Original from partition p1
973 14 Original from partition p1
974 2 Original from partition p0
975 3 Original from partition p0
976 4 Original from partition p0
977 LOCK TABLE t1 WRITE;
978 ALTER TABLE t1 ADD PARTITION
979 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
980 ERROR HY000: Unknown error
981 # d,fail_add_partition_8: AFTER failure (under LOCK TABLE)
982 db.opt
983 t1#P#p0.ibd
984 t1#P#p10.ibd
985 t1#P#p20.ibd
986 t1.frm
987 t1.par
988 SHOW CREATE TABLE t1;
989 Table Create Table
990 t1 CREATE TABLE `t1` (
991 `a` int(11) DEFAULT NULL,
992 `b` varchar(64) DEFAULT NULL
993 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
994 PARTITION BY LIST (`a`)
995 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
996 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
997 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
998 SELECT * FROM t1;
999 a b
1000 1 Original from partition p0
1001 11 Original from partition p1
1002 12 Original from partition p1
1003 13 Original from partition p1
1004 14 Original from partition p1
1005 2 Original from partition p0
1006 3 Original from partition p0
1007 4 Original from partition p0
1008 UNLOCK TABLES;
1009 DROP TABLE t1;
1010 SET SESSION debug_dbug=@save_dbug;
1011 SET SESSION debug_dbug="+d,fail_add_partition_9";
1012 CREATE TABLE t1 (a INT, b VARCHAR(64))
1013 ENGINE = 'InnoDB'
1014 PARTITION BY LIST (a)
1015 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1016 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1017 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1018 # d,fail_add_partition_9: BEFORE failure
1019 db.opt
1020 t1#P#p0.ibd
1021 t1#P#p10.ibd
1022 t1.frm
1023 t1.par
1024 SHOW CREATE TABLE t1;
1025 Table Create Table
1026 t1 CREATE TABLE `t1` (
1027 `a` int(11) DEFAULT NULL,
1028 `b` varchar(64) DEFAULT NULL
1029 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1030 PARTITION BY LIST (`a`)
1031 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1032 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1033 SELECT * FROM t1;
1034 a b
1035 1 Original from partition p0
1036 11 Original from partition p1
1037 12 Original from partition p1
1038 13 Original from partition p1
1039 14 Original from partition p1
1040 2 Original from partition p0
1041 3 Original from partition p0
1042 4 Original from partition p0
1043 ALTER TABLE t1 ADD PARTITION
1044 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
1045 ERROR HY000: Unknown error
1046 # d,fail_add_partition_9: AFTER failure
1047 db.opt
1048 t1#P#p0.ibd
1049 t1#P#p10.ibd
1050 t1#P#p20.ibd
1051 t1.frm
1052 t1.par
1053 SHOW CREATE TABLE t1;
1054 Table Create Table
1055 t1 CREATE TABLE `t1` (
1056 `a` int(11) DEFAULT NULL,
1057 `b` varchar(64) DEFAULT NULL
1058 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1059 PARTITION BY LIST (`a`)
1060 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1061 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
1062 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
1063 SELECT * FROM t1;
1064 a b
1065 1 Original from partition p0
1066 11 Original from partition p1
1067 12 Original from partition p1
1068 13 Original from partition p1
1069 14 Original from partition p1
1070 2 Original from partition p0
1071 3 Original from partition p0
1072 4 Original from partition p0
1073 DROP TABLE t1;
1074 CREATE TABLE t1 (a INT, b VARCHAR(64))
1075 ENGINE = 'InnoDB'
1076 PARTITION BY LIST (a)
1077 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1078 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1079 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1080 # d,fail_add_partition_9: BEFORE failure (under LOCK TABLE)
1081 db.opt
1082 t1#P#p0.ibd
1083 t1#P#p10.ibd
1084 t1.frm
1085 t1.par
1086 SHOW CREATE TABLE t1;
1087 Table Create Table
1088 t1 CREATE TABLE `t1` (
1089 `a` int(11) DEFAULT NULL,
1090 `b` varchar(64) DEFAULT NULL
1091 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1092 PARTITION BY LIST (`a`)
1093 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1094 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1095 SELECT * FROM t1;
1096 a b
1097 1 Original from partition p0
1098 11 Original from partition p1
1099 12 Original from partition p1
1100 13 Original from partition p1
1101 14 Original from partition p1
1102 2 Original from partition p0
1103 3 Original from partition p0
1104 4 Original from partition p0
1105 LOCK TABLE t1 WRITE;
1106 ALTER TABLE t1 ADD PARTITION
1107 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
1108 ERROR HY000: Unknown error
1109 # d,fail_add_partition_9: AFTER failure (under LOCK TABLE)
1110 db.opt
1111 t1#P#p0.ibd
1112 t1#P#p10.ibd
1113 t1#P#p20.ibd
1114 t1.frm
1115 t1.par
1116 SHOW CREATE TABLE t1;
1117 Table Create Table
1118 t1 CREATE TABLE `t1` (
1119 `a` int(11) DEFAULT NULL,
1120 `b` varchar(64) DEFAULT NULL
1121 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1122 PARTITION BY LIST (`a`)
1123 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1124 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
1125 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
1126 SELECT * FROM t1;
1127 a b
1128 1 Original from partition p0
1129 11 Original from partition p1
1130 12 Original from partition p1
1131 13 Original from partition p1
1132 14 Original from partition p1
1133 2 Original from partition p0
1134 3 Original from partition p0
1135 4 Original from partition p0
1136 UNLOCK TABLES;
1137 DROP TABLE t1;
1138 SET SESSION debug_dbug=@save_dbug;
1139 SET SESSION debug_dbug="+d,fail_add_partition_10";
1140 CREATE TABLE t1 (a INT, b VARCHAR(64))
1141 ENGINE = 'InnoDB'
1142 PARTITION BY LIST (a)
1143 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1144 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1145 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1146 # d,fail_add_partition_10: BEFORE failure
1147 db.opt
1148 t1#P#p0.ibd
1149 t1#P#p10.ibd
1150 t1.frm
1151 t1.par
1152 SHOW CREATE TABLE t1;
1153 Table Create Table
1154 t1 CREATE TABLE `t1` (
1155 `a` int(11) DEFAULT NULL,
1156 `b` varchar(64) DEFAULT NULL
1157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1158 PARTITION BY LIST (`a`)
1159 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1160 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1161 SELECT * FROM t1;
1162 a b
1163 1 Original from partition p0
1164 11 Original from partition p1
1165 12 Original from partition p1
1166 13 Original from partition p1
1167 14 Original from partition p1
1168 2 Original from partition p0
1169 3 Original from partition p0
1170 4 Original from partition p0
1171 ALTER TABLE t1 ADD PARTITION
1172 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
1173 ERROR HY000: Unknown error
1174 # d,fail_add_partition_10: AFTER failure
1175 db.opt
1176 t1#P#p0.ibd
1177 t1#P#p10.ibd
1178 t1#P#p20.ibd
1179 t1.frm
1180 t1.par
1181 SHOW CREATE TABLE t1;
1182 Table Create Table
1183 t1 CREATE TABLE `t1` (
1184 `a` int(11) DEFAULT NULL,
1185 `b` varchar(64) DEFAULT NULL
1186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1187 PARTITION BY LIST (`a`)
1188 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1189 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
1190 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
1191 SELECT * FROM t1;
1192 a b
1193 1 Original from partition p0
1194 11 Original from partition p1
1195 12 Original from partition p1
1196 13 Original from partition p1
1197 14 Original from partition p1
1198 2 Original from partition p0
1199 3 Original from partition p0
1200 4 Original from partition p0
1201 DROP TABLE t1;
1202 CREATE TABLE t1 (a INT, b VARCHAR(64))
1203 ENGINE = 'InnoDB'
1204 PARTITION BY LIST (a)
1205 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1206 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1207 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1208 # d,fail_add_partition_10: BEFORE failure (under LOCK TABLE)
1209 db.opt
1210 t1#P#p0.ibd
1211 t1#P#p10.ibd
1212 t1.frm
1213 t1.par
1214 SHOW CREATE TABLE t1;
1215 Table Create Table
1216 t1 CREATE TABLE `t1` (
1217 `a` int(11) DEFAULT NULL,
1218 `b` varchar(64) DEFAULT NULL
1219 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1220 PARTITION BY LIST (`a`)
1221 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1222 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1223 SELECT * FROM t1;
1224 a b
1225 1 Original from partition p0
1226 11 Original from partition p1
1227 12 Original from partition p1
1228 13 Original from partition p1
1229 14 Original from partition p1
1230 2 Original from partition p0
1231 3 Original from partition p0
1232 4 Original from partition p0
1233 LOCK TABLE t1 WRITE;
1234 ALTER TABLE t1 ADD PARTITION
1235 (PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
1236 ERROR HY000: Unknown error
1237 # d,fail_add_partition_10: AFTER failure (under LOCK TABLE)
1238 db.opt
1239 t1#P#p0.ibd
1240 t1#P#p10.ibd
1241 t1#P#p20.ibd
1242 t1.frm
1243 t1.par
1244 SHOW CREATE TABLE t1;
1245 Table Create Table
1246 t1 CREATE TABLE `t1` (
1247 `a` int(11) DEFAULT NULL,
1248 `b` varchar(64) DEFAULT NULL
1249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1250 PARTITION BY LIST (`a`)
1251 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1252 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
1253 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
1254 SELECT * FROM t1;
1255 a b
1256 1 Original from partition p0
1257 11 Original from partition p1
1258 12 Original from partition p1
1259 13 Original from partition p1
1260 14 Original from partition p1
1261 2 Original from partition p0
1262 3 Original from partition p0
1263 4 Original from partition p0
1264 UNLOCK TABLES;
1265 DROP TABLE t1;
1266 SET SESSION debug_dbug=@save_dbug;
1267 # Error recovery DROP PARTITION
1268 SET @save_dbug=@@debug_dbug;
1269 SET SESSION debug_dbug="+d,fail_drop_partition_1";
1270 CREATE TABLE t1 (a INT, b VARCHAR(64))
1271 ENGINE = 'InnoDB'
1272 PARTITION BY LIST (a)
1273 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1274 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1275 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1276 # d,fail_drop_partition_1: BEFORE failure
1277 db.opt
1278 t1#P#p0.ibd
1279 t1#P#p10.ibd
1280 t1.frm
1281 t1.par
1282 SHOW CREATE TABLE t1;
1283 Table Create Table
1284 t1 CREATE TABLE `t1` (
1285 `a` int(11) DEFAULT NULL,
1286 `b` varchar(64) DEFAULT NULL
1287 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1288 PARTITION BY LIST (`a`)
1289 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1290 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1291 SELECT * FROM t1;
1292 a b
1293 1 Original from partition p0
1294 11 Original from partition p1
1295 12 Original from partition p1
1296 13 Original from partition p1
1297 14 Original from partition p1
1298 2 Original from partition p0
1299 3 Original from partition p0
1300 4 Original from partition p0
1301 ALTER TABLE t1 DROP PARTITION p10;
1302 ERROR HY000: Unknown error
1303 # d,fail_drop_partition_1: AFTER failure
1304 db.opt
1305 t1#P#p0.ibd
1306 t1#P#p10.ibd
1307 t1.frm
1308 t1.par
1309 SHOW CREATE TABLE t1;
1310 Table Create Table
1311 t1 CREATE TABLE `t1` (
1312 `a` int(11) DEFAULT NULL,
1313 `b` varchar(64) DEFAULT NULL
1314 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1315 PARTITION BY LIST (`a`)
1316 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1317 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1318 SELECT * FROM t1;
1319 a b
1320 1 Original from partition p0
1321 11 Original from partition p1
1322 12 Original from partition p1
1323 13 Original from partition p1
1324 14 Original from partition p1
1325 2 Original from partition p0
1326 3 Original from partition p0
1327 4 Original from partition p0
1328 DROP TABLE t1;
1329 CREATE TABLE t1 (a INT, b VARCHAR(64))
1330 ENGINE = 'InnoDB'
1331 PARTITION BY LIST (a)
1332 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1333 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1334 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1335 # d,fail_drop_partition_1: BEFORE failure (under LOCK TABLE)
1336 db.opt
1337 t1#P#p0.ibd
1338 t1#P#p10.ibd
1339 t1.frm
1340 t1.par
1341 SHOW CREATE TABLE t1;
1342 Table Create Table
1343 t1 CREATE TABLE `t1` (
1344 `a` int(11) DEFAULT NULL,
1345 `b` varchar(64) DEFAULT NULL
1346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1347 PARTITION BY LIST (`a`)
1348 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1349 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1350 SELECT * FROM t1;
1351 a b
1352 1 Original from partition p0
1353 11 Original from partition p1
1354 12 Original from partition p1
1355 13 Original from partition p1
1356 14 Original from partition p1
1357 2 Original from partition p0
1358 3 Original from partition p0
1359 4 Original from partition p0
1360 LOCK TABLE t1 WRITE;
1361 ALTER TABLE t1 DROP PARTITION p10;
1362 ERROR HY000: Unknown error
1363 # d,fail_drop_partition_1: AFTER failure (under LOCK TABLE)
1364 db.opt
1365 t1#P#p0.ibd
1366 t1#P#p10.ibd
1367 t1.frm
1368 t1.par
1369 SHOW CREATE TABLE t1;
1370 Table Create Table
1371 t1 CREATE TABLE `t1` (
1372 `a` int(11) DEFAULT NULL,
1373 `b` varchar(64) DEFAULT NULL
1374 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1375 PARTITION BY LIST (`a`)
1376 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1377 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1378 SELECT * FROM t1;
1379 a b
1380 1 Original from partition p0
1381 11 Original from partition p1
1382 12 Original from partition p1
1383 13 Original from partition p1
1384 14 Original from partition p1
1385 2 Original from partition p0
1386 3 Original from partition p0
1387 4 Original from partition p0
1388 UNLOCK TABLES;
1389 DROP TABLE t1;
1390 SET SESSION debug_dbug=@save_dbug;
1391 SET SESSION debug_dbug="+d,fail_drop_partition_2";
1392 CREATE TABLE t1 (a INT, b VARCHAR(64))
1393 ENGINE = 'InnoDB'
1394 PARTITION BY LIST (a)
1395 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1396 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1397 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1398 # d,fail_drop_partition_2: BEFORE failure
1399 db.opt
1400 t1#P#p0.ibd
1401 t1#P#p10.ibd
1402 t1.frm
1403 t1.par
1404 SHOW CREATE TABLE t1;
1405 Table Create Table
1406 t1 CREATE TABLE `t1` (
1407 `a` int(11) DEFAULT NULL,
1408 `b` varchar(64) DEFAULT NULL
1409 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1410 PARTITION BY LIST (`a`)
1411 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1412 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1413 SELECT * FROM t1;
1414 a b
1415 1 Original from partition p0
1416 11 Original from partition p1
1417 12 Original from partition p1
1418 13 Original from partition p1
1419 14 Original from partition p1
1420 2 Original from partition p0
1421 3 Original from partition p0
1422 4 Original from partition p0
1423 ALTER TABLE t1 DROP PARTITION p10;
1424 ERROR HY000: Unknown error
1425 # d,fail_drop_partition_2: AFTER failure
1426 db.opt
1427 t1#P#p0.ibd
1428 t1#P#p10.ibd
1429 t1.frm
1430 t1.par
1431 SHOW CREATE TABLE t1;
1432 Table Create Table
1433 t1 CREATE TABLE `t1` (
1434 `a` int(11) DEFAULT NULL,
1435 `b` varchar(64) DEFAULT NULL
1436 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1437 PARTITION BY LIST (`a`)
1438 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1439 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1440 SELECT * FROM t1;
1441 a b
1442 1 Original from partition p0
1443 11 Original from partition p1
1444 12 Original from partition p1
1445 13 Original from partition p1
1446 14 Original from partition p1
1447 2 Original from partition p0
1448 3 Original from partition p0
1449 4 Original from partition p0
1450 DROP TABLE t1;
1451 CREATE TABLE t1 (a INT, b VARCHAR(64))
1452 ENGINE = 'InnoDB'
1453 PARTITION BY LIST (a)
1454 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1455 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1456 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1457 # d,fail_drop_partition_2: BEFORE failure (under LOCK TABLE)
1458 db.opt
1459 t1#P#p0.ibd
1460 t1#P#p10.ibd
1461 t1.frm
1462 t1.par
1463 SHOW CREATE TABLE t1;
1464 Table Create Table
1465 t1 CREATE TABLE `t1` (
1466 `a` int(11) DEFAULT NULL,
1467 `b` varchar(64) DEFAULT NULL
1468 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1469 PARTITION BY LIST (`a`)
1470 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1471 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1472 SELECT * FROM t1;
1473 a b
1474 1 Original from partition p0
1475 11 Original from partition p1
1476 12 Original from partition p1
1477 13 Original from partition p1
1478 14 Original from partition p1
1479 2 Original from partition p0
1480 3 Original from partition p0
1481 4 Original from partition p0
1482 LOCK TABLE t1 WRITE;
1483 ALTER TABLE t1 DROP PARTITION p10;
1484 ERROR HY000: Unknown error
1485 # d,fail_drop_partition_2: AFTER failure (under LOCK TABLE)
1486 db.opt
1487 t1#P#p0.ibd
1488 t1#P#p10.ibd
1489 t1.frm
1490 t1.par
1491 SHOW CREATE TABLE t1;
1492 Table Create Table
1493 t1 CREATE TABLE `t1` (
1494 `a` int(11) DEFAULT NULL,
1495 `b` varchar(64) DEFAULT NULL
1496 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1497 PARTITION BY LIST (`a`)
1498 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1499 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1500 SELECT * FROM t1;
1501 a b
1502 1 Original from partition p0
1503 11 Original from partition p1
1504 12 Original from partition p1
1505 13 Original from partition p1
1506 14 Original from partition p1
1507 2 Original from partition p0
1508 3 Original from partition p0
1509 4 Original from partition p0
1510 UNLOCK TABLES;
1511 DROP TABLE t1;
1512 SET SESSION debug_dbug=@save_dbug;
1513 SET SESSION debug_dbug="+d,fail_drop_partition_3";
1514 CREATE TABLE t1 (a INT, b VARCHAR(64))
1515 ENGINE = 'InnoDB'
1516 PARTITION BY LIST (a)
1517 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1518 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1519 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1520 # d,fail_drop_partition_3: BEFORE failure
1521 db.opt
1522 t1#P#p0.ibd
1523 t1#P#p10.ibd
1524 t1.frm
1525 t1.par
1526 SHOW CREATE TABLE t1;
1527 Table Create Table
1528 t1 CREATE TABLE `t1` (
1529 `a` int(11) DEFAULT NULL,
1530 `b` varchar(64) DEFAULT NULL
1531 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1532 PARTITION BY LIST (`a`)
1533 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1534 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1535 SELECT * FROM t1;
1536 a b
1537 1 Original from partition p0
1538 11 Original from partition p1
1539 12 Original from partition p1
1540 13 Original from partition p1
1541 14 Original from partition p1
1542 2 Original from partition p0
1543 3 Original from partition p0
1544 4 Original from partition p0
1545 ALTER TABLE t1 DROP PARTITION p10;
1546 ERROR HY000: Unknown error
1547 # d,fail_drop_partition_3: AFTER failure
1548 db.opt
1549 t1#P#p0.ibd
1550 t1#P#p10.ibd
1551 t1.frm
1552 t1.par
1553 SHOW CREATE TABLE t1;
1554 Table Create Table
1555 t1 CREATE TABLE `t1` (
1556 `a` int(11) DEFAULT NULL,
1557 `b` varchar(64) DEFAULT NULL
1558 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1559 PARTITION BY LIST (`a`)
1560 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1561 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1562 SELECT * FROM t1;
1563 a b
1564 1 Original from partition p0
1565 11 Original from partition p1
1566 12 Original from partition p1
1567 13 Original from partition p1
1568 14 Original from partition p1
1569 2 Original from partition p0
1570 3 Original from partition p0
1571 4 Original from partition p0
1572 DROP TABLE t1;
1573 CREATE TABLE t1 (a INT, b VARCHAR(64))
1574 ENGINE = 'InnoDB'
1575 PARTITION BY LIST (a)
1576 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1577 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1578 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1579 # d,fail_drop_partition_3: BEFORE failure (under LOCK TABLE)
1580 db.opt
1581 t1#P#p0.ibd
1582 t1#P#p10.ibd
1583 t1.frm
1584 t1.par
1585 SHOW CREATE TABLE t1;
1586 Table Create Table
1587 t1 CREATE TABLE `t1` (
1588 `a` int(11) DEFAULT NULL,
1589 `b` varchar(64) DEFAULT NULL
1590 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1591 PARTITION BY LIST (`a`)
1592 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1593 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1594 SELECT * FROM t1;
1595 a b
1596 1 Original from partition p0
1597 11 Original from partition p1
1598 12 Original from partition p1
1599 13 Original from partition p1
1600 14 Original from partition p1
1601 2 Original from partition p0
1602 3 Original from partition p0
1603 4 Original from partition p0
1604 LOCK TABLE t1 WRITE;
1605 ALTER TABLE t1 DROP PARTITION p10;
1606 ERROR HY000: Unknown error
1607 # d,fail_drop_partition_3: AFTER failure (under LOCK TABLE)
1608 db.opt
1609 t1#P#p0.ibd
1610 t1#P#p10.ibd
1611 t1.frm
1612 t1.par
1613 SHOW CREATE TABLE t1;
1614 Table Create Table
1615 t1 CREATE TABLE `t1` (
1616 `a` int(11) DEFAULT NULL,
1617 `b` varchar(64) DEFAULT NULL
1618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1619 PARTITION BY LIST (`a`)
1620 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1621 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1622 SELECT * FROM t1;
1623 a b
1624 1 Original from partition p0
1625 11 Original from partition p1
1626 12 Original from partition p1
1627 13 Original from partition p1
1628 14 Original from partition p1
1629 2 Original from partition p0
1630 3 Original from partition p0
1631 4 Original from partition p0
1632 UNLOCK TABLES;
1633 DROP TABLE t1;
1634 SET SESSION debug_dbug=@save_dbug;
1635 SET SESSION debug_dbug="+d,fail_drop_partition_4";
1636 CREATE TABLE t1 (a INT, b VARCHAR(64))
1637 ENGINE = 'InnoDB'
1638 PARTITION BY LIST (a)
1639 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1640 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1641 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1642 # d,fail_drop_partition_4: BEFORE failure
1643 db.opt
1644 t1#P#p0.ibd
1645 t1#P#p10.ibd
1646 t1.frm
1647 t1.par
1648 SHOW CREATE TABLE t1;
1649 Table Create Table
1650 t1 CREATE TABLE `t1` (
1651 `a` int(11) DEFAULT NULL,
1652 `b` varchar(64) DEFAULT NULL
1653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1654 PARTITION BY LIST (`a`)
1655 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1656 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1657 SELECT * FROM t1;
1658 a b
1659 1 Original from partition p0
1660 11 Original from partition p1
1661 12 Original from partition p1
1662 13 Original from partition p1
1663 14 Original from partition p1
1664 2 Original from partition p0
1665 3 Original from partition p0
1666 4 Original from partition p0
1667 ALTER TABLE t1 DROP PARTITION p10;
1668 ERROR HY000: Unknown error
1669 # d,fail_drop_partition_4: AFTER failure
1670 db.opt
1671 t1#P#p0.ibd
1672 t1.frm
1673 t1.par
1674 SHOW CREATE TABLE t1;
1675 Table Create Table
1676 t1 CREATE TABLE `t1` (
1677 `a` int(11) DEFAULT NULL,
1678 `b` varchar(64) DEFAULT NULL
1679 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1680 PARTITION BY LIST (`a`)
1681 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1682 SELECT * FROM t1;
1683 a b
1684 1 Original from partition p0
1685 2 Original from partition p0
1686 3 Original from partition p0
1687 4 Original from partition p0
1688 DROP TABLE t1;
1689 CREATE TABLE t1 (a INT, b VARCHAR(64))
1690 ENGINE = 'InnoDB'
1691 PARTITION BY LIST (a)
1692 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1693 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1694 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1695 # d,fail_drop_partition_4: BEFORE failure (under LOCK TABLE)
1696 db.opt
1697 t1#P#p0.ibd
1698 t1#P#p10.ibd
1699 t1.frm
1700 t1.par
1701 SHOW CREATE TABLE t1;
1702 Table Create Table
1703 t1 CREATE TABLE `t1` (
1704 `a` int(11) DEFAULT NULL,
1705 `b` varchar(64) DEFAULT NULL
1706 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1707 PARTITION BY LIST (`a`)
1708 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1709 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1710 SELECT * FROM t1;
1711 a b
1712 1 Original from partition p0
1713 11 Original from partition p1
1714 12 Original from partition p1
1715 13 Original from partition p1
1716 14 Original from partition p1
1717 2 Original from partition p0
1718 3 Original from partition p0
1719 4 Original from partition p0
1720 LOCK TABLE t1 WRITE;
1721 ALTER TABLE t1 DROP PARTITION p10;
1722 ERROR HY000: Unknown error
1723 # d,fail_drop_partition_4: AFTER failure (under LOCK TABLE)
1724 db.opt
1725 t1#P#p0.ibd
1726 t1.frm
1727 t1.par
1728 SHOW CREATE TABLE t1;
1729 Table Create Table
1730 t1 CREATE TABLE `t1` (
1731 `a` int(11) DEFAULT NULL,
1732 `b` varchar(64) DEFAULT NULL
1733 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1734 PARTITION BY LIST (`a`)
1735 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1736 SELECT * FROM t1;
1737 a b
1738 1 Original from partition p0
1739 2 Original from partition p0
1740 3 Original from partition p0
1741 4 Original from partition p0
1742 UNLOCK TABLES;
1743 DROP TABLE t1;
1744 SET SESSION debug_dbug=@save_dbug;
1745 SET SESSION debug_dbug="+d,fail_drop_partition_5";
1746 CREATE TABLE t1 (a INT, b VARCHAR(64))
1747 ENGINE = 'InnoDB'
1748 PARTITION BY LIST (a)
1749 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1750 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1751 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1752 # d,fail_drop_partition_5: BEFORE failure
1753 db.opt
1754 t1#P#p0.ibd
1755 t1#P#p10.ibd
1756 t1.frm
1757 t1.par
1758 SHOW CREATE TABLE t1;
1759 Table Create Table
1760 t1 CREATE TABLE `t1` (
1761 `a` int(11) DEFAULT NULL,
1762 `b` varchar(64) DEFAULT NULL
1763 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1764 PARTITION BY LIST (`a`)
1765 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1766 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1767 SELECT * FROM t1;
1768 a b
1769 1 Original from partition p0
1770 11 Original from partition p1
1771 12 Original from partition p1
1772 13 Original from partition p1
1773 14 Original from partition p1
1774 2 Original from partition p0
1775 3 Original from partition p0
1776 4 Original from partition p0
1777 ALTER TABLE t1 DROP PARTITION p10;
1778 ERROR HY000: Unknown error
1779 # d,fail_drop_partition_5: AFTER failure
1780 db.opt
1781 t1#P#p0.ibd
1782 t1.frm
1783 t1.par
1784 SHOW CREATE TABLE t1;
1785 Table Create Table
1786 t1 CREATE TABLE `t1` (
1787 `a` int(11) DEFAULT NULL,
1788 `b` varchar(64) DEFAULT NULL
1789 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1790 PARTITION BY LIST (`a`)
1791 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1792 SELECT * FROM t1;
1793 a b
1794 1 Original from partition p0
1795 2 Original from partition p0
1796 3 Original from partition p0
1797 4 Original from partition p0
1798 DROP TABLE t1;
1799 CREATE TABLE t1 (a INT, b VARCHAR(64))
1800 ENGINE = 'InnoDB'
1801 PARTITION BY LIST (a)
1802 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1803 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1804 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1805 # d,fail_drop_partition_5: BEFORE failure (under LOCK TABLE)
1806 db.opt
1807 t1#P#p0.ibd
1808 t1#P#p10.ibd
1809 t1.frm
1810 t1.par
1811 SHOW CREATE TABLE t1;
1812 Table Create Table
1813 t1 CREATE TABLE `t1` (
1814 `a` int(11) DEFAULT NULL,
1815 `b` varchar(64) DEFAULT NULL
1816 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1817 PARTITION BY LIST (`a`)
1818 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1819 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1820 SELECT * FROM t1;
1821 a b
1822 1 Original from partition p0
1823 11 Original from partition p1
1824 12 Original from partition p1
1825 13 Original from partition p1
1826 14 Original from partition p1
1827 2 Original from partition p0
1828 3 Original from partition p0
1829 4 Original from partition p0
1830 LOCK TABLE t1 WRITE;
1831 ALTER TABLE t1 DROP PARTITION p10;
1832 ERROR HY000: Unknown error
1833 # d,fail_drop_partition_5: AFTER failure (under LOCK TABLE)
1834 db.opt
1835 t1#P#p0.ibd
1836 t1.frm
1837 t1.par
1838 SHOW CREATE TABLE t1;
1839 Table Create Table
1840 t1 CREATE TABLE `t1` (
1841 `a` int(11) DEFAULT NULL,
1842 `b` varchar(64) DEFAULT NULL
1843 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1844 PARTITION BY LIST (`a`)
1845 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1846 SELECT * FROM t1;
1847 a b
1848 1 Original from partition p0
1849 2 Original from partition p0
1850 3 Original from partition p0
1851 4 Original from partition p0
1852 UNLOCK TABLES;
1853 DROP TABLE t1;
1854 SET SESSION debug_dbug=@save_dbug;
1855 SET SESSION debug_dbug="+d,fail_drop_partition_6";
1856 CREATE TABLE t1 (a INT, b VARCHAR(64))
1857 ENGINE = 'InnoDB'
1858 PARTITION BY LIST (a)
1859 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1860 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1861 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1862 # d,fail_drop_partition_6: BEFORE failure
1863 db.opt
1864 t1#P#p0.ibd
1865 t1#P#p10.ibd
1866 t1.frm
1867 t1.par
1868 SHOW CREATE TABLE t1;
1869 Table Create Table
1870 t1 CREATE TABLE `t1` (
1871 `a` int(11) DEFAULT NULL,
1872 `b` varchar(64) DEFAULT NULL
1873 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1874 PARTITION BY LIST (`a`)
1875 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1876 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1877 SELECT * FROM t1;
1878 a b
1879 1 Original from partition p0
1880 11 Original from partition p1
1881 12 Original from partition p1
1882 13 Original from partition p1
1883 14 Original from partition p1
1884 2 Original from partition p0
1885 3 Original from partition p0
1886 4 Original from partition p0
1887 ALTER TABLE t1 DROP PARTITION p10;
1888 ERROR HY000: Unknown error
1889 # d,fail_drop_partition_6: AFTER failure
1890 db.opt
1891 t1#P#p0.ibd
1892 t1.frm
1893 t1.par
1894 SHOW CREATE TABLE t1;
1895 Table Create Table
1896 t1 CREATE TABLE `t1` (
1897 `a` int(11) DEFAULT NULL,
1898 `b` varchar(64) DEFAULT NULL
1899 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1900 PARTITION BY LIST (`a`)
1901 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1902 SELECT * FROM t1;
1903 a b
1904 1 Original from partition p0
1905 2 Original from partition p0
1906 3 Original from partition p0
1907 4 Original from partition p0
1908 DROP TABLE t1;
1909 CREATE TABLE t1 (a INT, b VARCHAR(64))
1910 ENGINE = 'InnoDB'
1911 PARTITION BY LIST (a)
1912 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1913 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1914 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1915 # d,fail_drop_partition_6: BEFORE failure (under LOCK TABLE)
1916 db.opt
1917 t1#P#p0.ibd
1918 t1#P#p10.ibd
1919 t1.frm
1920 t1.par
1921 SHOW CREATE TABLE t1;
1922 Table Create Table
1923 t1 CREATE TABLE `t1` (
1924 `a` int(11) DEFAULT NULL,
1925 `b` varchar(64) DEFAULT NULL
1926 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1927 PARTITION BY LIST (`a`)
1928 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1929 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1930 SELECT * FROM t1;
1931 a b
1932 1 Original from partition p0
1933 11 Original from partition p1
1934 12 Original from partition p1
1935 13 Original from partition p1
1936 14 Original from partition p1
1937 2 Original from partition p0
1938 3 Original from partition p0
1939 4 Original from partition p0
1940 LOCK TABLE t1 WRITE;
1941 ALTER TABLE t1 DROP PARTITION p10;
1942 ERROR HY000: Unknown error
1943 # d,fail_drop_partition_6: AFTER failure (under LOCK TABLE)
1944 db.opt
1945 t1#P#p0.ibd
1946 t1.frm
1947 t1.par
1948 SHOW CREATE TABLE t1;
1949 Table Create Table
1950 t1 CREATE TABLE `t1` (
1951 `a` int(11) DEFAULT NULL,
1952 `b` varchar(64) DEFAULT NULL
1953 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1954 PARTITION BY LIST (`a`)
1955 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
1956 SELECT * FROM t1;
1957 a b
1958 1 Original from partition p0
1959 2 Original from partition p0
1960 3 Original from partition p0
1961 4 Original from partition p0
1962 UNLOCK TABLES;
1963 DROP TABLE t1;
1964 SET SESSION debug_dbug=@save_dbug;
1965 SET SESSION debug_dbug="+d,fail_drop_partition_7";
1966 CREATE TABLE t1 (a INT, b VARCHAR(64))
1967 ENGINE = 'InnoDB'
1968 PARTITION BY LIST (a)
1969 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
1970 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
1971 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
1972 # d,fail_drop_partition_7: BEFORE failure
1973 db.opt
1974 t1#P#p0.ibd
1975 t1#P#p10.ibd
1976 t1.frm
1977 t1.par
1978 SHOW CREATE TABLE t1;
1979 Table Create Table
1980 t1 CREATE TABLE `t1` (
1981 `a` int(11) DEFAULT NULL,
1982 `b` varchar(64) DEFAULT NULL
1983 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1984 PARTITION BY LIST (`a`)
1985 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
1986 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
1987 SELECT * FROM t1;
1988 a b
1989 1 Original from partition p0
1990 11 Original from partition p1
1991 12 Original from partition p1
1992 13 Original from partition p1
1993 14 Original from partition p1
1994 2 Original from partition p0
1995 3 Original from partition p0
1996 4 Original from partition p0
1997 ALTER TABLE t1 DROP PARTITION p10;
1998 ERROR HY000: Unknown error
1999 # d,fail_drop_partition_7: AFTER failure
2000 db.opt
2001 t1#P#p0.ibd
2002 t1.frm
2003 t1.par
2004 SHOW CREATE TABLE t1;
2005 Table Create Table
2006 t1 CREATE TABLE `t1` (
2007 `a` int(11) DEFAULT NULL,
2008 `b` varchar(64) DEFAULT NULL
2009 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2010 PARTITION BY LIST (`a`)
2011 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2012 SELECT * FROM t1;
2013 a b
2014 1 Original from partition p0
2015 2 Original from partition p0
2016 3 Original from partition p0
2017 4 Original from partition p0
2018 DROP TABLE t1;
2019 CREATE TABLE t1 (a INT, b VARCHAR(64))
2020 ENGINE = 'InnoDB'
2021 PARTITION BY LIST (a)
2022 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2023 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2024 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2025 # d,fail_drop_partition_7: BEFORE failure (under LOCK TABLE)
2026 db.opt
2027 t1#P#p0.ibd
2028 t1#P#p10.ibd
2029 t1.frm
2030 t1.par
2031 SHOW CREATE TABLE t1;
2032 Table Create Table
2033 t1 CREATE TABLE `t1` (
2034 `a` int(11) DEFAULT NULL,
2035 `b` varchar(64) DEFAULT NULL
2036 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2037 PARTITION BY LIST (`a`)
2038 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2039 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2040 SELECT * FROM t1;
2041 a b
2042 1 Original from partition p0
2043 11 Original from partition p1
2044 12 Original from partition p1
2045 13 Original from partition p1
2046 14 Original from partition p1
2047 2 Original from partition p0
2048 3 Original from partition p0
2049 4 Original from partition p0
2050 LOCK TABLE t1 WRITE;
2051 ALTER TABLE t1 DROP PARTITION p10;
2052 ERROR HY000: Unknown error
2053 # d,fail_drop_partition_7: AFTER failure (under LOCK TABLE)
2054 db.opt
2055 t1#P#p0.ibd
2056 t1.frm
2057 t1.par
2058 SHOW CREATE TABLE t1;
2059 Table Create Table
2060 t1 CREATE TABLE `t1` (
2061 `a` int(11) DEFAULT NULL,
2062 `b` varchar(64) DEFAULT NULL
2063 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2064 PARTITION BY LIST (`a`)
2065 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2066 SELECT * FROM t1;
2067 a b
2068 1 Original from partition p0
2069 2 Original from partition p0
2070 3 Original from partition p0
2071 4 Original from partition p0
2072 UNLOCK TABLES;
2073 DROP TABLE t1;
2074 SET SESSION debug_dbug=@save_dbug;
2075 SET SESSION debug_dbug="+d,fail_drop_partition_8";
2076 CREATE TABLE t1 (a INT, b VARCHAR(64))
2077 ENGINE = 'InnoDB'
2078 PARTITION BY LIST (a)
2079 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2080 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2081 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2082 # d,fail_drop_partition_8: BEFORE failure
2083 db.opt
2084 t1#P#p0.ibd
2085 t1#P#p10.ibd
2086 t1.frm
2087 t1.par
2088 SHOW CREATE TABLE t1;
2089 Table Create Table
2090 t1 CREATE TABLE `t1` (
2091 `a` int(11) DEFAULT NULL,
2092 `b` varchar(64) DEFAULT NULL
2093 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2094 PARTITION BY LIST (`a`)
2095 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2096 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2097 SELECT * FROM t1;
2098 a b
2099 1 Original from partition p0
2100 11 Original from partition p1
2101 12 Original from partition p1
2102 13 Original from partition p1
2103 14 Original from partition p1
2104 2 Original from partition p0
2105 3 Original from partition p0
2106 4 Original from partition p0
2107 ALTER TABLE t1 DROP PARTITION p10;
2108 ERROR HY000: Unknown error
2109 # d,fail_drop_partition_8: AFTER failure
2110 db.opt
2111 t1#P#p0.ibd
2112 t1.frm
2113 t1.par
2114 SHOW CREATE TABLE t1;
2115 Table Create Table
2116 t1 CREATE TABLE `t1` (
2117 `a` int(11) DEFAULT NULL,
2118 `b` varchar(64) DEFAULT NULL
2119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2120 PARTITION BY LIST (`a`)
2121 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2122 SELECT * FROM t1;
2123 a b
2124 1 Original from partition p0
2125 2 Original from partition p0
2126 3 Original from partition p0
2127 4 Original from partition p0
2128 DROP TABLE t1;
2129 CREATE TABLE t1 (a INT, b VARCHAR(64))
2130 ENGINE = 'InnoDB'
2131 PARTITION BY LIST (a)
2132 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2133 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2134 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2135 # d,fail_drop_partition_8: BEFORE failure (under LOCK TABLE)
2136 db.opt
2137 t1#P#p0.ibd
2138 t1#P#p10.ibd
2139 t1.frm
2140 t1.par
2141 SHOW CREATE TABLE t1;
2142 Table Create Table
2143 t1 CREATE TABLE `t1` (
2144 `a` int(11) DEFAULT NULL,
2145 `b` varchar(64) DEFAULT NULL
2146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2147 PARTITION BY LIST (`a`)
2148 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2149 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2150 SELECT * FROM t1;
2151 a b
2152 1 Original from partition p0
2153 11 Original from partition p1
2154 12 Original from partition p1
2155 13 Original from partition p1
2156 14 Original from partition p1
2157 2 Original from partition p0
2158 3 Original from partition p0
2159 4 Original from partition p0
2160 LOCK TABLE t1 WRITE;
2161 ALTER TABLE t1 DROP PARTITION p10;
2162 ERROR HY000: Unknown error
2163 # d,fail_drop_partition_8: AFTER failure (under LOCK TABLE)
2164 db.opt
2165 t1#P#p0.ibd
2166 t1.frm
2167 t1.par
2168 SHOW CREATE TABLE t1;
2169 Table Create Table
2170 t1 CREATE TABLE `t1` (
2171 `a` int(11) DEFAULT NULL,
2172 `b` varchar(64) DEFAULT NULL
2173 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2174 PARTITION BY LIST (`a`)
2175 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2176 SELECT * FROM t1;
2177 a b
2178 1 Original from partition p0
2179 2 Original from partition p0
2180 3 Original from partition p0
2181 4 Original from partition p0
2182 UNLOCK TABLES;
2183 DROP TABLE t1;
2184 SET SESSION debug_dbug=@save_dbug;
2185 SET SESSION debug_dbug="+d,fail_drop_partition_9";
2186 CREATE TABLE t1 (a INT, b VARCHAR(64))
2187 ENGINE = 'InnoDB'
2188 PARTITION BY LIST (a)
2189 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2190 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2191 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2192 # d,fail_drop_partition_9: BEFORE failure
2193 db.opt
2194 t1#P#p0.ibd
2195 t1#P#p10.ibd
2196 t1.frm
2197 t1.par
2198 SHOW CREATE TABLE t1;
2199 Table Create Table
2200 t1 CREATE TABLE `t1` (
2201 `a` int(11) DEFAULT NULL,
2202 `b` varchar(64) DEFAULT NULL
2203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2204 PARTITION BY LIST (`a`)
2205 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2206 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2207 SELECT * FROM t1;
2208 a b
2209 1 Original from partition p0
2210 11 Original from partition p1
2211 12 Original from partition p1
2212 13 Original from partition p1
2213 14 Original from partition p1
2214 2 Original from partition p0
2215 3 Original from partition p0
2216 4 Original from partition p0
2217 ALTER TABLE t1 DROP PARTITION p10;
2218 ERROR HY000: Unknown error
2219 # d,fail_drop_partition_9: AFTER failure
2220 db.opt
2221 t1#P#p0.ibd
2222 t1.frm
2223 t1.par
2224 SHOW CREATE TABLE t1;
2225 Table Create Table
2226 t1 CREATE TABLE `t1` (
2227 `a` int(11) DEFAULT NULL,
2228 `b` varchar(64) DEFAULT NULL
2229 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2230 PARTITION BY LIST (`a`)
2231 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2232 SELECT * FROM t1;
2233 a b
2234 1 Original from partition p0
2235 2 Original from partition p0
2236 3 Original from partition p0
2237 4 Original from partition p0
2238 DROP TABLE t1;
2239 CREATE TABLE t1 (a INT, b VARCHAR(64))
2240 ENGINE = 'InnoDB'
2241 PARTITION BY LIST (a)
2242 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2243 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2244 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2245 # d,fail_drop_partition_9: BEFORE failure (under LOCK TABLE)
2246 db.opt
2247 t1#P#p0.ibd
2248 t1#P#p10.ibd
2249 t1.frm
2250 t1.par
2251 SHOW CREATE TABLE t1;
2252 Table Create Table
2253 t1 CREATE TABLE `t1` (
2254 `a` int(11) DEFAULT NULL,
2255 `b` varchar(64) DEFAULT NULL
2256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2257 PARTITION BY LIST (`a`)
2258 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2259 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2260 SELECT * FROM t1;
2261 a b
2262 1 Original from partition p0
2263 11 Original from partition p1
2264 12 Original from partition p1
2265 13 Original from partition p1
2266 14 Original from partition p1
2267 2 Original from partition p0
2268 3 Original from partition p0
2269 4 Original from partition p0
2270 LOCK TABLE t1 WRITE;
2271 ALTER TABLE t1 DROP PARTITION p10;
2272 ERROR HY000: Unknown error
2273 # d,fail_drop_partition_9: AFTER failure (under LOCK TABLE)
2274 db.opt
2275 t1#P#p0.ibd
2276 t1.frm
2277 t1.par
2278 SHOW CREATE TABLE t1;
2279 Table Create Table
2280 t1 CREATE TABLE `t1` (
2281 `a` int(11) DEFAULT NULL,
2282 `b` varchar(64) DEFAULT NULL
2283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2284 PARTITION BY LIST (`a`)
2285 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB)
2286 SELECT * FROM t1;
2287 a b
2288 1 Original from partition p0
2289 2 Original from partition p0
2290 3 Original from partition p0
2291 4 Original from partition p0
2292 UNLOCK TABLES;
2293 DROP TABLE t1;
2294 SET SESSION debug_dbug=@save_dbug;
2295 # Error recovery change partition (REORGANIZE/REBUILD/COALESCE
2296 # or ADD HASH PARTITION).
2297 SET @save_dbug=@@debug_dbug;
2298 SET SESSION debug_dbug="+d,fail_change_partition_1";
2299 CREATE TABLE t1 (a INT, b VARCHAR(64))
2300 ENGINE = 'InnoDB'
2301 PARTITION BY LIST (a)
2302 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2303 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2304 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2305 # d,fail_change_partition_1: BEFORE failure
2306 db.opt
2307 t1#P#p0.ibd
2308 t1#P#p10.ibd
2309 t1.frm
2310 t1.par
2311 SHOW CREATE TABLE t1;
2312 Table Create Table
2313 t1 CREATE TABLE `t1` (
2314 `a` int(11) DEFAULT NULL,
2315 `b` varchar(64) DEFAULT NULL
2316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2317 PARTITION BY LIST (`a`)
2318 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2319 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2320 SELECT * FROM t1;
2321 a b
2322 1 Original from partition p0
2323 11 Original from partition p1
2324 12 Original from partition p1
2325 13 Original from partition p1
2326 14 Original from partition p1
2327 2 Original from partition p0
2328 3 Original from partition p0
2329 4 Original from partition p0
2330 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2331 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2332 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2333 ERROR HY000: Unknown error
2334 # d,fail_change_partition_1: AFTER failure
2335 db.opt
2336 t1#P#p0.ibd
2337 t1#P#p10.ibd
2338 t1.frm
2339 t1.par
2340 SHOW CREATE TABLE t1;
2341 Table Create Table
2342 t1 CREATE TABLE `t1` (
2343 `a` int(11) DEFAULT NULL,
2344 `b` varchar(64) DEFAULT NULL
2345 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2346 PARTITION BY LIST (`a`)
2347 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2348 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2349 SELECT * FROM t1;
2350 a b
2351 1 Original from partition p0
2352 11 Original from partition p1
2353 12 Original from partition p1
2354 13 Original from partition p1
2355 14 Original from partition p1
2356 2 Original from partition p0
2357 3 Original from partition p0
2358 4 Original from partition p0
2359 DROP TABLE t1;
2360 CREATE TABLE t1 (a INT, b VARCHAR(64))
2361 ENGINE = 'InnoDB'
2362 PARTITION BY LIST (a)
2363 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2364 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2365 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2366 # d,fail_change_partition_1: BEFORE failure (under LOCK TABLE)
2367 db.opt
2368 t1#P#p0.ibd
2369 t1#P#p10.ibd
2370 t1.frm
2371 t1.par
2372 SHOW CREATE TABLE t1;
2373 Table Create Table
2374 t1 CREATE TABLE `t1` (
2375 `a` int(11) DEFAULT NULL,
2376 `b` varchar(64) DEFAULT NULL
2377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2378 PARTITION BY LIST (`a`)
2379 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2380 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2381 SELECT * FROM t1;
2382 a b
2383 1 Original from partition p0
2384 11 Original from partition p1
2385 12 Original from partition p1
2386 13 Original from partition p1
2387 14 Original from partition p1
2388 2 Original from partition p0
2389 3 Original from partition p0
2390 4 Original from partition p0
2391 LOCK TABLE t1 WRITE;
2392 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2393 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2394 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2395 ERROR HY000: Unknown error
2396 # d,fail_change_partition_1: AFTER failure (under LOCK TABLE)
2397 db.opt
2398 t1#P#p0.ibd
2399 t1#P#p10.ibd
2400 t1.frm
2401 t1.par
2402 SHOW CREATE TABLE t1;
2403 Table Create Table
2404 t1 CREATE TABLE `t1` (
2405 `a` int(11) DEFAULT NULL,
2406 `b` varchar(64) DEFAULT NULL
2407 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2408 PARTITION BY LIST (`a`)
2409 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2410 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2411 SELECT * FROM t1;
2412 a b
2413 1 Original from partition p0
2414 11 Original from partition p1
2415 12 Original from partition p1
2416 13 Original from partition p1
2417 14 Original from partition p1
2418 2 Original from partition p0
2419 3 Original from partition p0
2420 4 Original from partition p0
2421 UNLOCK TABLES;
2422 DROP TABLE t1;
2423 SET SESSION debug_dbug=@save_dbug;
2424 SET SESSION debug_dbug="+d,fail_change_partition_2";
2425 CREATE TABLE t1 (a INT, b VARCHAR(64))
2426 ENGINE = 'InnoDB'
2427 PARTITION BY LIST (a)
2428 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2429 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2430 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2431 # d,fail_change_partition_2: BEFORE failure
2432 db.opt
2433 t1#P#p0.ibd
2434 t1#P#p10.ibd
2435 t1.frm
2436 t1.par
2437 SHOW CREATE TABLE t1;
2438 Table Create Table
2439 t1 CREATE TABLE `t1` (
2440 `a` int(11) DEFAULT NULL,
2441 `b` varchar(64) DEFAULT NULL
2442 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2443 PARTITION BY LIST (`a`)
2444 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2445 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2446 SELECT * FROM t1;
2447 a b
2448 1 Original from partition p0
2449 11 Original from partition p1
2450 12 Original from partition p1
2451 13 Original from partition p1
2452 14 Original from partition p1
2453 2 Original from partition p0
2454 3 Original from partition p0
2455 4 Original from partition p0
2456 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2457 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2458 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2459 ERROR HY000: Unknown error
2460 # d,fail_change_partition_2: AFTER failure
2461 db.opt
2462 t1#P#p0.ibd
2463 t1#P#p10.ibd
2464 t1.frm
2465 t1.par
2466 SHOW CREATE TABLE t1;
2467 Table Create Table
2468 t1 CREATE TABLE `t1` (
2469 `a` int(11) DEFAULT NULL,
2470 `b` varchar(64) DEFAULT NULL
2471 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2472 PARTITION BY LIST (`a`)
2473 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2474 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2475 SELECT * FROM t1;
2476 a b
2477 1 Original from partition p0
2478 11 Original from partition p1
2479 12 Original from partition p1
2480 13 Original from partition p1
2481 14 Original from partition p1
2482 2 Original from partition p0
2483 3 Original from partition p0
2484 4 Original from partition p0
2485 DROP TABLE t1;
2486 CREATE TABLE t1 (a INT, b VARCHAR(64))
2487 ENGINE = 'InnoDB'
2488 PARTITION BY LIST (a)
2489 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2490 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2491 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2492 # d,fail_change_partition_2: BEFORE failure (under LOCK TABLE)
2493 db.opt
2494 t1#P#p0.ibd
2495 t1#P#p10.ibd
2496 t1.frm
2497 t1.par
2498 SHOW CREATE TABLE t1;
2499 Table Create Table
2500 t1 CREATE TABLE `t1` (
2501 `a` int(11) DEFAULT NULL,
2502 `b` varchar(64) DEFAULT NULL
2503 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2504 PARTITION BY LIST (`a`)
2505 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2506 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2507 SELECT * FROM t1;
2508 a b
2509 1 Original from partition p0
2510 11 Original from partition p1
2511 12 Original from partition p1
2512 13 Original from partition p1
2513 14 Original from partition p1
2514 2 Original from partition p0
2515 3 Original from partition p0
2516 4 Original from partition p0
2517 LOCK TABLE t1 WRITE;
2518 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2519 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2520 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2521 ERROR HY000: Unknown error
2522 # d,fail_change_partition_2: AFTER failure (under LOCK TABLE)
2523 db.opt
2524 t1#P#p0.ibd
2525 t1#P#p10.ibd
2526 t1.frm
2527 t1.par
2528 SHOW CREATE TABLE t1;
2529 Table Create Table
2530 t1 CREATE TABLE `t1` (
2531 `a` int(11) DEFAULT NULL,
2532 `b` varchar(64) DEFAULT NULL
2533 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2534 PARTITION BY LIST (`a`)
2535 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2536 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2537 SELECT * FROM t1;
2538 a b
2539 1 Original from partition p0
2540 11 Original from partition p1
2541 12 Original from partition p1
2542 13 Original from partition p1
2543 14 Original from partition p1
2544 2 Original from partition p0
2545 3 Original from partition p0
2546 4 Original from partition p0
2547 UNLOCK TABLES;
2548 DROP TABLE t1;
2549 SET SESSION debug_dbug=@save_dbug;
2550 SET SESSION debug_dbug="+d,fail_change_partition_3";
2551 CREATE TABLE t1 (a INT, b VARCHAR(64))
2552 ENGINE = 'InnoDB'
2553 PARTITION BY LIST (a)
2554 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2555 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2556 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2557 # d,fail_change_partition_3: BEFORE failure
2558 db.opt
2559 t1#P#p0.ibd
2560 t1#P#p10.ibd
2561 t1.frm
2562 t1.par
2563 SHOW CREATE TABLE t1;
2564 Table Create Table
2565 t1 CREATE TABLE `t1` (
2566 `a` int(11) DEFAULT NULL,
2567 `b` varchar(64) DEFAULT NULL
2568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2569 PARTITION BY LIST (`a`)
2570 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2571 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2572 SELECT * FROM t1;
2573 a b
2574 1 Original from partition p0
2575 11 Original from partition p1
2576 12 Original from partition p1
2577 13 Original from partition p1
2578 14 Original from partition p1
2579 2 Original from partition p0
2580 3 Original from partition p0
2581 4 Original from partition p0
2582 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2583 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2584 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2585 ERROR HY000: Unknown error
2586 # d,fail_change_partition_3: AFTER failure
2587 db.opt
2588 t1#P#p0.ibd
2589 t1#P#p10.ibd
2590 t1.frm
2591 t1.par
2592 SHOW CREATE TABLE t1;
2593 Table Create Table
2594 t1 CREATE TABLE `t1` (
2595 `a` int(11) DEFAULT NULL,
2596 `b` varchar(64) DEFAULT NULL
2597 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2598 PARTITION BY LIST (`a`)
2599 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2600 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2601 SELECT * FROM t1;
2602 a b
2603 1 Original from partition p0
2604 11 Original from partition p1
2605 12 Original from partition p1
2606 13 Original from partition p1
2607 14 Original from partition p1
2608 2 Original from partition p0
2609 3 Original from partition p0
2610 4 Original from partition p0
2611 DROP TABLE t1;
2612 CREATE TABLE t1 (a INT, b VARCHAR(64))
2613 ENGINE = 'InnoDB'
2614 PARTITION BY LIST (a)
2615 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2616 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2617 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2618 # d,fail_change_partition_3: BEFORE failure (under LOCK TABLE)
2619 db.opt
2620 t1#P#p0.ibd
2621 t1#P#p10.ibd
2622 t1.frm
2623 t1.par
2624 SHOW CREATE TABLE t1;
2625 Table Create Table
2626 t1 CREATE TABLE `t1` (
2627 `a` int(11) DEFAULT NULL,
2628 `b` varchar(64) DEFAULT NULL
2629 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2630 PARTITION BY LIST (`a`)
2631 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2632 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2633 SELECT * FROM t1;
2634 a b
2635 1 Original from partition p0
2636 11 Original from partition p1
2637 12 Original from partition p1
2638 13 Original from partition p1
2639 14 Original from partition p1
2640 2 Original from partition p0
2641 3 Original from partition p0
2642 4 Original from partition p0
2643 LOCK TABLE t1 WRITE;
2644 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2645 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2646 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2647 ERROR HY000: Unknown error
2648 # d,fail_change_partition_3: AFTER failure (under LOCK TABLE)
2649 db.opt
2650 t1#P#p0.ibd
2651 t1#P#p10.ibd
2652 t1.frm
2653 t1.par
2654 SHOW CREATE TABLE t1;
2655 Table Create Table
2656 t1 CREATE TABLE `t1` (
2657 `a` int(11) DEFAULT NULL,
2658 `b` varchar(64) DEFAULT NULL
2659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2660 PARTITION BY LIST (`a`)
2661 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2662 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2663 SELECT * FROM t1;
2664 a b
2665 1 Original from partition p0
2666 11 Original from partition p1
2667 12 Original from partition p1
2668 13 Original from partition p1
2669 14 Original from partition p1
2670 2 Original from partition p0
2671 3 Original from partition p0
2672 4 Original from partition p0
2673 UNLOCK TABLES;
2674 DROP TABLE t1;
2675 SET SESSION debug_dbug=@save_dbug;
2676 SET SESSION debug_dbug="+d,fail_change_partition_4";
2677 CREATE TABLE t1 (a INT, b VARCHAR(64))
2678 ENGINE = 'InnoDB'
2679 PARTITION BY LIST (a)
2680 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2681 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2682 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2683 # d,fail_change_partition_4: BEFORE failure
2684 db.opt
2685 t1#P#p0.ibd
2686 t1#P#p10.ibd
2687 t1.frm
2688 t1.par
2689 SHOW CREATE TABLE t1;
2690 Table Create Table
2691 t1 CREATE TABLE `t1` (
2692 `a` int(11) DEFAULT NULL,
2693 `b` varchar(64) DEFAULT NULL
2694 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2695 PARTITION BY LIST (`a`)
2696 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2697 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2698 SELECT * FROM t1;
2699 a b
2700 1 Original from partition p0
2701 11 Original from partition p1
2702 12 Original from partition p1
2703 13 Original from partition p1
2704 14 Original from partition p1
2705 2 Original from partition p0
2706 3 Original from partition p0
2707 4 Original from partition p0
2708 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2709 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2710 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2711 ERROR HY000: Unknown error
2712 # d,fail_change_partition_4: AFTER failure
2713 db.opt
2714 t1#P#p0.ibd
2715 t1#P#p10.ibd
2716 t1.frm
2717 t1.par
2718 SHOW CREATE TABLE t1;
2719 Table Create Table
2720 t1 CREATE TABLE `t1` (
2721 `a` int(11) DEFAULT NULL,
2722 `b` varchar(64) DEFAULT NULL
2723 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2724 PARTITION BY LIST (`a`)
2725 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2726 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2727 SELECT * FROM t1;
2728 a b
2729 1 Original from partition p0
2730 11 Original from partition p1
2731 12 Original from partition p1
2732 13 Original from partition p1
2733 14 Original from partition p1
2734 2 Original from partition p0
2735 3 Original from partition p0
2736 4 Original from partition p0
2737 DROP TABLE t1;
2738 CREATE TABLE t1 (a INT, b VARCHAR(64))
2739 ENGINE = 'InnoDB'
2740 PARTITION BY LIST (a)
2741 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2742 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2743 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2744 # d,fail_change_partition_4: BEFORE failure (under LOCK TABLE)
2745 db.opt
2746 t1#P#p0.ibd
2747 t1#P#p10.ibd
2748 t1.frm
2749 t1.par
2750 SHOW CREATE TABLE t1;
2751 Table Create Table
2752 t1 CREATE TABLE `t1` (
2753 `a` int(11) DEFAULT NULL,
2754 `b` varchar(64) DEFAULT NULL
2755 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2756 PARTITION BY LIST (`a`)
2757 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2758 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2759 SELECT * FROM t1;
2760 a b
2761 1 Original from partition p0
2762 11 Original from partition p1
2763 12 Original from partition p1
2764 13 Original from partition p1
2765 14 Original from partition p1
2766 2 Original from partition p0
2767 3 Original from partition p0
2768 4 Original from partition p0
2769 LOCK TABLE t1 WRITE;
2770 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2771 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2772 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2773 ERROR HY000: Unknown error
2774 # d,fail_change_partition_4: AFTER failure (under LOCK TABLE)
2775 db.opt
2776 t1#P#p0.ibd
2777 t1#P#p10.ibd
2778 t1.frm
2779 t1.par
2780 SHOW CREATE TABLE t1;
2781 Table Create Table
2782 t1 CREATE TABLE `t1` (
2783 `a` int(11) DEFAULT NULL,
2784 `b` varchar(64) DEFAULT NULL
2785 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2786 PARTITION BY LIST (`a`)
2787 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2788 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2789 SELECT * FROM t1;
2790 a b
2791 1 Original from partition p0
2792 11 Original from partition p1
2793 12 Original from partition p1
2794 13 Original from partition p1
2795 14 Original from partition p1
2796 2 Original from partition p0
2797 3 Original from partition p0
2798 4 Original from partition p0
2799 UNLOCK TABLES;
2800 DROP TABLE t1;
2801 SET SESSION debug_dbug=@save_dbug;
2802 SET SESSION debug_dbug="+d,fail_change_partition_5";
2803 CREATE TABLE t1 (a INT, b VARCHAR(64))
2804 ENGINE = 'InnoDB'
2805 PARTITION BY LIST (a)
2806 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2807 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2808 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2809 # d,fail_change_partition_5: BEFORE failure
2810 db.opt
2811 t1#P#p0.ibd
2812 t1#P#p10.ibd
2813 t1.frm
2814 t1.par
2815 SHOW CREATE TABLE t1;
2816 Table Create Table
2817 t1 CREATE TABLE `t1` (
2818 `a` int(11) DEFAULT NULL,
2819 `b` varchar(64) DEFAULT NULL
2820 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2821 PARTITION BY LIST (`a`)
2822 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2823 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2824 SELECT * FROM t1;
2825 a b
2826 1 Original from partition p0
2827 11 Original from partition p1
2828 12 Original from partition p1
2829 13 Original from partition p1
2830 14 Original from partition p1
2831 2 Original from partition p0
2832 3 Original from partition p0
2833 4 Original from partition p0
2834 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2835 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2836 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2837 ERROR HY000: Unknown error
2838 # d,fail_change_partition_5: AFTER failure
2839 db.opt
2840 t1#P#p0.ibd
2841 t1#P#p10.ibd
2842 t1.frm
2843 t1.par
2844 SHOW CREATE TABLE t1;
2845 Table Create Table
2846 t1 CREATE TABLE `t1` (
2847 `a` int(11) DEFAULT NULL,
2848 `b` varchar(64) DEFAULT NULL
2849 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2850 PARTITION BY LIST (`a`)
2851 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2852 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2853 SELECT * FROM t1;
2854 a b
2855 1 Original from partition p0
2856 11 Original from partition p1
2857 12 Original from partition p1
2858 13 Original from partition p1
2859 14 Original from partition p1
2860 2 Original from partition p0
2861 3 Original from partition p0
2862 4 Original from partition p0
2863 DROP TABLE t1;
2864 CREATE TABLE t1 (a INT, b VARCHAR(64))
2865 ENGINE = 'InnoDB'
2866 PARTITION BY LIST (a)
2867 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2868 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2869 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2870 # d,fail_change_partition_5: BEFORE failure (under LOCK TABLE)
2871 db.opt
2872 t1#P#p0.ibd
2873 t1#P#p10.ibd
2874 t1.frm
2875 t1.par
2876 SHOW CREATE TABLE t1;
2877 Table Create Table
2878 t1 CREATE TABLE `t1` (
2879 `a` int(11) DEFAULT NULL,
2880 `b` varchar(64) DEFAULT NULL
2881 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2882 PARTITION BY LIST (`a`)
2883 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2884 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2885 SELECT * FROM t1;
2886 a b
2887 1 Original from partition p0
2888 11 Original from partition p1
2889 12 Original from partition p1
2890 13 Original from partition p1
2891 14 Original from partition p1
2892 2 Original from partition p0
2893 3 Original from partition p0
2894 4 Original from partition p0
2895 LOCK TABLE t1 WRITE;
2896 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2897 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2898 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2899 ERROR HY000: Unknown error
2900 # d,fail_change_partition_5: AFTER failure (under LOCK TABLE)
2901 db.opt
2902 t1#P#p0.ibd
2903 t1#P#p10.ibd
2904 t1.frm
2905 t1.par
2906 SHOW CREATE TABLE t1;
2907 Table Create Table
2908 t1 CREATE TABLE `t1` (
2909 `a` int(11) DEFAULT NULL,
2910 `b` varchar(64) DEFAULT NULL
2911 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2912 PARTITION BY LIST (`a`)
2913 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2914 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2915 SELECT * FROM t1;
2916 a b
2917 1 Original from partition p0
2918 11 Original from partition p1
2919 12 Original from partition p1
2920 13 Original from partition p1
2921 14 Original from partition p1
2922 2 Original from partition p0
2923 3 Original from partition p0
2924 4 Original from partition p0
2925 UNLOCK TABLES;
2926 DROP TABLE t1;
2927 SET SESSION debug_dbug=@save_dbug;
2928 SET SESSION debug_dbug="+d,fail_change_partition_6";
2929 CREATE TABLE t1 (a INT, b VARCHAR(64))
2930 ENGINE = 'InnoDB'
2931 PARTITION BY LIST (a)
2932 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2933 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2934 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2935 # d,fail_change_partition_6: BEFORE failure
2936 db.opt
2937 t1#P#p0.ibd
2938 t1#P#p10.ibd
2939 t1.frm
2940 t1.par
2941 SHOW CREATE TABLE t1;
2942 Table Create Table
2943 t1 CREATE TABLE `t1` (
2944 `a` int(11) DEFAULT NULL,
2945 `b` varchar(64) DEFAULT NULL
2946 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2947 PARTITION BY LIST (`a`)
2948 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2949 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2950 SELECT * FROM t1;
2951 a b
2952 1 Original from partition p0
2953 11 Original from partition p1
2954 12 Original from partition p1
2955 13 Original from partition p1
2956 14 Original from partition p1
2957 2 Original from partition p0
2958 3 Original from partition p0
2959 4 Original from partition p0
2960 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
2961 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
2962 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
2963 ERROR HY000: Unknown error
2964 # d,fail_change_partition_6: AFTER failure
2965 db.opt
2966 t1#P#p0.ibd
2967 t1#P#p10.ibd
2968 t1.frm
2969 t1.par
2970 SHOW CREATE TABLE t1;
2971 Table Create Table
2972 t1 CREATE TABLE `t1` (
2973 `a` int(11) DEFAULT NULL,
2974 `b` varchar(64) DEFAULT NULL
2975 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2976 PARTITION BY LIST (`a`)
2977 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
2978 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
2979 SELECT * FROM t1;
2980 a b
2981 1 Original from partition p0
2982 11 Original from partition p1
2983 12 Original from partition p1
2984 13 Original from partition p1
2985 14 Original from partition p1
2986 2 Original from partition p0
2987 3 Original from partition p0
2988 4 Original from partition p0
2989 DROP TABLE t1;
2990 CREATE TABLE t1 (a INT, b VARCHAR(64))
2991 ENGINE = 'InnoDB'
2992 PARTITION BY LIST (a)
2993 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
2994 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
2995 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
2996 # d,fail_change_partition_6: BEFORE failure (under LOCK TABLE)
2997 db.opt
2998 t1#P#p0.ibd
2999 t1#P#p10.ibd
3000 t1.frm
3001 t1.par
3002 SHOW CREATE TABLE t1;
3003 Table Create Table
3004 t1 CREATE TABLE `t1` (
3005 `a` int(11) DEFAULT NULL,
3006 `b` varchar(64) DEFAULT NULL
3007 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3008 PARTITION BY LIST (`a`)
3009 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3010 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3011 SELECT * FROM t1;
3012 a b
3013 1 Original from partition p0
3014 11 Original from partition p1
3015 12 Original from partition p1
3016 13 Original from partition p1
3017 14 Original from partition p1
3018 2 Original from partition p0
3019 3 Original from partition p0
3020 4 Original from partition p0
3021 LOCK TABLE t1 WRITE;
3022 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3023 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3024 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3025 ERROR HY000: Unknown error
3026 # d,fail_change_partition_6: AFTER failure (under LOCK TABLE)
3027 db.opt
3028 t1#P#p0.ibd
3029 t1#P#p10.ibd
3030 t1.frm
3031 t1.par
3032 SHOW CREATE TABLE t1;
3033 Table Create Table
3034 t1 CREATE TABLE `t1` (
3035 `a` int(11) DEFAULT NULL,
3036 `b` varchar(64) DEFAULT NULL
3037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3038 PARTITION BY LIST (`a`)
3039 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3040 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3041 SELECT * FROM t1;
3042 a b
3043 1 Original from partition p0
3044 11 Original from partition p1
3045 12 Original from partition p1
3046 13 Original from partition p1
3047 14 Original from partition p1
3048 2 Original from partition p0
3049 3 Original from partition p0
3050 4 Original from partition p0
3051 UNLOCK TABLES;
3052 DROP TABLE t1;
3053 SET SESSION debug_dbug=@save_dbug;
3054 SET SESSION debug_dbug="+d,fail_change_partition_7";
3055 CREATE TABLE t1 (a INT, b VARCHAR(64))
3056 ENGINE = 'InnoDB'
3057 PARTITION BY LIST (a)
3058 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3059 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3060 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3061 # d,fail_change_partition_7: BEFORE failure
3062 db.opt
3063 t1#P#p0.ibd
3064 t1#P#p10.ibd
3065 t1.frm
3066 t1.par
3067 SHOW CREATE TABLE t1;
3068 Table Create Table
3069 t1 CREATE TABLE `t1` (
3070 `a` int(11) DEFAULT NULL,
3071 `b` varchar(64) DEFAULT NULL
3072 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3073 PARTITION BY LIST (`a`)
3074 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3075 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3076 SELECT * FROM t1;
3077 a b
3078 1 Original from partition p0
3079 11 Original from partition p1
3080 12 Original from partition p1
3081 13 Original from partition p1
3082 14 Original from partition p1
3083 2 Original from partition p0
3084 3 Original from partition p0
3085 4 Original from partition p0
3086 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3087 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3088 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3089 ERROR HY000: Unknown error
3090 # d,fail_change_partition_7: AFTER failure
3091 db.opt
3092 t1#P#p0.ibd
3093 t1#P#p10.ibd
3094 t1#P#p20.ibd
3095 t1.frm
3096 t1.par
3097 SHOW CREATE TABLE t1;
3098 Table Create Table
3099 t1 CREATE TABLE `t1` (
3100 `a` int(11) DEFAULT NULL,
3101 `b` varchar(64) DEFAULT NULL
3102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3103 PARTITION BY LIST (`a`)
3104 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3105 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3106 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3107 SELECT * FROM t1;
3108 a b
3109 1 Original from partition p0
3110 11 Original from partition p1
3111 12 Original from partition p1
3112 13 Original from partition p1
3113 14 Original from partition p1
3114 2 Original from partition p0
3115 3 Original from partition p0
3116 4 Original from partition p0
3117 DROP TABLE t1;
3118 CREATE TABLE t1 (a INT, b VARCHAR(64))
3119 ENGINE = 'InnoDB'
3120 PARTITION BY LIST (a)
3121 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3122 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3123 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3124 # d,fail_change_partition_7: BEFORE failure (under LOCK TABLE)
3125 db.opt
3126 t1#P#p0.ibd
3127 t1#P#p10.ibd
3128 t1.frm
3129 t1.par
3130 SHOW CREATE TABLE t1;
3131 Table Create Table
3132 t1 CREATE TABLE `t1` (
3133 `a` int(11) DEFAULT NULL,
3134 `b` varchar(64) DEFAULT NULL
3135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3136 PARTITION BY LIST (`a`)
3137 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3138 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3139 SELECT * FROM t1;
3140 a b
3141 1 Original from partition p0
3142 11 Original from partition p1
3143 12 Original from partition p1
3144 13 Original from partition p1
3145 14 Original from partition p1
3146 2 Original from partition p0
3147 3 Original from partition p0
3148 4 Original from partition p0
3149 LOCK TABLE t1 WRITE;
3150 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3151 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3152 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3153 ERROR HY000: Unknown error
3154 # d,fail_change_partition_7: AFTER failure (under LOCK TABLE)
3155 db.opt
3156 t1#P#p0.ibd
3157 t1#P#p10.ibd
3158 t1#P#p20.ibd
3159 t1.frm
3160 t1.par
3161 SHOW CREATE TABLE t1;
3162 Table Create Table
3163 t1 CREATE TABLE `t1` (
3164 `a` int(11) DEFAULT NULL,
3165 `b` varchar(64) DEFAULT NULL
3166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3167 PARTITION BY LIST (`a`)
3168 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3169 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3170 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3171 SELECT * FROM t1;
3172 a b
3173 1 Original from partition p0
3174 11 Original from partition p1
3175 12 Original from partition p1
3176 13 Original from partition p1
3177 14 Original from partition p1
3178 2 Original from partition p0
3179 3 Original from partition p0
3180 4 Original from partition p0
3181 UNLOCK TABLES;
3182 DROP TABLE t1;
3183 SET SESSION debug_dbug=@save_dbug;
3184 SET SESSION debug_dbug="+d,fail_change_partition_8";
3185 CREATE TABLE t1 (a INT, b VARCHAR(64))
3186 ENGINE = 'InnoDB'
3187 PARTITION BY LIST (a)
3188 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3189 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3190 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3191 # d,fail_change_partition_8: BEFORE failure
3192 db.opt
3193 t1#P#p0.ibd
3194 t1#P#p10.ibd
3195 t1.frm
3196 t1.par
3197 SHOW CREATE TABLE t1;
3198 Table Create Table
3199 t1 CREATE TABLE `t1` (
3200 `a` int(11) DEFAULT NULL,
3201 `b` varchar(64) DEFAULT NULL
3202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3203 PARTITION BY LIST (`a`)
3204 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3205 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3206 SELECT * FROM t1;
3207 a b
3208 1 Original from partition p0
3209 11 Original from partition p1
3210 12 Original from partition p1
3211 13 Original from partition p1
3212 14 Original from partition p1
3213 2 Original from partition p0
3214 3 Original from partition p0
3215 4 Original from partition p0
3216 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3217 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3218 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3219 ERROR HY000: Unknown error
3220 # d,fail_change_partition_8: AFTER failure
3221 db.opt
3222 t1#P#p0.ibd
3223 t1#P#p10.ibd
3224 t1#P#p20.ibd
3225 t1.frm
3226 t1.par
3227 SHOW CREATE TABLE t1;
3228 Table Create Table
3229 t1 CREATE TABLE `t1` (
3230 `a` int(11) DEFAULT NULL,
3231 `b` varchar(64) DEFAULT NULL
3232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3233 PARTITION BY LIST (`a`)
3234 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3235 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3236 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3237 SELECT * FROM t1;
3238 a b
3239 1 Original from partition p0
3240 11 Original from partition p1
3241 12 Original from partition p1
3242 13 Original from partition p1
3243 14 Original from partition p1
3244 2 Original from partition p0
3245 3 Original from partition p0
3246 4 Original from partition p0
3247 DROP TABLE t1;
3248 CREATE TABLE t1 (a INT, b VARCHAR(64))
3249 ENGINE = 'InnoDB'
3250 PARTITION BY LIST (a)
3251 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3252 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3253 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3254 # d,fail_change_partition_8: BEFORE failure (under LOCK TABLE)
3255 db.opt
3256 t1#P#p0.ibd
3257 t1#P#p10.ibd
3258 t1.frm
3259 t1.par
3260 SHOW CREATE TABLE t1;
3261 Table Create Table
3262 t1 CREATE TABLE `t1` (
3263 `a` int(11) DEFAULT NULL,
3264 `b` varchar(64) DEFAULT NULL
3265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3266 PARTITION BY LIST (`a`)
3267 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3268 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3269 SELECT * FROM t1;
3270 a b
3271 1 Original from partition p0
3272 11 Original from partition p1
3273 12 Original from partition p1
3274 13 Original from partition p1
3275 14 Original from partition p1
3276 2 Original from partition p0
3277 3 Original from partition p0
3278 4 Original from partition p0
3279 LOCK TABLE t1 WRITE;
3280 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3281 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3282 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3283 ERROR HY000: Unknown error
3284 # d,fail_change_partition_8: AFTER failure (under LOCK TABLE)
3285 db.opt
3286 t1#P#p0.ibd
3287 t1#P#p10.ibd
3288 t1#P#p20.ibd
3289 t1.frm
3290 t1.par
3291 SHOW CREATE TABLE t1;
3292 Table Create Table
3293 t1 CREATE TABLE `t1` (
3294 `a` int(11) DEFAULT NULL,
3295 `b` varchar(64) DEFAULT NULL
3296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3297 PARTITION BY LIST (`a`)
3298 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3299 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3300 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3301 SELECT * FROM t1;
3302 a b
3303 1 Original from partition p0
3304 11 Original from partition p1
3305 12 Original from partition p1
3306 13 Original from partition p1
3307 14 Original from partition p1
3308 2 Original from partition p0
3309 3 Original from partition p0
3310 4 Original from partition p0
3311 UNLOCK TABLES;
3312 DROP TABLE t1;
3313 SET SESSION debug_dbug=@save_dbug;
3314 SET SESSION debug_dbug="+d,fail_change_partition_9";
3315 CREATE TABLE t1 (a INT, b VARCHAR(64))
3316 ENGINE = 'InnoDB'
3317 PARTITION BY LIST (a)
3318 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3319 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3320 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3321 # d,fail_change_partition_9: BEFORE failure
3322 db.opt
3323 t1#P#p0.ibd
3324 t1#P#p10.ibd
3325 t1.frm
3326 t1.par
3327 SHOW CREATE TABLE t1;
3328 Table Create Table
3329 t1 CREATE TABLE `t1` (
3330 `a` int(11) DEFAULT NULL,
3331 `b` varchar(64) DEFAULT NULL
3332 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3333 PARTITION BY LIST (`a`)
3334 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3335 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3336 SELECT * FROM t1;
3337 a b
3338 1 Original from partition p0
3339 11 Original from partition p1
3340 12 Original from partition p1
3341 13 Original from partition p1
3342 14 Original from partition p1
3343 2 Original from partition p0
3344 3 Original from partition p0
3345 4 Original from partition p0
3346 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3347 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3348 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3349 ERROR HY000: Unknown error
3350 # d,fail_change_partition_9: AFTER failure
3351 db.opt
3352 t1#P#p0.ibd
3353 t1#P#p10.ibd
3354 t1#P#p20.ibd
3355 t1.frm
3356 t1.par
3357 SHOW CREATE TABLE t1;
3358 Table Create Table
3359 t1 CREATE TABLE `t1` (
3360 `a` int(11) DEFAULT NULL,
3361 `b` varchar(64) DEFAULT NULL
3362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3363 PARTITION BY LIST (`a`)
3364 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3365 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3366 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3367 SELECT * FROM t1;
3368 a b
3369 1 Original from partition p0
3370 11 Original from partition p1
3371 12 Original from partition p1
3372 13 Original from partition p1
3373 14 Original from partition p1
3374 2 Original from partition p0
3375 3 Original from partition p0
3376 4 Original from partition p0
3377 DROP TABLE t1;
3378 CREATE TABLE t1 (a INT, b VARCHAR(64))
3379 ENGINE = 'InnoDB'
3380 PARTITION BY LIST (a)
3381 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3382 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3383 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3384 # d,fail_change_partition_9: BEFORE failure (under LOCK TABLE)
3385 db.opt
3386 t1#P#p0.ibd
3387 t1#P#p10.ibd
3388 t1.frm
3389 t1.par
3390 SHOW CREATE TABLE t1;
3391 Table Create Table
3392 t1 CREATE TABLE `t1` (
3393 `a` int(11) DEFAULT NULL,
3394 `b` varchar(64) DEFAULT NULL
3395 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3396 PARTITION BY LIST (`a`)
3397 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3398 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3399 SELECT * FROM t1;
3400 a b
3401 1 Original from partition p0
3402 11 Original from partition p1
3403 12 Original from partition p1
3404 13 Original from partition p1
3405 14 Original from partition p1
3406 2 Original from partition p0
3407 3 Original from partition p0
3408 4 Original from partition p0
3409 LOCK TABLE t1 WRITE;
3410 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3411 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3412 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3413 ERROR HY000: Unknown error
3414 # d,fail_change_partition_9: AFTER failure (under LOCK TABLE)
3415 db.opt
3416 t1#P#p0.ibd
3417 t1#P#p10.ibd
3418 t1#P#p20.ibd
3419 t1.frm
3420 t1.par
3421 SHOW CREATE TABLE t1;
3422 Table Create Table
3423 t1 CREATE TABLE `t1` (
3424 `a` int(11) DEFAULT NULL,
3425 `b` varchar(64) DEFAULT NULL
3426 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3427 PARTITION BY LIST (`a`)
3428 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3429 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3430 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3431 SELECT * FROM t1;
3432 a b
3433 1 Original from partition p0
3434 11 Original from partition p1
3435 12 Original from partition p1
3436 13 Original from partition p1
3437 14 Original from partition p1
3438 2 Original from partition p0
3439 3 Original from partition p0
3440 4 Original from partition p0
3441 UNLOCK TABLES;
3442 DROP TABLE t1;
3443 SET SESSION debug_dbug=@save_dbug;
3444 SET SESSION debug_dbug="+d,fail_change_partition_10";
3445 CREATE TABLE t1 (a INT, b VARCHAR(64))
3446 ENGINE = 'InnoDB'
3447 PARTITION BY LIST (a)
3448 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3449 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3450 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3451 # d,fail_change_partition_10: BEFORE failure
3452 db.opt
3453 t1#P#p0.ibd
3454 t1#P#p10.ibd
3455 t1.frm
3456 t1.par
3457 SHOW CREATE TABLE t1;
3458 Table Create Table
3459 t1 CREATE TABLE `t1` (
3460 `a` int(11) DEFAULT NULL,
3461 `b` varchar(64) DEFAULT NULL
3462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3463 PARTITION BY LIST (`a`)
3464 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3465 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3466 SELECT * FROM t1;
3467 a b
3468 1 Original from partition p0
3469 11 Original from partition p1
3470 12 Original from partition p1
3471 13 Original from partition p1
3472 14 Original from partition p1
3473 2 Original from partition p0
3474 3 Original from partition p0
3475 4 Original from partition p0
3476 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3477 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3478 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3479 ERROR HY000: Unknown error
3480 # d,fail_change_partition_10: AFTER failure
3481 db.opt
3482 t1#P#p0.ibd
3483 t1#P#p10.ibd
3484 t1#P#p20.ibd
3485 t1.frm
3486 t1.par
3487 SHOW CREATE TABLE t1;
3488 Table Create Table
3489 t1 CREATE TABLE `t1` (
3490 `a` int(11) DEFAULT NULL,
3491 `b` varchar(64) DEFAULT NULL
3492 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3493 PARTITION BY LIST (`a`)
3494 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3495 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3496 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3497 SELECT * FROM t1;
3498 a b
3499 1 Original from partition p0
3500 11 Original from partition p1
3501 12 Original from partition p1
3502 13 Original from partition p1
3503 14 Original from partition p1
3504 2 Original from partition p0
3505 3 Original from partition p0
3506 4 Original from partition p0
3507 DROP TABLE t1;
3508 CREATE TABLE t1 (a INT, b VARCHAR(64))
3509 ENGINE = 'InnoDB'
3510 PARTITION BY LIST (a)
3511 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3512 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3513 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3514 # d,fail_change_partition_10: BEFORE failure (under LOCK TABLE)
3515 db.opt
3516 t1#P#p0.ibd
3517 t1#P#p10.ibd
3518 t1.frm
3519 t1.par
3520 SHOW CREATE TABLE t1;
3521 Table Create Table
3522 t1 CREATE TABLE `t1` (
3523 `a` int(11) DEFAULT NULL,
3524 `b` varchar(64) DEFAULT NULL
3525 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3526 PARTITION BY LIST (`a`)
3527 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3528 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3529 SELECT * FROM t1;
3530 a b
3531 1 Original from partition p0
3532 11 Original from partition p1
3533 12 Original from partition p1
3534 13 Original from partition p1
3535 14 Original from partition p1
3536 2 Original from partition p0
3537 3 Original from partition p0
3538 4 Original from partition p0
3539 LOCK TABLE t1 WRITE;
3540 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3541 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3542 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3543 ERROR HY000: Unknown error
3544 # d,fail_change_partition_10: AFTER failure (under LOCK TABLE)
3545 db.opt
3546 t1#P#p0.ibd
3547 t1#P#p10.ibd
3548 t1#P#p20.ibd
3549 t1.frm
3550 t1.par
3551 SHOW CREATE TABLE t1;
3552 Table Create Table
3553 t1 CREATE TABLE `t1` (
3554 `a` int(11) DEFAULT NULL,
3555 `b` varchar(64) DEFAULT NULL
3556 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3557 PARTITION BY LIST (`a`)
3558 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3559 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3560 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3561 SELECT * FROM t1;
3562 a b
3563 1 Original from partition p0
3564 11 Original from partition p1
3565 12 Original from partition p1
3566 13 Original from partition p1
3567 14 Original from partition p1
3568 2 Original from partition p0
3569 3 Original from partition p0
3570 4 Original from partition p0
3571 UNLOCK TABLES;
3572 DROP TABLE t1;
3573 SET SESSION debug_dbug=@save_dbug;
3574 SET SESSION debug_dbug="+d,fail_change_partition_11";
3575 CREATE TABLE t1 (a INT, b VARCHAR(64))
3576 ENGINE = 'InnoDB'
3577 PARTITION BY LIST (a)
3578 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3579 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3580 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3581 # d,fail_change_partition_11: BEFORE failure
3582 db.opt
3583 t1#P#p0.ibd
3584 t1#P#p10.ibd
3585 t1.frm
3586 t1.par
3587 SHOW CREATE TABLE t1;
3588 Table Create Table
3589 t1 CREATE TABLE `t1` (
3590 `a` int(11) DEFAULT NULL,
3591 `b` varchar(64) DEFAULT NULL
3592 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3593 PARTITION BY LIST (`a`)
3594 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3595 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3596 SELECT * FROM t1;
3597 a b
3598 1 Original from partition p0
3599 11 Original from partition p1
3600 12 Original from partition p1
3601 13 Original from partition p1
3602 14 Original from partition p1
3603 2 Original from partition p0
3604 3 Original from partition p0
3605 4 Original from partition p0
3606 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3607 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3608 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3609 ERROR HY000: Unknown error
3610 # d,fail_change_partition_11: AFTER failure
3611 db.opt
3612 t1#P#p0.ibd
3613 t1#P#p10.ibd
3614 t1#P#p20.ibd
3615 t1.frm
3616 t1.par
3617 SHOW CREATE TABLE t1;
3618 Table Create Table
3619 t1 CREATE TABLE `t1` (
3620 `a` int(11) DEFAULT NULL,
3621 `b` varchar(64) DEFAULT NULL
3622 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3623 PARTITION BY LIST (`a`)
3624 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3625 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3626 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3627 SELECT * FROM t1;
3628 a b
3629 1 Original from partition p0
3630 11 Original from partition p1
3631 12 Original from partition p1
3632 13 Original from partition p1
3633 14 Original from partition p1
3634 2 Original from partition p0
3635 3 Original from partition p0
3636 4 Original from partition p0
3637 DROP TABLE t1;
3638 CREATE TABLE t1 (a INT, b VARCHAR(64))
3639 ENGINE = 'InnoDB'
3640 PARTITION BY LIST (a)
3641 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3642 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3643 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3644 # d,fail_change_partition_11: BEFORE failure (under LOCK TABLE)
3645 db.opt
3646 t1#P#p0.ibd
3647 t1#P#p10.ibd
3648 t1.frm
3649 t1.par
3650 SHOW CREATE TABLE t1;
3651 Table Create Table
3652 t1 CREATE TABLE `t1` (
3653 `a` int(11) DEFAULT NULL,
3654 `b` varchar(64) DEFAULT NULL
3655 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3656 PARTITION BY LIST (`a`)
3657 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3658 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3659 SELECT * FROM t1;
3660 a b
3661 1 Original from partition p0
3662 11 Original from partition p1
3663 12 Original from partition p1
3664 13 Original from partition p1
3665 14 Original from partition p1
3666 2 Original from partition p0
3667 3 Original from partition p0
3668 4 Original from partition p0
3669 LOCK TABLE t1 WRITE;
3670 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3671 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3672 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3673 ERROR HY000: Unknown error
3674 # d,fail_change_partition_11: AFTER failure (under LOCK TABLE)
3675 db.opt
3676 t1#P#p0.ibd
3677 t1#P#p10.ibd
3678 t1#P#p20.ibd
3679 t1.frm
3680 t1.par
3681 SHOW CREATE TABLE t1;
3682 Table Create Table
3683 t1 CREATE TABLE `t1` (
3684 `a` int(11) DEFAULT NULL,
3685 `b` varchar(64) DEFAULT NULL
3686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3687 PARTITION BY LIST (`a`)
3688 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3689 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3690 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3691 SELECT * FROM t1;
3692 a b
3693 1 Original from partition p0
3694 11 Original from partition p1
3695 12 Original from partition p1
3696 13 Original from partition p1
3697 14 Original from partition p1
3698 2 Original from partition p0
3699 3 Original from partition p0
3700 4 Original from partition p0
3701 UNLOCK TABLES;
3702 DROP TABLE t1;
3703 SET SESSION debug_dbug=@save_dbug;
3704 SET SESSION debug_dbug="+d,fail_change_partition_12";
3705 CREATE TABLE t1 (a INT, b VARCHAR(64))
3706 ENGINE = 'InnoDB'
3707 PARTITION BY LIST (a)
3708 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3709 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3710 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3711 # d,fail_change_partition_12: BEFORE failure
3712 db.opt
3713 t1#P#p0.ibd
3714 t1#P#p10.ibd
3715 t1.frm
3716 t1.par
3717 SHOW CREATE TABLE t1;
3718 Table Create Table
3719 t1 CREATE TABLE `t1` (
3720 `a` int(11) DEFAULT NULL,
3721 `b` varchar(64) DEFAULT NULL
3722 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3723 PARTITION BY LIST (`a`)
3724 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3725 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3726 SELECT * FROM t1;
3727 a b
3728 1 Original from partition p0
3729 11 Original from partition p1
3730 12 Original from partition p1
3731 13 Original from partition p1
3732 14 Original from partition p1
3733 2 Original from partition p0
3734 3 Original from partition p0
3735 4 Original from partition p0
3736 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3737 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3738 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3739 ERROR HY000: Unknown error
3740 # d,fail_change_partition_12: AFTER failure
3741 db.opt
3742 t1#P#p0.ibd
3743 t1#P#p10.ibd
3744 t1#P#p20.ibd
3745 t1.frm
3746 t1.par
3747 SHOW CREATE TABLE t1;
3748 Table Create Table
3749 t1 CREATE TABLE `t1` (
3750 `a` int(11) DEFAULT NULL,
3751 `b` varchar(64) DEFAULT NULL
3752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3753 PARTITION BY LIST (`a`)
3754 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3755 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3756 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3757 SELECT * FROM t1;
3758 a b
3759 1 Original from partition p0
3760 11 Original from partition p1
3761 12 Original from partition p1
3762 13 Original from partition p1
3763 14 Original from partition p1
3764 2 Original from partition p0
3765 3 Original from partition p0
3766 4 Original from partition p0
3767 DROP TABLE t1;
3768 CREATE TABLE t1 (a INT, b VARCHAR(64))
3769 ENGINE = 'InnoDB'
3770 PARTITION BY LIST (a)
3771 (PARTITION p0 VALUES IN (0,1,2,3,4,5,6,7,8,9),
3772 PARTITION p10 VALUES IN (11,12,13,14,15,16,17,18,19));
3773 INSERT INTO t1 VALUES (1, "Original from partition p0"), (2, "Original from partition p0"), (3, "Original from partition p0"), (4, "Original from partition p0"), (11, "Original from partition p1"), (12, "Original from partition p1"), (13, "Original from partition p1"), (14, "Original from partition p1");
3774 # d,fail_change_partition_12: BEFORE failure (under LOCK TABLE)
3775 db.opt
3776 t1#P#p0.ibd
3777 t1#P#p10.ibd
3778 t1.frm
3779 t1.par
3780 SHOW CREATE TABLE t1;
3781 Table Create Table
3782 t1 CREATE TABLE `t1` (
3783 `a` int(11) DEFAULT NULL,
3784 `b` varchar(64) DEFAULT NULL
3785 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3786 PARTITION BY LIST (`a`)
3787 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3788 PARTITION `p10` VALUES IN (11,12,13,14,15,16,17,18,19) ENGINE = InnoDB)
3789 SELECT * FROM t1;
3790 a b
3791 1 Original from partition p0
3792 11 Original from partition p1
3793 12 Original from partition p1
3794 13 Original from partition p1
3795 14 Original from partition p1
3796 2 Original from partition p0
3797 3 Original from partition p0
3798 4 Original from partition p0
3799 LOCK TABLE t1 WRITE;
3800 ALTER TABLE t1 REORGANIZE PARTITION p10 INTO
3801 (PARTITION p10 VALUES IN (10,11,12,13,14,15,16,17,18,19),
3802 PARTITION p20 VALUES IN (20,21,22,23,24,25,26,27,28,29));
3803 ERROR HY000: Unknown error
3804 # d,fail_change_partition_12: AFTER failure (under LOCK TABLE)
3805 db.opt
3806 t1#P#p0.ibd
3807 t1#P#p10.ibd
3808 t1#P#p20.ibd
3809 t1.frm
3810 t1.par
3811 SHOW CREATE TABLE t1;
3812 Table Create Table
3813 t1 CREATE TABLE `t1` (
3814 `a` int(11) DEFAULT NULL,
3815 `b` varchar(64) DEFAULT NULL
3816 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3817 PARTITION BY LIST (`a`)
3818 (PARTITION `p0` VALUES IN (0,1,2,3,4,5,6,7,8,9) ENGINE = InnoDB,
3819 PARTITION `p10` VALUES IN (10,11,12,13,14,15,16,17,18,19) ENGINE = InnoDB,
3820 PARTITION `p20` VALUES IN (20,21,22,23,24,25,26,27,28,29) ENGINE = InnoDB)
3821 SELECT * FROM t1;
3822 a b
3823 1 Original from partition p0
3824 11 Original from partition p1
3825 12 Original from partition p1
3826 13 Original from partition p1
3827 14 Original from partition p1
3828 2 Original from partition p0
3829 3 Original from partition p0
3830 4 Original from partition p0
3831 UNLOCK TABLES;
3832 DROP TABLE t1;
3833 SET SESSION debug_dbug=@save_dbug;