Debian Codegraph @

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

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