Debian Codegraph @

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

raw
1 FLUSH TABLES;
2 #
3 # Bug#13737949: CRASH IN HA_PARTITION::INDEX_INIT
4 # Bug#18694052: SERVER CRASH IN HA_PARTITION::INIT_RECORD_PRIORITY_QUEUE
5 #
6 CREATE TABLE t1 (a INT, b VARCHAR(64), KEY(b,a))
7 PARTITION BY HASH (a) PARTITIONS 3;
8 INSERT INTO t1 VALUES (1, "1"), (2, "2"), (3, "3"), (4, "Four"), (5, "Five"),
9 (6, "Six"), (7, "Seven"), (8, "Eight"), (9, "Nine");
10 SET @saved_dbug=@@debug_dbug;
11 SET SESSION debug_dbug="+d,ha_partition_fail_index_init";
12 SELECT * FROM t1 WHERE b = "Seven";
13 ERROR HY000: Table has no partition for value 0
14 SET SESSION debug_dbug=@saved_dbug;
15 SELECT * FROM t1 WHERE b = "Seven";
16 a b
17 7 Seven
18 DROP TABLE t1;
19 #
20 # WL#4445: EXCHANGE PARTITION WITH TABLE
21 # Verify ddl_log in case of crashing.
22 call mtr.add_suppression("Attempting backtrace. You can use the following information to find out");
23 call mtr.add_suppression('InnoDB: The log sequence numbers [0-9]+ and [0-9]+ in ibdata files do not match the log sequence number [0-9]+ in the ib_logfiles!');
24 SET @save_dbug=@@debug_dbug;
25 SET SESSION debug_dbug="+d,exchange_partition_abort_1";
26 CREATE TABLE t2 (a INT, b VARCHAR(64));
27 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
28 SHOW CREATE TABLE t2;
29 Table Create Table
30 t2 CREATE TABLE `t2` (
31 `a` int(11) DEFAULT NULL,
32 `b` varchar(64) DEFAULT NULL
33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
34 SELECT * FROM t2;
35 a b
36 5 Original from table t2
37 6 Original from table t2
38 7 Original from table t2
39 8 Original from table t2
40 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
41 (PARTITION p0 VALUES LESS THAN (10),
42 PARTITION p1 VALUES LESS THAN MAXVALUE);
43 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
44 # State before crash
45 db.opt
46 t1#P#p0.MYD
47 t1#P#p0.MYI
48 t1#P#p1.MYD
49 t1#P#p1.MYI
50 t1.frm
51 t1.par
52 t2.MYD
53 t2.MYI
54 t2.frm
55 SHOW CREATE TABLE t1;
56 Table Create Table
57 t1 CREATE TABLE `t1` (
58 `a` int(11) DEFAULT NULL,
59 `b` varchar(64) DEFAULT NULL
60 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
61 PARTITION BY RANGE (`a`)
62 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
63 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
64 SELECT * FROM t1;
65 a b
66 1 Original from partition p0
67 11 Original from partition p1
68 12 Original from partition p1
69 13 Original from partition p1
70 14 Original from partition p1
71 2 Original from partition p0
72 21 Original from partition p1
73 22 Original from partition p1
74 23 Original from partition p1
75 24 Original from partition p1
76 3 Original from partition p0
77 4 Original from partition p0
78 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
79 ERROR HY000: Lost connection to server during query
80 # State after crash (before recovery)
81 db.opt
82 t1#P#p0.MYD
83 t1#P#p0.MYI
84 t1#P#p1.MYD
85 t1#P#p1.MYI
86 t1.frm
87 t1.par
88 t2.MYD
89 t2.MYI
90 t2.frm
91 # State after crash recovery
92 db.opt
93 t1#P#p0.MYD
94 t1#P#p0.MYI
95 t1#P#p1.MYD
96 t1#P#p1.MYI
97 t1.frm
98 t1.par
99 t2.MYD
100 t2.MYI
101 t2.frm
102 SHOW CREATE TABLE t1;
103 Table Create Table
104 t1 CREATE TABLE `t1` (
105 `a` int(11) DEFAULT NULL,
106 `b` varchar(64) DEFAULT NULL
107 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
108 PARTITION BY RANGE (`a`)
109 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
110 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
111 SELECT * FROM t1;
112 a b
113 1 Original from partition p0
114 11 Original from partition p1
115 12 Original from partition p1
116 13 Original from partition p1
117 14 Original from partition p1
118 2 Original from partition p0
119 21 Original from partition p1
120 22 Original from partition p1
121 23 Original from partition p1
122 24 Original from partition p1
123 3 Original from partition p0
124 4 Original from partition p0
125 DROP TABLE t1;
126 SHOW CREATE TABLE t2;
127 Table Create Table
128 t2 CREATE TABLE `t2` (
129 `a` int(11) DEFAULT NULL,
130 `b` varchar(64) DEFAULT NULL
131 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
132 SELECT * FROM t2;
133 a b
134 5 Original from table t2
135 6 Original from table t2
136 7 Original from table t2
137 8 Original from table t2
138 DROP TABLE t2;
139 SET SESSION debug_dbug=@save_dbug;
140 SET SESSION debug_dbug="+d,exchange_partition_abort_2";
141 CREATE TABLE t2 (a INT, b VARCHAR(64));
142 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
143 SHOW CREATE TABLE t2;
144 Table Create Table
145 t2 CREATE TABLE `t2` (
146 `a` int(11) DEFAULT NULL,
147 `b` varchar(64) DEFAULT NULL
148 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
149 SELECT * FROM t2;
150 a b
151 5 Original from table t2
152 6 Original from table t2
153 7 Original from table t2
154 8 Original from table t2
155 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
156 (PARTITION p0 VALUES LESS THAN (10),
157 PARTITION p1 VALUES LESS THAN MAXVALUE);
158 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
159 # State before crash
160 db.opt
161 t1#P#p0.MYD
162 t1#P#p0.MYI
163 t1#P#p1.MYD
164 t1#P#p1.MYI
165 t1.frm
166 t1.par
167 t2.MYD
168 t2.MYI
169 t2.frm
170 SHOW CREATE TABLE t1;
171 Table Create Table
172 t1 CREATE TABLE `t1` (
173 `a` int(11) DEFAULT NULL,
174 `b` varchar(64) DEFAULT NULL
175 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
176 PARTITION BY RANGE (`a`)
177 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
178 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
179 SELECT * FROM t1;
180 a b
181 1 Original from partition p0
182 11 Original from partition p1
183 12 Original from partition p1
184 13 Original from partition p1
185 14 Original from partition p1
186 2 Original from partition p0
187 21 Original from partition p1
188 22 Original from partition p1
189 23 Original from partition p1
190 24 Original from partition p1
191 3 Original from partition p0
192 4 Original from partition p0
193 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
194 ERROR HY000: Lost connection to server during query
195 # State after crash (before recovery)
196 db.opt
197 t1#P#p0.MYD
198 t1#P#p0.MYI
199 t1#P#p1.MYD
200 t1#P#p1.MYI
201 t1.frm
202 t1.par
203 t2.MYD
204 t2.MYI
205 t2.frm
206 # State after crash recovery
207 db.opt
208 t1#P#p0.MYD
209 t1#P#p0.MYI
210 t1#P#p1.MYD
211 t1#P#p1.MYI
212 t1.frm
213 t1.par
214 t2.MYD
215 t2.MYI
216 t2.frm
217 SHOW CREATE TABLE t1;
218 Table Create Table
219 t1 CREATE TABLE `t1` (
220 `a` int(11) DEFAULT NULL,
221 `b` varchar(64) DEFAULT NULL
222 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
223 PARTITION BY RANGE (`a`)
224 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
225 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
226 SELECT * FROM t1;
227 a b
228 1 Original from partition p0
229 11 Original from partition p1
230 12 Original from partition p1
231 13 Original from partition p1
232 14 Original from partition p1
233 2 Original from partition p0
234 21 Original from partition p1
235 22 Original from partition p1
236 23 Original from partition p1
237 24 Original from partition p1
238 3 Original from partition p0
239 4 Original from partition p0
240 DROP TABLE t1;
241 SHOW CREATE TABLE t2;
242 Table Create Table
243 t2 CREATE TABLE `t2` (
244 `a` int(11) DEFAULT NULL,
245 `b` varchar(64) DEFAULT NULL
246 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
247 SELECT * FROM t2;
248 a b
249 5 Original from table t2
250 6 Original from table t2
251 7 Original from table t2
252 8 Original from table t2
253 DROP TABLE t2;
254 SET SESSION debug_dbug=@save_dbug;
255 SET SESSION debug_dbug="+d,exchange_partition_abort_3";
256 CREATE TABLE t2 (a INT, b VARCHAR(64));
257 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
258 SHOW CREATE TABLE t2;
259 Table Create Table
260 t2 CREATE TABLE `t2` (
261 `a` int(11) DEFAULT NULL,
262 `b` varchar(64) DEFAULT NULL
263 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
264 SELECT * FROM t2;
265 a b
266 5 Original from table t2
267 6 Original from table t2
268 7 Original from table t2
269 8 Original from table t2
270 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
271 (PARTITION p0 VALUES LESS THAN (10),
272 PARTITION p1 VALUES LESS THAN MAXVALUE);
273 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
274 # State before crash
275 db.opt
276 t1#P#p0.MYD
277 t1#P#p0.MYI
278 t1#P#p1.MYD
279 t1#P#p1.MYI
280 t1.frm
281 t1.par
282 t2.MYD
283 t2.MYI
284 t2.frm
285 SHOW CREATE TABLE t1;
286 Table Create Table
287 t1 CREATE TABLE `t1` (
288 `a` int(11) DEFAULT NULL,
289 `b` varchar(64) DEFAULT NULL
290 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
291 PARTITION BY RANGE (`a`)
292 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
293 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
294 SELECT * FROM t1;
295 a b
296 1 Original from partition p0
297 11 Original from partition p1
298 12 Original from partition p1
299 13 Original from partition p1
300 14 Original from partition p1
301 2 Original from partition p0
302 21 Original from partition p1
303 22 Original from partition p1
304 23 Original from partition p1
305 24 Original from partition p1
306 3 Original from partition p0
307 4 Original from partition p0
308 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
309 ERROR HY000: Lost connection to server during query
310 # State after crash (before recovery)
311 db.opt
312 t1#P#p0.MYD
313 t1#P#p0.MYI
314 t1#P#p1.MYD
315 t1#P#p1.MYI
316 t1.frm
317 t1.par
318 t2.MYD
319 t2.MYI
320 t2.frm
321 # State after crash recovery
322 db.opt
323 t1#P#p0.MYD
324 t1#P#p0.MYI
325 t1#P#p1.MYD
326 t1#P#p1.MYI
327 t1.frm
328 t1.par
329 t2.MYD
330 t2.MYI
331 t2.frm
332 SHOW CREATE TABLE t1;
333 Table Create Table
334 t1 CREATE TABLE `t1` (
335 `a` int(11) DEFAULT NULL,
336 `b` varchar(64) DEFAULT NULL
337 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
338 PARTITION BY RANGE (`a`)
339 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
340 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
341 SELECT * FROM t1;
342 a b
343 1 Original from partition p0
344 11 Original from partition p1
345 12 Original from partition p1
346 13 Original from partition p1
347 14 Original from partition p1
348 2 Original from partition p0
349 21 Original from partition p1
350 22 Original from partition p1
351 23 Original from partition p1
352 24 Original from partition p1
353 3 Original from partition p0
354 4 Original from partition p0
355 DROP TABLE t1;
356 SHOW CREATE TABLE t2;
357 Table Create Table
358 t2 CREATE TABLE `t2` (
359 `a` int(11) DEFAULT NULL,
360 `b` varchar(64) DEFAULT NULL
361 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
362 SELECT * FROM t2;
363 a b
364 5 Original from table t2
365 6 Original from table t2
366 7 Original from table t2
367 8 Original from table t2
368 DROP TABLE t2;
369 SET SESSION debug_dbug=@save_dbug;
370 SET SESSION debug_dbug="+d,exchange_partition_abort_4";
371 CREATE TABLE t2 (a INT, b VARCHAR(64));
372 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
373 SHOW CREATE TABLE t2;
374 Table Create Table
375 t2 CREATE TABLE `t2` (
376 `a` int(11) DEFAULT NULL,
377 `b` varchar(64) DEFAULT NULL
378 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
379 SELECT * FROM t2;
380 a b
381 5 Original from table t2
382 6 Original from table t2
383 7 Original from table t2
384 8 Original from table t2
385 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
386 (PARTITION p0 VALUES LESS THAN (10),
387 PARTITION p1 VALUES LESS THAN MAXVALUE);
388 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
389 # State before crash
390 db.opt
391 t1#P#p0.MYD
392 t1#P#p0.MYI
393 t1#P#p1.MYD
394 t1#P#p1.MYI
395 t1.frm
396 t1.par
397 t2.MYD
398 t2.MYI
399 t2.frm
400 SHOW CREATE TABLE t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `a` int(11) DEFAULT NULL,
404 `b` varchar(64) DEFAULT NULL
405 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
406 PARTITION BY RANGE (`a`)
407 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
408 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
409 SELECT * FROM t1;
410 a b
411 1 Original from partition p0
412 11 Original from partition p1
413 12 Original from partition p1
414 13 Original from partition p1
415 14 Original from partition p1
416 2 Original from partition p0
417 21 Original from partition p1
418 22 Original from partition p1
419 23 Original from partition p1
420 24 Original from partition p1
421 3 Original from partition p0
422 4 Original from partition p0
423 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
424 ERROR HY000: Lost connection to server during query
425 # State after crash (before recovery)
426 #sql-exchange.frm
427 # State after crash recovery
428 db.opt
429 t1#P#p0.MYD
430 t1#P#p0.MYI
431 t1#P#p1.MYD
432 t1#P#p1.MYI
433 t1.frm
434 t1.par
435 t2.MYD
436 t2.MYI
437 t2.frm
438 SHOW CREATE TABLE t1;
439 Table Create Table
440 t1 CREATE TABLE `t1` (
441 `a` int(11) DEFAULT NULL,
442 `b` varchar(64) DEFAULT NULL
443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
444 PARTITION BY RANGE (`a`)
445 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
446 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
447 SELECT * FROM t1;
448 a b
449 1 Original from partition p0
450 11 Original from partition p1
451 12 Original from partition p1
452 13 Original from partition p1
453 14 Original from partition p1
454 2 Original from partition p0
455 21 Original from partition p1
456 22 Original from partition p1
457 23 Original from partition p1
458 24 Original from partition p1
459 3 Original from partition p0
460 4 Original from partition p0
461 DROP TABLE t1;
462 SHOW CREATE TABLE t2;
463 Table Create Table
464 t2 CREATE TABLE `t2` (
465 `a` int(11) DEFAULT NULL,
466 `b` varchar(64) DEFAULT NULL
467 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
468 SELECT * FROM t2;
469 a b
470 5 Original from table t2
471 6 Original from table t2
472 7 Original from table t2
473 8 Original from table t2
474 DROP TABLE t2;
475 SET SESSION debug_dbug=@save_dbug;
476 SET SESSION debug_dbug="+d,exchange_partition_abort_5";
477 CREATE TABLE t2 (a INT, b VARCHAR(64));
478 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
479 SHOW CREATE TABLE t2;
480 Table Create Table
481 t2 CREATE TABLE `t2` (
482 `a` int(11) DEFAULT NULL,
483 `b` varchar(64) DEFAULT NULL
484 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
485 SELECT * FROM t2;
486 a b
487 5 Original from table t2
488 6 Original from table t2
489 7 Original from table t2
490 8 Original from table t2
491 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
492 (PARTITION p0 VALUES LESS THAN (10),
493 PARTITION p1 VALUES LESS THAN MAXVALUE);
494 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
495 # State before crash
496 db.opt
497 t1#P#p0.MYD
498 t1#P#p0.MYI
499 t1#P#p1.MYD
500 t1#P#p1.MYI
501 t1.frm
502 t1.par
503 t2.MYD
504 t2.MYI
505 t2.frm
506 SHOW CREATE TABLE t1;
507 Table Create Table
508 t1 CREATE TABLE `t1` (
509 `a` int(11) DEFAULT NULL,
510 `b` varchar(64) DEFAULT NULL
511 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
512 PARTITION BY RANGE (`a`)
513 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
514 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
515 SELECT * FROM t1;
516 a b
517 1 Original from partition p0
518 11 Original from partition p1
519 12 Original from partition p1
520 13 Original from partition p1
521 14 Original from partition p1
522 2 Original from partition p0
523 21 Original from partition p1
524 22 Original from partition p1
525 23 Original from partition p1
526 24 Original from partition p1
527 3 Original from partition p0
528 4 Original from partition p0
529 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
530 ERROR HY000: Lost connection to server during query
531 # State after crash (before recovery)
532 #sql-exchange.frm
533 # State after crash recovery
534 db.opt
535 t1#P#p0.MYD
536 t1#P#p0.MYI
537 t1#P#p1.MYD
538 t1#P#p1.MYI
539 t1.frm
540 t1.par
541 t2.MYD
542 t2.MYI
543 t2.frm
544 SHOW CREATE TABLE t1;
545 Table Create Table
546 t1 CREATE TABLE `t1` (
547 `a` int(11) DEFAULT NULL,
548 `b` varchar(64) DEFAULT NULL
549 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
550 PARTITION BY RANGE (`a`)
551 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
552 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
553 SELECT * FROM t1;
554 a b
555 1 Original from partition p0
556 11 Original from partition p1
557 12 Original from partition p1
558 13 Original from partition p1
559 14 Original from partition p1
560 2 Original from partition p0
561 21 Original from partition p1
562 22 Original from partition p1
563 23 Original from partition p1
564 24 Original from partition p1
565 3 Original from partition p0
566 4 Original from partition p0
567 DROP TABLE t1;
568 SHOW CREATE TABLE t2;
569 Table Create Table
570 t2 CREATE TABLE `t2` (
571 `a` int(11) DEFAULT NULL,
572 `b` varchar(64) DEFAULT NULL
573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
574 SELECT * FROM t2;
575 a b
576 5 Original from table t2
577 6 Original from table t2
578 7 Original from table t2
579 8 Original from table t2
580 DROP TABLE t2;
581 SET SESSION debug_dbug=@save_dbug;
582 SET SESSION debug_dbug="+d,exchange_partition_abort_6";
583 CREATE TABLE t2 (a INT, b VARCHAR(64));
584 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
585 SHOW CREATE TABLE t2;
586 Table Create Table
587 t2 CREATE TABLE `t2` (
588 `a` int(11) DEFAULT NULL,
589 `b` varchar(64) DEFAULT NULL
590 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
591 SELECT * FROM t2;
592 a b
593 5 Original from table t2
594 6 Original from table t2
595 7 Original from table t2
596 8 Original from table t2
597 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
598 (PARTITION p0 VALUES LESS THAN (10),
599 PARTITION p1 VALUES LESS THAN MAXVALUE);
600 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
601 # State before crash
602 db.opt
603 t1#P#p0.MYD
604 t1#P#p0.MYI
605 t1#P#p1.MYD
606 t1#P#p1.MYI
607 t1.frm
608 t1.par
609 t2.MYD
610 t2.MYI
611 t2.frm
612 SHOW CREATE TABLE t1;
613 Table Create Table
614 t1 CREATE TABLE `t1` (
615 `a` int(11) DEFAULT NULL,
616 `b` varchar(64) DEFAULT NULL
617 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
618 PARTITION BY RANGE (`a`)
619 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
620 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
621 SELECT * FROM t1;
622 a b
623 1 Original from partition p0
624 11 Original from partition p1
625 12 Original from partition p1
626 13 Original from partition p1
627 14 Original from partition p1
628 2 Original from partition p0
629 21 Original from partition p1
630 22 Original from partition p1
631 23 Original from partition p1
632 24 Original from partition p1
633 3 Original from partition p0
634 4 Original from partition p0
635 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
636 ERROR HY000: Lost connection to server during query
637 # State after crash (before recovery)
638 #sql-exchange.frm
639 # State after crash recovery
640 db.opt
641 t1#P#p0.MYD
642 t1#P#p0.MYI
643 t1#P#p1.MYD
644 t1#P#p1.MYI
645 t1.frm
646 t1.par
647 t2.MYD
648 t2.MYI
649 t2.frm
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 RANGE (`a`)
657 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
658 PARTITION `p1` VALUES LESS THAN MAXVALUE 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 21 Original from partition p1
668 22 Original from partition p1
669 23 Original from partition p1
670 24 Original from partition p1
671 3 Original from partition p0
672 4 Original from partition p0
673 DROP TABLE t1;
674 SHOW CREATE TABLE t2;
675 Table Create Table
676 t2 CREATE TABLE `t2` (
677 `a` int(11) DEFAULT NULL,
678 `b` varchar(64) DEFAULT NULL
679 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
680 SELECT * FROM t2;
681 a b
682 5 Original from table t2
683 6 Original from table t2
684 7 Original from table t2
685 8 Original from table t2
686 DROP TABLE t2;
687 SET SESSION debug_dbug=@save_dbug;
688 SET SESSION debug_dbug="+d,exchange_partition_abort_7";
689 CREATE TABLE t2 (a INT, b VARCHAR(64));
690 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
691 SHOW CREATE TABLE t2;
692 Table Create Table
693 t2 CREATE TABLE `t2` (
694 `a` int(11) DEFAULT NULL,
695 `b` varchar(64) DEFAULT NULL
696 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
697 SELECT * FROM t2;
698 a b
699 5 Original from table t2
700 6 Original from table t2
701 7 Original from table t2
702 8 Original from table t2
703 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
704 (PARTITION p0 VALUES LESS THAN (10),
705 PARTITION p1 VALUES LESS THAN MAXVALUE);
706 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
707 # State before crash
708 db.opt
709 t1#P#p0.MYD
710 t1#P#p0.MYI
711 t1#P#p1.MYD
712 t1#P#p1.MYI
713 t1.frm
714 t1.par
715 t2.MYD
716 t2.MYI
717 t2.frm
718 SHOW CREATE TABLE t1;
719 Table Create Table
720 t1 CREATE TABLE `t1` (
721 `a` int(11) DEFAULT NULL,
722 `b` varchar(64) DEFAULT NULL
723 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
724 PARTITION BY RANGE (`a`)
725 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
726 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
727 SELECT * FROM t1;
728 a b
729 1 Original from partition p0
730 11 Original from partition p1
731 12 Original from partition p1
732 13 Original from partition p1
733 14 Original from partition p1
734 2 Original from partition p0
735 21 Original from partition p1
736 22 Original from partition p1
737 23 Original from partition p1
738 24 Original from partition p1
739 3 Original from partition p0
740 4 Original from partition p0
741 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
742 ERROR HY000: Lost connection to server during query
743 # State after crash (before recovery)
744 #sql-exchange.frm
745 # State after crash recovery
746 db.opt
747 t1#P#p0.MYD
748 t1#P#p0.MYI
749 t1#P#p1.MYD
750 t1#P#p1.MYI
751 t1.frm
752 t1.par
753 t2.MYD
754 t2.MYI
755 t2.frm
756 SHOW CREATE TABLE t1;
757 Table Create Table
758 t1 CREATE TABLE `t1` (
759 `a` int(11) DEFAULT NULL,
760 `b` varchar(64) DEFAULT NULL
761 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
762 PARTITION BY RANGE (`a`)
763 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
764 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
765 SELECT * FROM t1;
766 a b
767 1 Original from partition p0
768 11 Original from partition p1
769 12 Original from partition p1
770 13 Original from partition p1
771 14 Original from partition p1
772 2 Original from partition p0
773 21 Original from partition p1
774 22 Original from partition p1
775 23 Original from partition p1
776 24 Original from partition p1
777 3 Original from partition p0
778 4 Original from partition p0
779 DROP TABLE t1;
780 SHOW CREATE TABLE t2;
781 Table Create Table
782 t2 CREATE TABLE `t2` (
783 `a` int(11) DEFAULT NULL,
784 `b` varchar(64) DEFAULT NULL
785 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
786 SELECT * FROM t2;
787 a b
788 5 Original from table t2
789 6 Original from table t2
790 7 Original from table t2
791 8 Original from table t2
792 DROP TABLE t2;
793 SET SESSION debug_dbug=@save_dbug;
794 SET SESSION debug_dbug="+d,exchange_partition_abort_8";
795 CREATE TABLE t2 (a INT, b VARCHAR(64));
796 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
797 SHOW CREATE TABLE t2;
798 Table Create Table
799 t2 CREATE TABLE `t2` (
800 `a` int(11) DEFAULT NULL,
801 `b` varchar(64) DEFAULT NULL
802 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
803 SELECT * FROM t2;
804 a b
805 5 Original from table t2
806 6 Original from table t2
807 7 Original from table t2
808 8 Original from table t2
809 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
810 (PARTITION p0 VALUES LESS THAN (10),
811 PARTITION p1 VALUES LESS THAN MAXVALUE);
812 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
813 # State before crash
814 db.opt
815 t1#P#p0.MYD
816 t1#P#p0.MYI
817 t1#P#p1.MYD
818 t1#P#p1.MYI
819 t1.frm
820 t1.par
821 t2.MYD
822 t2.MYI
823 t2.frm
824 SHOW CREATE TABLE t1;
825 Table Create Table
826 t1 CREATE TABLE `t1` (
827 `a` int(11) DEFAULT NULL,
828 `b` varchar(64) DEFAULT NULL
829 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
830 PARTITION BY RANGE (`a`)
831 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
832 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
833 SELECT * FROM t1;
834 a b
835 1 Original from partition p0
836 11 Original from partition p1
837 12 Original from partition p1
838 13 Original from partition p1
839 14 Original from partition p1
840 2 Original from partition p0
841 21 Original from partition p1
842 22 Original from partition p1
843 23 Original from partition p1
844 24 Original from partition p1
845 3 Original from partition p0
846 4 Original from partition p0
847 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
848 ERROR HY000: Lost connection to server during query
849 # State after crash (before recovery)
850 db.opt
851 t1#P#p0.MYD
852 t1#P#p0.MYI
853 t1#P#p1.MYD
854 t1#P#p1.MYI
855 t1.frm
856 t1.par
857 t2.MYD
858 t2.MYI
859 t2.frm
860 # State after crash recovery
861 db.opt
862 t1#P#p0.MYD
863 t1#P#p0.MYI
864 t1#P#p1.MYD
865 t1#P#p1.MYI
866 t1.frm
867 t1.par
868 t2.MYD
869 t2.MYI
870 t2.frm
871 SHOW CREATE TABLE t1;
872 Table Create Table
873 t1 CREATE TABLE `t1` (
874 `a` int(11) DEFAULT NULL,
875 `b` varchar(64) DEFAULT NULL
876 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
877 PARTITION BY RANGE (`a`)
878 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
879 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
880 SELECT * FROM t1;
881 a b
882 1 Original from partition p0
883 11 Original from partition p1
884 12 Original from partition p1
885 13 Original from partition p1
886 14 Original from partition p1
887 2 Original from partition p0
888 21 Original from partition p1
889 22 Original from partition p1
890 23 Original from partition p1
891 24 Original from partition p1
892 3 Original from partition p0
893 4 Original from partition p0
894 DROP TABLE t1;
895 SHOW CREATE TABLE t2;
896 Table Create Table
897 t2 CREATE TABLE `t2` (
898 `a` int(11) DEFAULT NULL,
899 `b` varchar(64) DEFAULT NULL
900 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
901 SELECT * FROM t2;
902 a b
903 5 Original from table t2
904 6 Original from table t2
905 7 Original from table t2
906 8 Original from table t2
907 DROP TABLE t2;
908 SET SESSION debug_dbug=@save_dbug;
909 SET SESSION debug_dbug="+d,exchange_partition_abort_9";
910 CREATE TABLE t2 (a INT, b VARCHAR(64));
911 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
912 SHOW CREATE TABLE t2;
913 Table Create Table
914 t2 CREATE TABLE `t2` (
915 `a` int(11) DEFAULT NULL,
916 `b` varchar(64) DEFAULT NULL
917 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
918 SELECT * FROM t2;
919 a b
920 5 Original from table t2
921 6 Original from table t2
922 7 Original from table t2
923 8 Original from table t2
924 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
925 (PARTITION p0 VALUES LESS THAN (10),
926 PARTITION p1 VALUES LESS THAN MAXVALUE);
927 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
928 # State before crash
929 db.opt
930 t1#P#p0.MYD
931 t1#P#p0.MYI
932 t1#P#p1.MYD
933 t1#P#p1.MYI
934 t1.frm
935 t1.par
936 t2.MYD
937 t2.MYI
938 t2.frm
939 SHOW CREATE TABLE t1;
940 Table Create Table
941 t1 CREATE TABLE `t1` (
942 `a` int(11) DEFAULT NULL,
943 `b` varchar(64) DEFAULT NULL
944 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
945 PARTITION BY RANGE (`a`)
946 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
947 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
948 SELECT * FROM t1;
949 a b
950 1 Original from partition p0
951 11 Original from partition p1
952 12 Original from partition p1
953 13 Original from partition p1
954 14 Original from partition p1
955 2 Original from partition p0
956 21 Original from partition p1
957 22 Original from partition p1
958 23 Original from partition p1
959 24 Original from partition p1
960 3 Original from partition p0
961 4 Original from partition p0
962 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
963 ERROR HY000: Lost connection to server during query
964 # State after crash (before recovery)
965 db.opt
966 t1#P#p0.MYD
967 t1#P#p0.MYI
968 t1#P#p1.MYD
969 t1#P#p1.MYI
970 t1.frm
971 t1.par
972 t2.MYD
973 t2.MYI
974 t2.frm
975 # State after crash recovery
976 db.opt
977 t1#P#p0.MYD
978 t1#P#p0.MYI
979 t1#P#p1.MYD
980 t1#P#p1.MYI
981 t1.frm
982 t1.par
983 t2.MYD
984 t2.MYI
985 t2.frm
986 SHOW CREATE TABLE t1;
987 Table Create Table
988 t1 CREATE TABLE `t1` (
989 `a` int(11) DEFAULT NULL,
990 `b` varchar(64) DEFAULT NULL
991 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
992 PARTITION BY RANGE (`a`)
993 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
994 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
995 SELECT * FROM t1;
996 a b
997 11 Original from partition p1
998 12 Original from partition p1
999 13 Original from partition p1
1000 14 Original from partition p1
1001 21 Original from partition p1
1002 22 Original from partition p1
1003 23 Original from partition p1
1004 24 Original from partition p1
1005 5 Original from table t2
1006 6 Original from table t2
1007 7 Original from table t2
1008 8 Original from table t2
1009 DROP TABLE t1;
1010 SHOW CREATE TABLE t2;
1011 Table Create Table
1012 t2 CREATE TABLE `t2` (
1013 `a` int(11) DEFAULT NULL,
1014 `b` varchar(64) DEFAULT NULL
1015 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1016 SELECT * FROM t2;
1017 a b
1018 1 Original from partition p0
1019 2 Original from partition p0
1020 3 Original from partition p0
1021 4 Original from partition p0
1022 DROP TABLE t2;
1023 SET SESSION debug_dbug=@save_dbug;
1024 SET @save_dbug=@@debug_dbug;
1025 SET SESSION debug_dbug="+d,exchange_partition_fail_1";
1026 CREATE TABLE t2 (a INT, b VARCHAR(64));
1027 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1028 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1029 (PARTITION p0 VALUES LESS THAN (10),
1030 PARTITION p1 VALUES LESS THAN MAXVALUE);
1031 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1032 # d,exchange_partition_fail_1: BEFORE failure
1033 db.opt
1034 t1#P#p0.MYD
1035 t1#P#p0.MYI
1036 t1#P#p1.MYD
1037 t1#P#p1.MYI
1038 t1.frm
1039 t1.par
1040 t2.MYD
1041 t2.MYI
1042 t2.frm
1043 SHOW CREATE TABLE t1;
1044 Table Create Table
1045 t1 CREATE TABLE `t1` (
1046 `a` int(11) DEFAULT NULL,
1047 `b` varchar(64) DEFAULT NULL
1048 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1049 PARTITION BY RANGE (`a`)
1050 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1051 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1052 SELECT * FROM t1;
1053 a b
1054 1 Original from partition p0
1055 11 Original from partition p1
1056 12 Original from partition p1
1057 13 Original from partition p1
1058 14 Original from partition p1
1059 2 Original from partition p0
1060 21 Original from partition p1
1061 22 Original from partition p1
1062 23 Original from partition p1
1063 24 Original from partition p1
1064 3 Original from partition p0
1065 4 Original from partition p0
1066 SHOW CREATE TABLE t2;
1067 Table Create Table
1068 t2 CREATE TABLE `t2` (
1069 `a` int(11) DEFAULT NULL,
1070 `b` varchar(64) DEFAULT NULL
1071 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1072 SELECT * FROM t2;
1073 a b
1074 5 Original from table t2
1075 6 Original from table t2
1076 7 Original from table t2
1077 8 Original from table t2
1078 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1079 ERROR HY000: Error in DDL log
1080 # d,exchange_partition_fail_1: AFTER failure
1081 db.opt
1082 t1#P#p0.MYD
1083 t1#P#p0.MYI
1084 t1#P#p1.MYD
1085 t1#P#p1.MYI
1086 t1.frm
1087 t1.par
1088 t2.MYD
1089 t2.MYI
1090 t2.frm
1091 SHOW CREATE TABLE t1;
1092 Table Create Table
1093 t1 CREATE TABLE `t1` (
1094 `a` int(11) DEFAULT NULL,
1095 `b` varchar(64) DEFAULT NULL
1096 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1097 PARTITION BY RANGE (`a`)
1098 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1099 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1100 SELECT * FROM t1;
1101 a b
1102 1 Original from partition p0
1103 11 Original from partition p1
1104 12 Original from partition p1
1105 13 Original from partition p1
1106 14 Original from partition p1
1107 2 Original from partition p0
1108 21 Original from partition p1
1109 22 Original from partition p1
1110 23 Original from partition p1
1111 24 Original from partition p1
1112 3 Original from partition p0
1113 4 Original from partition p0
1114 DROP TABLE t1;
1115 SHOW CREATE TABLE t2;
1116 Table Create Table
1117 t2 CREATE TABLE `t2` (
1118 `a` int(11) DEFAULT NULL,
1119 `b` varchar(64) DEFAULT NULL
1120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1121 SELECT * FROM t2;
1122 a b
1123 5 Original from table t2
1124 6 Original from table t2
1125 7 Original from table t2
1126 8 Original from table t2
1127 DROP TABLE t2;
1128 SET SESSION debug_dbug=@save_dbug;
1129 SET SESSION debug_dbug="+d,exchange_partition_fail_2";
1130 CREATE TABLE t2 (a INT, b VARCHAR(64));
1131 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1132 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1133 (PARTITION p0 VALUES LESS THAN (10),
1134 PARTITION p1 VALUES LESS THAN MAXVALUE);
1135 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1136 # d,exchange_partition_fail_2: BEFORE failure
1137 db.opt
1138 t1#P#p0.MYD
1139 t1#P#p0.MYI
1140 t1#P#p1.MYD
1141 t1#P#p1.MYI
1142 t1.frm
1143 t1.par
1144 t2.MYD
1145 t2.MYI
1146 t2.frm
1147 SHOW CREATE TABLE t1;
1148 Table Create Table
1149 t1 CREATE TABLE `t1` (
1150 `a` int(11) DEFAULT NULL,
1151 `b` varchar(64) DEFAULT NULL
1152 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1153 PARTITION BY RANGE (`a`)
1154 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1155 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1156 SELECT * FROM t1;
1157 a b
1158 1 Original from partition p0
1159 11 Original from partition p1
1160 12 Original from partition p1
1161 13 Original from partition p1
1162 14 Original from partition p1
1163 2 Original from partition p0
1164 21 Original from partition p1
1165 22 Original from partition p1
1166 23 Original from partition p1
1167 24 Original from partition p1
1168 3 Original from partition p0
1169 4 Original from partition p0
1170 SHOW CREATE TABLE t2;
1171 Table Create Table
1172 t2 CREATE TABLE `t2` (
1173 `a` int(11) DEFAULT NULL,
1174 `b` varchar(64) DEFAULT NULL
1175 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1176 SELECT * FROM t2;
1177 a b
1178 5 Original from table t2
1179 6 Original from table t2
1180 7 Original from table t2
1181 8 Original from table t2
1182 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1183 ERROR HY000: Error in DDL log
1184 # d,exchange_partition_fail_2: AFTER failure
1185 db.opt
1186 t1#P#p0.MYD
1187 t1#P#p0.MYI
1188 t1#P#p1.MYD
1189 t1#P#p1.MYI
1190 t1.frm
1191 t1.par
1192 t2.MYD
1193 t2.MYI
1194 t2.frm
1195 SHOW CREATE TABLE t1;
1196 Table Create Table
1197 t1 CREATE TABLE `t1` (
1198 `a` int(11) DEFAULT NULL,
1199 `b` varchar(64) DEFAULT NULL
1200 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1201 PARTITION BY RANGE (`a`)
1202 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1203 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1204 SELECT * FROM t1;
1205 a b
1206 1 Original from partition p0
1207 11 Original from partition p1
1208 12 Original from partition p1
1209 13 Original from partition p1
1210 14 Original from partition p1
1211 2 Original from partition p0
1212 21 Original from partition p1
1213 22 Original from partition p1
1214 23 Original from partition p1
1215 24 Original from partition p1
1216 3 Original from partition p0
1217 4 Original from partition p0
1218 DROP TABLE t1;
1219 SHOW CREATE TABLE t2;
1220 Table Create Table
1221 t2 CREATE TABLE `t2` (
1222 `a` int(11) DEFAULT NULL,
1223 `b` varchar(64) DEFAULT NULL
1224 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1225 SELECT * FROM t2;
1226 a b
1227 5 Original from table t2
1228 6 Original from table t2
1229 7 Original from table t2
1230 8 Original from table t2
1231 DROP TABLE t2;
1232 SET SESSION debug_dbug=@save_dbug;
1233 SET SESSION debug_dbug="+d,exchange_partition_fail_3";
1234 CREATE TABLE t2 (a INT, b VARCHAR(64));
1235 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1236 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1237 (PARTITION p0 VALUES LESS THAN (10),
1238 PARTITION p1 VALUES LESS THAN MAXVALUE);
1239 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1240 # d,exchange_partition_fail_3: BEFORE failure
1241 db.opt
1242 t1#P#p0.MYD
1243 t1#P#p0.MYI
1244 t1#P#p1.MYD
1245 t1#P#p1.MYI
1246 t1.frm
1247 t1.par
1248 t2.MYD
1249 t2.MYI
1250 t2.frm
1251 SHOW CREATE TABLE t1;
1252 Table Create Table
1253 t1 CREATE TABLE `t1` (
1254 `a` int(11) DEFAULT NULL,
1255 `b` varchar(64) DEFAULT NULL
1256 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1257 PARTITION BY RANGE (`a`)
1258 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1259 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1260 SELECT * FROM t1;
1261 a b
1262 1 Original from partition p0
1263 11 Original from partition p1
1264 12 Original from partition p1
1265 13 Original from partition p1
1266 14 Original from partition p1
1267 2 Original from partition p0
1268 21 Original from partition p1
1269 22 Original from partition p1
1270 23 Original from partition p1
1271 24 Original from partition p1
1272 3 Original from partition p0
1273 4 Original from partition p0
1274 SHOW CREATE TABLE t2;
1275 Table Create Table
1276 t2 CREATE TABLE `t2` (
1277 `a` int(11) DEFAULT NULL,
1278 `b` varchar(64) DEFAULT NULL
1279 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1280 SELECT * FROM t2;
1281 a b
1282 5 Original from table t2
1283 6 Original from table t2
1284 7 Original from table t2
1285 8 Original from table t2
1286 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1287 ERROR HY000: Error on rename of './test/t2' to './test/#sql-exchange' (errno: 0 "Internal error/check (Not system error)")
1288 # d,exchange_partition_fail_3: AFTER failure
1289 db.opt
1290 t1#P#p0.MYD
1291 t1#P#p0.MYI
1292 t1#P#p1.MYD
1293 t1#P#p1.MYI
1294 t1.frm
1295 t1.par
1296 t2.MYD
1297 t2.MYI
1298 t2.frm
1299 SHOW CREATE TABLE t1;
1300 Table Create Table
1301 t1 CREATE TABLE `t1` (
1302 `a` int(11) DEFAULT NULL,
1303 `b` varchar(64) DEFAULT NULL
1304 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1305 PARTITION BY RANGE (`a`)
1306 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1307 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1308 SELECT * FROM t1;
1309 a b
1310 1 Original from partition p0
1311 11 Original from partition p1
1312 12 Original from partition p1
1313 13 Original from partition p1
1314 14 Original from partition p1
1315 2 Original from partition p0
1316 21 Original from partition p1
1317 22 Original from partition p1
1318 23 Original from partition p1
1319 24 Original from partition p1
1320 3 Original from partition p0
1321 4 Original from partition p0
1322 DROP TABLE t1;
1323 SHOW CREATE TABLE t2;
1324 Table Create Table
1325 t2 CREATE TABLE `t2` (
1326 `a` int(11) DEFAULT NULL,
1327 `b` varchar(64) DEFAULT NULL
1328 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1329 SELECT * FROM t2;
1330 a b
1331 5 Original from table t2
1332 6 Original from table t2
1333 7 Original from table t2
1334 8 Original from table t2
1335 DROP TABLE t2;
1336 SET SESSION debug_dbug=@save_dbug;
1337 SET SESSION debug_dbug="+d,exchange_partition_fail_4";
1338 CREATE TABLE t2 (a INT, b VARCHAR(64));
1339 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1340 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1341 (PARTITION p0 VALUES LESS THAN (10),
1342 PARTITION p1 VALUES LESS THAN MAXVALUE);
1343 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1344 # d,exchange_partition_fail_4: BEFORE failure
1345 db.opt
1346 t1#P#p0.MYD
1347 t1#P#p0.MYI
1348 t1#P#p1.MYD
1349 t1#P#p1.MYI
1350 t1.frm
1351 t1.par
1352 t2.MYD
1353 t2.MYI
1354 t2.frm
1355 SHOW CREATE TABLE t1;
1356 Table Create Table
1357 t1 CREATE TABLE `t1` (
1358 `a` int(11) DEFAULT NULL,
1359 `b` varchar(64) DEFAULT NULL
1360 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1361 PARTITION BY RANGE (`a`)
1362 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1363 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1364 SELECT * FROM t1;
1365 a b
1366 1 Original from partition p0
1367 11 Original from partition p1
1368 12 Original from partition p1
1369 13 Original from partition p1
1370 14 Original from partition p1
1371 2 Original from partition p0
1372 21 Original from partition p1
1373 22 Original from partition p1
1374 23 Original from partition p1
1375 24 Original from partition p1
1376 3 Original from partition p0
1377 4 Original from partition p0
1378 SHOW CREATE TABLE t2;
1379 Table Create Table
1380 t2 CREATE TABLE `t2` (
1381 `a` int(11) DEFAULT NULL,
1382 `b` varchar(64) DEFAULT NULL
1383 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1384 SELECT * FROM t2;
1385 a b
1386 5 Original from table t2
1387 6 Original from table t2
1388 7 Original from table t2
1389 8 Original from table t2
1390 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1391 ERROR HY000: Error in DDL log
1392 # d,exchange_partition_fail_4: AFTER failure
1393 db.opt
1394 t1#P#p0.MYD
1395 t1#P#p0.MYI
1396 t1#P#p1.MYD
1397 t1#P#p1.MYI
1398 t1.frm
1399 t1.par
1400 t2.MYD
1401 t2.MYI
1402 t2.frm
1403 SHOW CREATE TABLE t1;
1404 Table Create Table
1405 t1 CREATE TABLE `t1` (
1406 `a` int(11) DEFAULT NULL,
1407 `b` varchar(64) DEFAULT NULL
1408 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1409 PARTITION BY RANGE (`a`)
1410 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1411 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1412 SELECT * FROM t1;
1413 a b
1414 1 Original from partition p0
1415 11 Original from partition p1
1416 12 Original from partition p1
1417 13 Original from partition p1
1418 14 Original from partition p1
1419 2 Original from partition p0
1420 21 Original from partition p1
1421 22 Original from partition p1
1422 23 Original from partition p1
1423 24 Original from partition p1
1424 3 Original from partition p0
1425 4 Original from partition p0
1426 DROP TABLE t1;
1427 SHOW CREATE TABLE t2;
1428 Table Create Table
1429 t2 CREATE TABLE `t2` (
1430 `a` int(11) DEFAULT NULL,
1431 `b` varchar(64) DEFAULT NULL
1432 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1433 SELECT * FROM t2;
1434 a b
1435 5 Original from table t2
1436 6 Original from table t2
1437 7 Original from table t2
1438 8 Original from table t2
1439 DROP TABLE t2;
1440 SET SESSION debug_dbug=@save_dbug;
1441 SET SESSION debug_dbug="+d,exchange_partition_fail_5";
1442 CREATE TABLE t2 (a INT, b VARCHAR(64));
1443 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1444 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1445 (PARTITION p0 VALUES LESS THAN (10),
1446 PARTITION p1 VALUES LESS THAN MAXVALUE);
1447 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1448 # d,exchange_partition_fail_5: BEFORE failure
1449 db.opt
1450 t1#P#p0.MYD
1451 t1#P#p0.MYI
1452 t1#P#p1.MYD
1453 t1#P#p1.MYI
1454 t1.frm
1455 t1.par
1456 t2.MYD
1457 t2.MYI
1458 t2.frm
1459 SHOW CREATE TABLE t1;
1460 Table Create Table
1461 t1 CREATE TABLE `t1` (
1462 `a` int(11) DEFAULT NULL,
1463 `b` varchar(64) DEFAULT NULL
1464 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1465 PARTITION BY RANGE (`a`)
1466 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1467 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1468 SELECT * FROM t1;
1469 a b
1470 1 Original from partition p0
1471 11 Original from partition p1
1472 12 Original from partition p1
1473 13 Original from partition p1
1474 14 Original from partition p1
1475 2 Original from partition p0
1476 21 Original from partition p1
1477 22 Original from partition p1
1478 23 Original from partition p1
1479 24 Original from partition p1
1480 3 Original from partition p0
1481 4 Original from partition p0
1482 SHOW CREATE TABLE t2;
1483 Table Create Table
1484 t2 CREATE TABLE `t2` (
1485 `a` int(11) DEFAULT NULL,
1486 `b` varchar(64) DEFAULT NULL
1487 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1488 SELECT * FROM t2;
1489 a b
1490 5 Original from table t2
1491 6 Original from table t2
1492 7 Original from table t2
1493 8 Original from table t2
1494 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1495 ERROR HY000: Error on rename of './test/t1#P#p0' to './test/t2' (errno: 0 "Internal error/check (Not system error)")
1496 # d,exchange_partition_fail_5: AFTER failure
1497 db.opt
1498 t1#P#p0.MYD
1499 t1#P#p0.MYI
1500 t1#P#p1.MYD
1501 t1#P#p1.MYI
1502 t1.frm
1503 t1.par
1504 t2.MYD
1505 t2.MYI
1506 t2.frm
1507 SHOW CREATE TABLE t1;
1508 Table Create Table
1509 t1 CREATE TABLE `t1` (
1510 `a` int(11) DEFAULT NULL,
1511 `b` varchar(64) DEFAULT NULL
1512 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1513 PARTITION BY RANGE (`a`)
1514 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1515 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1516 SELECT * FROM t1;
1517 a b
1518 1 Original from partition p0
1519 11 Original from partition p1
1520 12 Original from partition p1
1521 13 Original from partition p1
1522 14 Original from partition p1
1523 2 Original from partition p0
1524 21 Original from partition p1
1525 22 Original from partition p1
1526 23 Original from partition p1
1527 24 Original from partition p1
1528 3 Original from partition p0
1529 4 Original from partition p0
1530 DROP TABLE t1;
1531 SHOW CREATE TABLE t2;
1532 Table Create Table
1533 t2 CREATE TABLE `t2` (
1534 `a` int(11) DEFAULT NULL,
1535 `b` varchar(64) DEFAULT NULL
1536 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1537 SELECT * FROM t2;
1538 a b
1539 5 Original from table t2
1540 6 Original from table t2
1541 7 Original from table t2
1542 8 Original from table t2
1543 DROP TABLE t2;
1544 SET SESSION debug_dbug=@save_dbug;
1545 SET SESSION debug_dbug="+d,exchange_partition_fail_6";
1546 CREATE TABLE t2 (a INT, b VARCHAR(64));
1547 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1548 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1549 (PARTITION p0 VALUES LESS THAN (10),
1550 PARTITION p1 VALUES LESS THAN MAXVALUE);
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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1552 # d,exchange_partition_fail_6: BEFORE failure
1553 db.opt
1554 t1#P#p0.MYD
1555 t1#P#p0.MYI
1556 t1#P#p1.MYD
1557 t1#P#p1.MYI
1558 t1.frm
1559 t1.par
1560 t2.MYD
1561 t2.MYI
1562 t2.frm
1563 SHOW CREATE TABLE t1;
1564 Table Create Table
1565 t1 CREATE TABLE `t1` (
1566 `a` int(11) DEFAULT NULL,
1567 `b` varchar(64) DEFAULT NULL
1568 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1569 PARTITION BY RANGE (`a`)
1570 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1571 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1572 SELECT * FROM t1;
1573 a b
1574 1 Original from partition p0
1575 11 Original from partition p1
1576 12 Original from partition p1
1577 13 Original from partition p1
1578 14 Original from partition p1
1579 2 Original from partition p0
1580 21 Original from partition p1
1581 22 Original from partition p1
1582 23 Original from partition p1
1583 24 Original from partition p1
1584 3 Original from partition p0
1585 4 Original from partition p0
1586 SHOW CREATE TABLE t2;
1587 Table Create Table
1588 t2 CREATE TABLE `t2` (
1589 `a` int(11) DEFAULT NULL,
1590 `b` varchar(64) DEFAULT NULL
1591 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1592 SELECT * FROM t2;
1593 a b
1594 5 Original from table t2
1595 6 Original from table t2
1596 7 Original from table t2
1597 8 Original from table t2
1598 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1599 ERROR HY000: Error in DDL log
1600 # d,exchange_partition_fail_6: AFTER failure
1601 db.opt
1602 t1#P#p0.MYD
1603 t1#P#p0.MYI
1604 t1#P#p1.MYD
1605 t1#P#p1.MYI
1606 t1.frm
1607 t1.par
1608 t2.MYD
1609 t2.MYI
1610 t2.frm
1611 SHOW CREATE TABLE t1;
1612 Table Create Table
1613 t1 CREATE TABLE `t1` (
1614 `a` int(11) DEFAULT NULL,
1615 `b` varchar(64) DEFAULT NULL
1616 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1617 PARTITION BY RANGE (`a`)
1618 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1619 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1620 SELECT * FROM t1;
1621 a b
1622 1 Original from partition p0
1623 11 Original from partition p1
1624 12 Original from partition p1
1625 13 Original from partition p1
1626 14 Original from partition p1
1627 2 Original from partition p0
1628 21 Original from partition p1
1629 22 Original from partition p1
1630 23 Original from partition p1
1631 24 Original from partition p1
1632 3 Original from partition p0
1633 4 Original from partition p0
1634 DROP TABLE t1;
1635 SHOW CREATE TABLE t2;
1636 Table Create Table
1637 t2 CREATE TABLE `t2` (
1638 `a` int(11) DEFAULT NULL,
1639 `b` varchar(64) DEFAULT NULL
1640 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1641 SELECT * FROM t2;
1642 a b
1643 5 Original from table t2
1644 6 Original from table t2
1645 7 Original from table t2
1646 8 Original from table t2
1647 DROP TABLE t2;
1648 SET SESSION debug_dbug=@save_dbug;
1649 SET SESSION debug_dbug="+d,exchange_partition_fail_7";
1650 CREATE TABLE t2 (a INT, b VARCHAR(64));
1651 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1652 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1653 (PARTITION p0 VALUES LESS THAN (10),
1654 PARTITION p1 VALUES LESS THAN MAXVALUE);
1655 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1656 # d,exchange_partition_fail_7: BEFORE failure
1657 db.opt
1658 t1#P#p0.MYD
1659 t1#P#p0.MYI
1660 t1#P#p1.MYD
1661 t1#P#p1.MYI
1662 t1.frm
1663 t1.par
1664 t2.MYD
1665 t2.MYI
1666 t2.frm
1667 SHOW CREATE TABLE t1;
1668 Table Create Table
1669 t1 CREATE TABLE `t1` (
1670 `a` int(11) DEFAULT NULL,
1671 `b` varchar(64) DEFAULT NULL
1672 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1673 PARTITION BY RANGE (`a`)
1674 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1675 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1676 SELECT * FROM t1;
1677 a b
1678 1 Original from partition p0
1679 11 Original from partition p1
1680 12 Original from partition p1
1681 13 Original from partition p1
1682 14 Original from partition p1
1683 2 Original from partition p0
1684 21 Original from partition p1
1685 22 Original from partition p1
1686 23 Original from partition p1
1687 24 Original from partition p1
1688 3 Original from partition p0
1689 4 Original from partition p0
1690 SHOW CREATE TABLE t2;
1691 Table Create Table
1692 t2 CREATE TABLE `t2` (
1693 `a` int(11) DEFAULT NULL,
1694 `b` varchar(64) DEFAULT NULL
1695 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1696 SELECT * FROM t2;
1697 a b
1698 5 Original from table t2
1699 6 Original from table t2
1700 7 Original from table t2
1701 8 Original from table t2
1702 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1703 ERROR HY000: Error on rename of './test/#sql-exchange' to './test/t1#P#p0' (errno: 0 "Internal error/check (Not system error)")
1704 # d,exchange_partition_fail_7: AFTER failure
1705 db.opt
1706 t1#P#p0.MYD
1707 t1#P#p0.MYI
1708 t1#P#p1.MYD
1709 t1#P#p1.MYI
1710 t1.frm
1711 t1.par
1712 t2.MYD
1713 t2.MYI
1714 t2.frm
1715 SHOW CREATE TABLE t1;
1716 Table Create Table
1717 t1 CREATE TABLE `t1` (
1718 `a` int(11) DEFAULT NULL,
1719 `b` varchar(64) DEFAULT NULL
1720 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1721 PARTITION BY RANGE (`a`)
1722 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1723 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1724 SELECT * FROM t1;
1725 a b
1726 1 Original from partition p0
1727 11 Original from partition p1
1728 12 Original from partition p1
1729 13 Original from partition p1
1730 14 Original from partition p1
1731 2 Original from partition p0
1732 21 Original from partition p1
1733 22 Original from partition p1
1734 23 Original from partition p1
1735 24 Original from partition p1
1736 3 Original from partition p0
1737 4 Original from partition p0
1738 DROP TABLE t1;
1739 SHOW CREATE TABLE t2;
1740 Table Create Table
1741 t2 CREATE TABLE `t2` (
1742 `a` int(11) DEFAULT NULL,
1743 `b` varchar(64) DEFAULT NULL
1744 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1745 SELECT * FROM t2;
1746 a b
1747 5 Original from table t2
1748 6 Original from table t2
1749 7 Original from table t2
1750 8 Original from table t2
1751 DROP TABLE t2;
1752 SET SESSION debug_dbug=@save_dbug;
1753 SET SESSION debug_dbug="+d,exchange_partition_fail_8";
1754 CREATE TABLE t2 (a INT, b VARCHAR(64));
1755 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1756 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1757 (PARTITION p0 VALUES LESS THAN (10),
1758 PARTITION p1 VALUES LESS THAN MAXVALUE);
1759 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1760 # d,exchange_partition_fail_8: BEFORE failure
1761 db.opt
1762 t1#P#p0.MYD
1763 t1#P#p0.MYI
1764 t1#P#p1.MYD
1765 t1#P#p1.MYI
1766 t1.frm
1767 t1.par
1768 t2.MYD
1769 t2.MYI
1770 t2.frm
1771 SHOW CREATE TABLE t1;
1772 Table Create Table
1773 t1 CREATE TABLE `t1` (
1774 `a` int(11) DEFAULT NULL,
1775 `b` varchar(64) DEFAULT NULL
1776 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1777 PARTITION BY RANGE (`a`)
1778 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1779 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1780 SELECT * FROM t1;
1781 a b
1782 1 Original from partition p0
1783 11 Original from partition p1
1784 12 Original from partition p1
1785 13 Original from partition p1
1786 14 Original from partition p1
1787 2 Original from partition p0
1788 21 Original from partition p1
1789 22 Original from partition p1
1790 23 Original from partition p1
1791 24 Original from partition p1
1792 3 Original from partition p0
1793 4 Original from partition p0
1794 SHOW CREATE TABLE t2;
1795 Table Create Table
1796 t2 CREATE TABLE `t2` (
1797 `a` int(11) DEFAULT NULL,
1798 `b` varchar(64) DEFAULT NULL
1799 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1800 SELECT * FROM t2;
1801 a b
1802 5 Original from table t2
1803 6 Original from table t2
1804 7 Original from table t2
1805 8 Original from table t2
1806 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1807 ERROR HY000: Error in DDL log
1808 # d,exchange_partition_fail_8: AFTER failure
1809 db.opt
1810 t1#P#p0.MYD
1811 t1#P#p0.MYI
1812 t1#P#p1.MYD
1813 t1#P#p1.MYI
1814 t1.frm
1815 t1.par
1816 t2.MYD
1817 t2.MYI
1818 t2.frm
1819 SHOW CREATE TABLE t1;
1820 Table Create Table
1821 t1 CREATE TABLE `t1` (
1822 `a` int(11) DEFAULT NULL,
1823 `b` varchar(64) DEFAULT NULL
1824 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1825 PARTITION BY RANGE (`a`)
1826 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1827 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1828 SELECT * FROM t1;
1829 a b
1830 1 Original from partition p0
1831 11 Original from partition p1
1832 12 Original from partition p1
1833 13 Original from partition p1
1834 14 Original from partition p1
1835 2 Original from partition p0
1836 21 Original from partition p1
1837 22 Original from partition p1
1838 23 Original from partition p1
1839 24 Original from partition p1
1840 3 Original from partition p0
1841 4 Original from partition p0
1842 DROP TABLE t1;
1843 SHOW CREATE TABLE t2;
1844 Table Create Table
1845 t2 CREATE TABLE `t2` (
1846 `a` int(11) DEFAULT NULL,
1847 `b` varchar(64) DEFAULT NULL
1848 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1849 SELECT * FROM t2;
1850 a b
1851 5 Original from table t2
1852 6 Original from table t2
1853 7 Original from table t2
1854 8 Original from table t2
1855 DROP TABLE t2;
1856 SET SESSION debug_dbug=@save_dbug;
1857 SET SESSION debug_dbug="+d,exchange_partition_fail_9";
1858 CREATE TABLE t2 (a INT, b VARCHAR(64));
1859 INSERT INTO t2 VALUES (5, "Original from table t2"), (6, "Original from table t2"), (7, "Original from table t2"), (8, "Original from table t2");
1860 CREATE TABLE t1 (a INT, b VARCHAR(64)) PARTITION BY RANGE (a)
1861 (PARTITION p0 VALUES LESS THAN (10),
1862 PARTITION p1 VALUES LESS THAN MAXVALUE);
1863 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"), (21, "Original from partition p1"), (22, "Original from partition p1"), (23, "Original from partition p1"), (24, "Original from partition p1");
1864 # d,exchange_partition_fail_9: BEFORE failure
1865 db.opt
1866 t1#P#p0.MYD
1867 t1#P#p0.MYI
1868 t1#P#p1.MYD
1869 t1#P#p1.MYI
1870 t1.frm
1871 t1.par
1872 t2.MYD
1873 t2.MYI
1874 t2.frm
1875 SHOW CREATE TABLE t1;
1876 Table Create Table
1877 t1 CREATE TABLE `t1` (
1878 `a` int(11) DEFAULT NULL,
1879 `b` varchar(64) DEFAULT NULL
1880 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1881 PARTITION BY RANGE (`a`)
1882 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1883 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1884 SELECT * FROM t1;
1885 a b
1886 1 Original from partition p0
1887 11 Original from partition p1
1888 12 Original from partition p1
1889 13 Original from partition p1
1890 14 Original from partition p1
1891 2 Original from partition p0
1892 21 Original from partition p1
1893 22 Original from partition p1
1894 23 Original from partition p1
1895 24 Original from partition p1
1896 3 Original from partition p0
1897 4 Original from partition p0
1898 SHOW CREATE TABLE t2;
1899 Table Create Table
1900 t2 CREATE TABLE `t2` (
1901 `a` int(11) DEFAULT NULL,
1902 `b` varchar(64) DEFAULT NULL
1903 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1904 SELECT * FROM t2;
1905 a b
1906 5 Original from table t2
1907 6 Original from table t2
1908 7 Original from table t2
1909 8 Original from table t2
1910 ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t2;
1911 ERROR HY000: Error in DDL log
1912 # d,exchange_partition_fail_9: AFTER failure
1913 db.opt
1914 t1#P#p0.MYD
1915 t1#P#p0.MYI
1916 t1#P#p1.MYD
1917 t1#P#p1.MYI
1918 t1.frm
1919 t1.par
1920 t2.MYD
1921 t2.MYI
1922 t2.frm
1923 SHOW CREATE TABLE t1;
1924 Table Create Table
1925 t1 CREATE TABLE `t1` (
1926 `a` int(11) DEFAULT NULL,
1927 `b` varchar(64) DEFAULT NULL
1928 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1929 PARTITION BY RANGE (`a`)
1930 (PARTITION `p0` VALUES LESS THAN (10) ENGINE = MyISAM,
1931 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
1932 SELECT * FROM t1;
1933 a b
1934 11 Original from partition p1
1935 12 Original from partition p1
1936 13 Original from partition p1
1937 14 Original from partition p1
1938 21 Original from partition p1
1939 22 Original from partition p1
1940 23 Original from partition p1
1941 24 Original from partition p1
1942 5 Original from table t2
1943 6 Original from table t2
1944 7 Original from table t2
1945 8 Original from table t2
1946 DROP TABLE t1;
1947 SHOW CREATE TABLE t2;
1948 Table Create Table
1949 t2 CREATE TABLE `t2` (
1950 `a` int(11) DEFAULT NULL,
1951 `b` varchar(64) DEFAULT NULL
1952 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1953 SELECT * FROM t2;
1954 a b
1955 1 Original from partition p0
1956 2 Original from partition p0
1957 3 Original from partition p0
1958 4 Original from partition p0
1959 DROP TABLE t2;
1960 SET SESSION debug_dbug=@save_dbug;
1961 #
1962 # MDEV-22165 CONVERT PARTITION: move in partition from existing table
1963 #
1964 set @save_dbug=@@debug_dbug;
1965 set session debug_dbug="+d,fail_convert_partition_1";
1966 create or replace table t2 (x int primary key);
1967 insert into t2 values (32), (42), (52);
1968 create or replace table t1 (x int primary key)
1969 partition by range(x) (
1970 partition p1 values less than (10),
1971 partition p2 values less than (20),
1972 partition p3 values less than (30));
1973 insert into t1 values (2), (12), (22);
1974 # d,fail_convert_partition_1: BEFORE failure
1975 db.opt
1976 t1#P#p1.MYD
1977 t1#P#p1.MYI
1978 t1#P#p2.MYD
1979 t1#P#p2.MYI
1980 t1#P#p3.MYD
1981 t1#P#p3.MYI
1982 t1.frm
1983 t1.par
1984 t2.MYD
1985 t2.MYI
1986 t2.frm
1987 SHOW CREATE TABLE t1;
1988 Table Create Table
1989 t1 CREATE TABLE `t1` (
1990 `x` int(11) NOT NULL,
1991 PRIMARY KEY (`x`)
1992 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1993 PARTITION BY RANGE (`x`)
1994 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
1995 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
1996 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
1997 SELECT * FROM t1;
1998 x
1999 12
2000 2
2001 22
2002 SHOW CREATE TABLE t2;
2003 Table Create Table
2004 t2 CREATE TABLE `t2` (
2005 `x` int(11) NOT NULL,
2006 PRIMARY KEY (`x`)
2007 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2008 SELECT * FROM t2;
2009 x
2010 32
2011 42
2012 52
2013 alter table t1 convert table t2 to partition pn values less than maxvalue;
2014 ERROR HY000: Unknown error
2015 # d,fail_convert_partition_1: AFTER failure
2016 db.opt
2017 t1#P#p1.MYD
2018 t1#P#p1.MYI
2019 t1#P#p2.MYD
2020 t1#P#p2.MYI
2021 t1#P#p3.MYD
2022 t1#P#p3.MYI
2023 t1.frm
2024 t1.par
2025 t2.MYD
2026 t2.MYI
2027 t2.frm
2028 SHOW CREATE TABLE t1;
2029 Table Create Table
2030 t1 CREATE TABLE `t1` (
2031 `x` int(11) NOT NULL,
2032 PRIMARY KEY (`x`)
2033 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2034 PARTITION BY RANGE (`x`)
2035 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2036 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2037 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2038 SELECT * FROM t1;
2039 x
2040 12
2041 2
2042 22
2043 DROP TABLE t1;
2044 SHOW CREATE TABLE t2;
2045 Table Create Table
2046 t2 CREATE TABLE `t2` (
2047 `x` int(11) NOT NULL,
2048 PRIMARY KEY (`x`)
2049 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2050 SELECT * FROM t2;
2051 x
2052 32
2053 42
2054 52
2055 DROP TABLE t2;
2056 set session debug_dbug=@save_dbug;
2057 set session debug_dbug="+d,fail_convert_partition_2";
2058 create or replace table t2 (x int primary key);
2059 insert into t2 values (32), (42), (52);
2060 create or replace table t1 (x int primary key)
2061 partition by range(x) (
2062 partition p1 values less than (10),
2063 partition p2 values less than (20),
2064 partition p3 values less than (30));
2065 insert into t1 values (2), (12), (22);
2066 # d,fail_convert_partition_2: BEFORE failure
2067 db.opt
2068 t1#P#p1.MYD
2069 t1#P#p1.MYI
2070 t1#P#p2.MYD
2071 t1#P#p2.MYI
2072 t1#P#p3.MYD
2073 t1#P#p3.MYI
2074 t1.frm
2075 t1.par
2076 t2.MYD
2077 t2.MYI
2078 t2.frm
2079 SHOW CREATE TABLE t1;
2080 Table Create Table
2081 t1 CREATE TABLE `t1` (
2082 `x` int(11) NOT NULL,
2083 PRIMARY KEY (`x`)
2084 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2085 PARTITION BY RANGE (`x`)
2086 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2087 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2088 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2089 SELECT * FROM t1;
2090 x
2091 12
2092 2
2093 22
2094 SHOW CREATE TABLE t2;
2095 Table Create Table
2096 t2 CREATE TABLE `t2` (
2097 `x` int(11) NOT NULL,
2098 PRIMARY KEY (`x`)
2099 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2100 SELECT * FROM t2;
2101 x
2102 32
2103 42
2104 52
2105 alter table t1 convert table t2 to partition pn values less than maxvalue;
2106 ERROR HY000: Unknown error
2107 # d,fail_convert_partition_2: AFTER failure
2108 db.opt
2109 t1#P#p1.MYD
2110 t1#P#p1.MYI
2111 t1#P#p2.MYD
2112 t1#P#p2.MYI
2113 t1#P#p3.MYD
2114 t1#P#p3.MYI
2115 t1.frm
2116 t1.par
2117 t2.MYD
2118 t2.MYI
2119 t2.frm
2120 SHOW CREATE TABLE t1;
2121 Table Create Table
2122 t1 CREATE TABLE `t1` (
2123 `x` int(11) NOT NULL,
2124 PRIMARY KEY (`x`)
2125 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2126 PARTITION BY RANGE (`x`)
2127 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2128 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2129 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2130 SELECT * FROM t1;
2131 x
2132 12
2133 2
2134 22
2135 DROP TABLE t1;
2136 SHOW CREATE TABLE t2;
2137 Table Create Table
2138 t2 CREATE TABLE `t2` (
2139 `x` int(11) NOT NULL,
2140 PRIMARY KEY (`x`)
2141 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2142 SELECT * FROM t2;
2143 x
2144 32
2145 42
2146 52
2147 DROP TABLE t2;
2148 set session debug_dbug=@save_dbug;
2149 set session debug_dbug="+d,fail_convert_partition_3";
2150 create or replace table t2 (x int primary key);
2151 insert into t2 values (32), (42), (52);
2152 create or replace table t1 (x int primary key)
2153 partition by range(x) (
2154 partition p1 values less than (10),
2155 partition p2 values less than (20),
2156 partition p3 values less than (30));
2157 insert into t1 values (2), (12), (22);
2158 # d,fail_convert_partition_3: BEFORE failure
2159 db.opt
2160 t1#P#p1.MYD
2161 t1#P#p1.MYI
2162 t1#P#p2.MYD
2163 t1#P#p2.MYI
2164 t1#P#p3.MYD
2165 t1#P#p3.MYI
2166 t1.frm
2167 t1.par
2168 t2.MYD
2169 t2.MYI
2170 t2.frm
2171 SHOW CREATE TABLE t1;
2172 Table Create Table
2173 t1 CREATE TABLE `t1` (
2174 `x` int(11) NOT NULL,
2175 PRIMARY KEY (`x`)
2176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2177 PARTITION BY RANGE (`x`)
2178 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2179 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2180 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2181 SELECT * FROM t1;
2182 x
2183 12
2184 2
2185 22
2186 SHOW CREATE TABLE t2;
2187 Table Create Table
2188 t2 CREATE TABLE `t2` (
2189 `x` int(11) NOT NULL,
2190 PRIMARY KEY (`x`)
2191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2192 SELECT * FROM t2;
2193 x
2194 32
2195 42
2196 52
2197 alter table t1 convert table t2 to partition pn values less than maxvalue;
2198 ERROR HY000: Unknown error
2199 # d,fail_convert_partition_3: AFTER failure
2200 db.opt
2201 t1#P#p1.MYD
2202 t1#P#p1.MYI
2203 t1#P#p2.MYD
2204 t1#P#p2.MYI
2205 t1#P#p3.MYD
2206 t1#P#p3.MYI
2207 t1.frm
2208 t1.par
2209 t2.MYD
2210 t2.MYI
2211 t2.frm
2212 SHOW CREATE TABLE t1;
2213 Table Create Table
2214 t1 CREATE TABLE `t1` (
2215 `x` int(11) NOT NULL,
2216 PRIMARY KEY (`x`)
2217 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2218 PARTITION BY RANGE (`x`)
2219 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2220 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2221 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2222 SELECT * FROM t1;
2223 x
2224 12
2225 2
2226 22
2227 DROP TABLE t1;
2228 SHOW CREATE TABLE t2;
2229 Table Create Table
2230 t2 CREATE TABLE `t2` (
2231 `x` int(11) NOT NULL,
2232 PRIMARY KEY (`x`)
2233 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2234 SELECT * FROM t2;
2235 x
2236 32
2237 42
2238 52
2239 DROP TABLE t2;
2240 set session debug_dbug=@save_dbug;
2241 set session debug_dbug="+d,fail_convert_partition_4";
2242 create or replace table t2 (x int primary key);
2243 insert into t2 values (32), (42), (52);
2244 create or replace table t1 (x int primary key)
2245 partition by range(x) (
2246 partition p1 values less than (10),
2247 partition p2 values less than (20),
2248 partition p3 values less than (30));
2249 insert into t1 values (2), (12), (22);
2250 # d,fail_convert_partition_4: BEFORE failure
2251 db.opt
2252 t1#P#p1.MYD
2253 t1#P#p1.MYI
2254 t1#P#p2.MYD
2255 t1#P#p2.MYI
2256 t1#P#p3.MYD
2257 t1#P#p3.MYI
2258 t1.frm
2259 t1.par
2260 t2.MYD
2261 t2.MYI
2262 t2.frm
2263 SHOW CREATE TABLE t1;
2264 Table Create Table
2265 t1 CREATE TABLE `t1` (
2266 `x` int(11) NOT NULL,
2267 PRIMARY KEY (`x`)
2268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2269 PARTITION BY RANGE (`x`)
2270 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2271 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2272 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2273 SELECT * FROM t1;
2274 x
2275 12
2276 2
2277 22
2278 SHOW CREATE TABLE t2;
2279 Table Create Table
2280 t2 CREATE TABLE `t2` (
2281 `x` int(11) NOT NULL,
2282 PRIMARY KEY (`x`)
2283 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2284 SELECT * FROM t2;
2285 x
2286 32
2287 42
2288 52
2289 alter table t1 convert table t2 to partition pn values less than maxvalue;
2290 ERROR HY000: Unknown error
2291 # d,fail_convert_partition_4: AFTER failure
2292 db.opt
2293 t1#P#p1.MYD
2294 t1#P#p1.MYI
2295 t1#P#p2.MYD
2296 t1#P#p2.MYI
2297 t1#P#p3.MYD
2298 t1#P#p3.MYI
2299 t1.frm
2300 t1.par
2301 t2.MYD
2302 t2.MYI
2303 t2.frm
2304 SHOW CREATE TABLE t1;
2305 Table Create Table
2306 t1 CREATE TABLE `t1` (
2307 `x` int(11) NOT NULL,
2308 PRIMARY KEY (`x`)
2309 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2310 PARTITION BY RANGE (`x`)
2311 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2312 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2313 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2314 SELECT * FROM t1;
2315 x
2316 12
2317 2
2318 22
2319 DROP TABLE t1;
2320 SHOW CREATE TABLE t2;
2321 Table Create Table
2322 t2 CREATE TABLE `t2` (
2323 `x` int(11) NOT NULL,
2324 PRIMARY KEY (`x`)
2325 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2326 SELECT * FROM t2;
2327 x
2328 32
2329 42
2330 52
2331 DROP TABLE t2;
2332 set session debug_dbug=@save_dbug;
2333 set session debug_dbug="+d,fail_convert_partition_5";
2334 create or replace table t2 (x int primary key);
2335 insert into t2 values (32), (42), (52);
2336 create or replace table t1 (x int primary key)
2337 partition by range(x) (
2338 partition p1 values less than (10),
2339 partition p2 values less than (20),
2340 partition p3 values less than (30));
2341 insert into t1 values (2), (12), (22);
2342 # d,fail_convert_partition_5: BEFORE failure
2343 db.opt
2344 t1#P#p1.MYD
2345 t1#P#p1.MYI
2346 t1#P#p2.MYD
2347 t1#P#p2.MYI
2348 t1#P#p3.MYD
2349 t1#P#p3.MYI
2350 t1.frm
2351 t1.par
2352 t2.MYD
2353 t2.MYI
2354 t2.frm
2355 SHOW CREATE TABLE t1;
2356 Table Create Table
2357 t1 CREATE TABLE `t1` (
2358 `x` int(11) NOT NULL,
2359 PRIMARY KEY (`x`)
2360 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2361 PARTITION BY RANGE (`x`)
2362 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2363 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2364 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2365 SELECT * FROM t1;
2366 x
2367 12
2368 2
2369 22
2370 SHOW CREATE TABLE t2;
2371 Table Create Table
2372 t2 CREATE TABLE `t2` (
2373 `x` int(11) NOT NULL,
2374 PRIMARY KEY (`x`)
2375 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2376 SELECT * FROM t2;
2377 x
2378 32
2379 42
2380 52
2381 alter table t1 convert table t2 to partition pn values less than maxvalue;
2382 ERROR HY000: Unknown error
2383 # d,fail_convert_partition_5: AFTER failure
2384 db.opt
2385 t1#P#p1.MYD
2386 t1#P#p1.MYI
2387 t1#P#p2.MYD
2388 t1#P#p2.MYI
2389 t1#P#p3.MYD
2390 t1#P#p3.MYI
2391 t1.frm
2392 t1.par
2393 t2.MYD
2394 t2.MYI
2395 t2.frm
2396 SHOW CREATE TABLE t1;
2397 Table Create Table
2398 t1 CREATE TABLE `t1` (
2399 `x` int(11) NOT NULL,
2400 PRIMARY KEY (`x`)
2401 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2402 PARTITION BY RANGE (`x`)
2403 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2404 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2405 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2406 SELECT * FROM t1;
2407 x
2408 12
2409 2
2410 22
2411 DROP TABLE t1;
2412 SHOW CREATE TABLE t2;
2413 Table Create Table
2414 t2 CREATE TABLE `t2` (
2415 `x` int(11) NOT NULL,
2416 PRIMARY KEY (`x`)
2417 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2418 SELECT * FROM t2;
2419 x
2420 32
2421 42
2422 52
2423 DROP TABLE t2;
2424 set session debug_dbug=@save_dbug;
2425 set session debug_dbug="+d,fail_convert_partition_6";
2426 create or replace table t2 (x int primary key);
2427 insert into t2 values (32), (42), (52);
2428 create or replace table t1 (x int primary key)
2429 partition by range(x) (
2430 partition p1 values less than (10),
2431 partition p2 values less than (20),
2432 partition p3 values less than (30));
2433 insert into t1 values (2), (12), (22);
2434 # d,fail_convert_partition_6: BEFORE failure
2435 db.opt
2436 t1#P#p1.MYD
2437 t1#P#p1.MYI
2438 t1#P#p2.MYD
2439 t1#P#p2.MYI
2440 t1#P#p3.MYD
2441 t1#P#p3.MYI
2442 t1.frm
2443 t1.par
2444 t2.MYD
2445 t2.MYI
2446 t2.frm
2447 SHOW CREATE TABLE t1;
2448 Table Create Table
2449 t1 CREATE TABLE `t1` (
2450 `x` int(11) NOT NULL,
2451 PRIMARY KEY (`x`)
2452 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2453 PARTITION BY RANGE (`x`)
2454 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2455 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2456 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2457 SELECT * FROM t1;
2458 x
2459 12
2460 2
2461 22
2462 SHOW CREATE TABLE t2;
2463 Table Create Table
2464 t2 CREATE TABLE `t2` (
2465 `x` int(11) NOT NULL,
2466 PRIMARY KEY (`x`)
2467 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2468 SELECT * FROM t2;
2469 x
2470 32
2471 42
2472 52
2473 alter table t1 convert table t2 to partition pn values less than maxvalue;
2474 ERROR HY000: Unknown error
2475 # d,fail_convert_partition_6: AFTER failure
2476 db.opt
2477 t1#P#p1.MYD
2478 t1#P#p1.MYI
2479 t1#P#p2.MYD
2480 t1#P#p2.MYI
2481 t1#P#p3.MYD
2482 t1#P#p3.MYI
2483 t1.frm
2484 t1.par
2485 t2.MYD
2486 t2.MYI
2487 t2.frm
2488 SHOW CREATE TABLE t1;
2489 Table Create Table
2490 t1 CREATE TABLE `t1` (
2491 `x` int(11) NOT NULL,
2492 PRIMARY KEY (`x`)
2493 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2494 PARTITION BY RANGE (`x`)
2495 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2496 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2497 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2498 SELECT * FROM t1;
2499 x
2500 12
2501 2
2502 22
2503 DROP TABLE t1;
2504 SHOW CREATE TABLE t2;
2505 Table Create Table
2506 t2 CREATE TABLE `t2` (
2507 `x` int(11) NOT NULL,
2508 PRIMARY KEY (`x`)
2509 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2510 SELECT * FROM t2;
2511 x
2512 32
2513 42
2514 52
2515 DROP TABLE t2;
2516 set session debug_dbug=@save_dbug;
2517 set session debug_dbug="+d,fail_convert_partition_7";
2518 create or replace table t2 (x int primary key);
2519 insert into t2 values (32), (42), (52);
2520 create or replace table t1 (x int primary key)
2521 partition by range(x) (
2522 partition p1 values less than (10),
2523 partition p2 values less than (20),
2524 partition p3 values less than (30));
2525 insert into t1 values (2), (12), (22);
2526 # d,fail_convert_partition_7: BEFORE failure
2527 db.opt
2528 t1#P#p1.MYD
2529 t1#P#p1.MYI
2530 t1#P#p2.MYD
2531 t1#P#p2.MYI
2532 t1#P#p3.MYD
2533 t1#P#p3.MYI
2534 t1.frm
2535 t1.par
2536 t2.MYD
2537 t2.MYI
2538 t2.frm
2539 SHOW CREATE TABLE t1;
2540 Table Create Table
2541 t1 CREATE TABLE `t1` (
2542 `x` int(11) NOT NULL,
2543 PRIMARY KEY (`x`)
2544 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2545 PARTITION BY RANGE (`x`)
2546 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2547 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2548 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2549 SELECT * FROM t1;
2550 x
2551 12
2552 2
2553 22
2554 SHOW CREATE TABLE t2;
2555 Table Create Table
2556 t2 CREATE TABLE `t2` (
2557 `x` int(11) NOT NULL,
2558 PRIMARY KEY (`x`)
2559 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2560 SELECT * FROM t2;
2561 x
2562 32
2563 42
2564 52
2565 alter table t1 convert table t2 to partition pn values less than maxvalue;
2566 ERROR HY000: Unknown error
2567 # d,fail_convert_partition_7: AFTER failure
2568 db.opt
2569 t1#P#p1.MYD
2570 t1#P#p1.MYI
2571 t1#P#p2.MYD
2572 t1#P#p2.MYI
2573 t1#P#p3.MYD
2574 t1#P#p3.MYI
2575 t1.frm
2576 t1.par
2577 t2.MYD
2578 t2.MYI
2579 t2.frm
2580 SHOW CREATE TABLE t1;
2581 Table Create Table
2582 t1 CREATE TABLE `t1` (
2583 `x` int(11) NOT NULL,
2584 PRIMARY KEY (`x`)
2585 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2586 PARTITION BY RANGE (`x`)
2587 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2588 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2589 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2590 SELECT * FROM t1;
2591 x
2592 12
2593 2
2594 22
2595 DROP TABLE t1;
2596 SHOW CREATE TABLE t2;
2597 Table Create Table
2598 t2 CREATE TABLE `t2` (
2599 `x` int(11) NOT NULL,
2600 PRIMARY KEY (`x`)
2601 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2602 SELECT * FROM t2;
2603 x
2604 32
2605 42
2606 52
2607 DROP TABLE t2;
2608 set session debug_dbug=@save_dbug;
2609 set session debug_dbug="+d,fail_convert_partition_8";
2610 create or replace table t2 (x int primary key);
2611 insert into t2 values (32), (42), (52);
2612 create or replace table t1 (x int primary key)
2613 partition by range(x) (
2614 partition p1 values less than (10),
2615 partition p2 values less than (20),
2616 partition p3 values less than (30));
2617 insert into t1 values (2), (12), (22);
2618 # d,fail_convert_partition_8: BEFORE failure
2619 db.opt
2620 t1#P#p1.MYD
2621 t1#P#p1.MYI
2622 t1#P#p2.MYD
2623 t1#P#p2.MYI
2624 t1#P#p3.MYD
2625 t1#P#p3.MYI
2626 t1.frm
2627 t1.par
2628 t2.MYD
2629 t2.MYI
2630 t2.frm
2631 SHOW CREATE TABLE t1;
2632 Table Create Table
2633 t1 CREATE TABLE `t1` (
2634 `x` int(11) NOT NULL,
2635 PRIMARY KEY (`x`)
2636 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2637 PARTITION BY RANGE (`x`)
2638 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2639 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2640 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2641 SELECT * FROM t1;
2642 x
2643 12
2644 2
2645 22
2646 SHOW CREATE TABLE t2;
2647 Table Create Table
2648 t2 CREATE TABLE `t2` (
2649 `x` int(11) NOT NULL,
2650 PRIMARY KEY (`x`)
2651 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2652 SELECT * FROM t2;
2653 x
2654 32
2655 42
2656 52
2657 alter table t1 convert table t2 to partition pn values less than maxvalue;
2658 ERROR HY000: Unknown error
2659 # d,fail_convert_partition_8: AFTER failure
2660 db.opt
2661 t1#P#p1.MYD
2662 t1#P#p1.MYI
2663 t1#P#p2.MYD
2664 t1#P#p2.MYI
2665 t1#P#p3.MYD
2666 t1#P#p3.MYI
2667 t1.frm
2668 t1.par
2669 t2.MYD
2670 t2.MYI
2671 t2.frm
2672 SHOW CREATE TABLE t1;
2673 Table Create Table
2674 t1 CREATE TABLE `t1` (
2675 `x` int(11) NOT NULL,
2676 PRIMARY KEY (`x`)
2677 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2678 PARTITION BY RANGE (`x`)
2679 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2680 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2681 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2682 SELECT * FROM t1;
2683 x
2684 12
2685 2
2686 22
2687 DROP TABLE t1;
2688 SHOW CREATE TABLE t2;
2689 Table Create Table
2690 t2 CREATE TABLE `t2` (
2691 `x` int(11) NOT NULL,
2692 PRIMARY KEY (`x`)
2693 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2694 SELECT * FROM t2;
2695 x
2696 32
2697 42
2698 52
2699 DROP TABLE t2;
2700 set session debug_dbug=@save_dbug;
2701 set session debug_dbug="+d,fail_convert_partition_9";
2702 create or replace table t2 (x int primary key);
2703 insert into t2 values (32), (42), (52);
2704 create or replace table t1 (x int primary key)
2705 partition by range(x) (
2706 partition p1 values less than (10),
2707 partition p2 values less than (20),
2708 partition p3 values less than (30));
2709 insert into t1 values (2), (12), (22);
2710 # d,fail_convert_partition_9: BEFORE failure
2711 db.opt
2712 t1#P#p1.MYD
2713 t1#P#p1.MYI
2714 t1#P#p2.MYD
2715 t1#P#p2.MYI
2716 t1#P#p3.MYD
2717 t1#P#p3.MYI
2718 t1.frm
2719 t1.par
2720 t2.MYD
2721 t2.MYI
2722 t2.frm
2723 SHOW CREATE TABLE t1;
2724 Table Create Table
2725 t1 CREATE TABLE `t1` (
2726 `x` int(11) NOT NULL,
2727 PRIMARY KEY (`x`)
2728 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2729 PARTITION BY RANGE (`x`)
2730 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2731 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2732 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2733 SELECT * FROM t1;
2734 x
2735 12
2736 2
2737 22
2738 SHOW CREATE TABLE t2;
2739 Table Create Table
2740 t2 CREATE TABLE `t2` (
2741 `x` int(11) NOT NULL,
2742 PRIMARY KEY (`x`)
2743 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2744 SELECT * FROM t2;
2745 x
2746 32
2747 42
2748 52
2749 alter table t1 convert table t2 to partition pn values less than maxvalue;
2750 ERROR HY000: Unknown error
2751 # d,fail_convert_partition_9: AFTER failure
2752 db.opt
2753 t1#P#p1.MYD
2754 t1#P#p1.MYI
2755 t1#P#p2.MYD
2756 t1#P#p2.MYI
2757 t1#P#p3.MYD
2758 t1#P#p3.MYI
2759 t1.frm
2760 t1.par
2761 t2.MYD
2762 t2.MYI
2763 t2.frm
2764 SHOW CREATE TABLE t1;
2765 Table Create Table
2766 t1 CREATE TABLE `t1` (
2767 `x` int(11) NOT NULL,
2768 PRIMARY KEY (`x`)
2769 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2770 PARTITION BY RANGE (`x`)
2771 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2772 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2773 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2774 SELECT * FROM t1;
2775 x
2776 12
2777 2
2778 22
2779 DROP TABLE t1;
2780 SHOW CREATE TABLE t2;
2781 Table Create Table
2782 t2 CREATE TABLE `t2` (
2783 `x` int(11) NOT NULL,
2784 PRIMARY KEY (`x`)
2785 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2786 SELECT * FROM t2;
2787 x
2788 32
2789 42
2790 52
2791 DROP TABLE t2;
2792 set session debug_dbug=@save_dbug;
2793 set session debug_dbug="+d,fail_convert_partition_11";
2794 create or replace table t2 (x int primary key);
2795 insert into t2 values (32), (42), (52);
2796 create or replace table t1 (x int primary key)
2797 partition by range(x) (
2798 partition p1 values less than (10),
2799 partition p2 values less than (20),
2800 partition p3 values less than (30));
2801 insert into t1 values (2), (12), (22);
2802 # d,fail_convert_partition_11: BEFORE failure
2803 db.opt
2804 t1#P#p1.MYD
2805 t1#P#p1.MYI
2806 t1#P#p2.MYD
2807 t1#P#p2.MYI
2808 t1#P#p3.MYD
2809 t1#P#p3.MYI
2810 t1.frm
2811 t1.par
2812 t2.MYD
2813 t2.MYI
2814 t2.frm
2815 SHOW CREATE TABLE t1;
2816 Table Create Table
2817 t1 CREATE TABLE `t1` (
2818 `x` int(11) NOT NULL,
2819 PRIMARY KEY (`x`)
2820 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2821 PARTITION BY RANGE (`x`)
2822 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2823 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2824 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM)
2825 SELECT * FROM t1;
2826 x
2827 12
2828 2
2829 22
2830 SHOW CREATE TABLE t2;
2831 Table Create Table
2832 t2 CREATE TABLE `t2` (
2833 `x` int(11) NOT NULL,
2834 PRIMARY KEY (`x`)
2835 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2836 SELECT * FROM t2;
2837 x
2838 32
2839 42
2840 52
2841 alter table t1 convert table t2 to partition pn values less than maxvalue;
2842 ERROR HY000: Unknown error
2843 # d,fail_convert_partition_11: AFTER failure
2844 db.opt
2845 t1#P#p1.MYD
2846 t1#P#p1.MYI
2847 t1#P#p2.MYD
2848 t1#P#p2.MYI
2849 t1#P#p3.MYD
2850 t1#P#p3.MYI
2851 t1#P#pn.MYD
2852 t1#P#pn.MYI
2853 t1.frm
2854 t1.par
2855 SHOW CREATE TABLE t1;
2856 Table Create Table
2857 t1 CREATE TABLE `t1` (
2858 `x` int(11) NOT NULL,
2859 PRIMARY KEY (`x`)
2860 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2861 PARTITION BY RANGE (`x`)
2862 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2863 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2864 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
2865 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
2866 SELECT * FROM t1;
2867 x
2868 12
2869 2
2870 22
2871 32
2872 42
2873 52
2874 DROP TABLE t1;
2875 SHOW CREATE TABLE t2;
2876 SELECT * FROM t2;
2877 DROP TABLE t2;
2878 set session debug_dbug=@save_dbug;
2879 #
2880 # MDEV-22166 CONVERT PARTITION: move out partition into a table
2881 #
2882 set @save_dbug=@@debug_dbug;
2883 set session debug_dbug="+d,fail_create_before_create_frm";
2884 create or replace table t1 (x int primary key)
2885 partition by range(x) (
2886 partition p1 values less than (10),
2887 partition p2 values less than (20),
2888 partition p3 values less than (30),
2889 partition p4 values less than (40),
2890 partition p5 values less than (50),
2891 partition pn values less than maxvalue);
2892 insert into t1 values (2), (12), (22), (32), (42), (52);
2893 # d,fail_create_before_create_frm: BEFORE failure
2894 db.opt
2895 t1#P#p1.MYD
2896 t1#P#p1.MYI
2897 t1#P#p2.MYD
2898 t1#P#p2.MYI
2899 t1#P#p3.MYD
2900 t1#P#p3.MYI
2901 t1#P#p4.MYD
2902 t1#P#p4.MYI
2903 t1#P#p5.MYD
2904 t1#P#p5.MYI
2905 t1#P#pn.MYD
2906 t1#P#pn.MYI
2907 t1.frm
2908 t1.par
2909 SHOW CREATE TABLE t1;
2910 Table Create Table
2911 t1 CREATE TABLE `t1` (
2912 `x` int(11) NOT NULL,
2913 PRIMARY KEY (`x`)
2914 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2915 PARTITION BY RANGE (`x`)
2916 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2917 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2918 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
2919 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
2920 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
2921 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
2922 SELECT * FROM t1;
2923 x
2924 12
2925 2
2926 22
2927 32
2928 42
2929 52
2930 alter table t1 convert partition p2 to table tp2;
2931 ERROR HY000: Unknown error
2932 # d,fail_create_before_create_frm: AFTER failure
2933 db.opt
2934 t1#P#p1.MYD
2935 t1#P#p1.MYI
2936 t1#P#p2.MYD
2937 t1#P#p2.MYI
2938 t1#P#p3.MYD
2939 t1#P#p3.MYI
2940 t1#P#p4.MYD
2941 t1#P#p4.MYI
2942 t1#P#p5.MYD
2943 t1#P#p5.MYI
2944 t1#P#pn.MYD
2945 t1#P#pn.MYI
2946 t1.frm
2947 t1.par
2948 SHOW CREATE TABLE t1;
2949 Table Create Table
2950 t1 CREATE TABLE `t1` (
2951 `x` int(11) NOT NULL,
2952 PRIMARY KEY (`x`)
2953 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
2954 PARTITION BY RANGE (`x`)
2955 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
2956 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
2957 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
2958 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
2959 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
2960 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
2961 SELECT * FROM t1;
2962 x
2963 12
2964 2
2965 22
2966 32
2967 42
2968 52
2969 DROP TABLE t1;
2970 create or replace table t1 (x int primary key)
2971 partition by range(x) (
2972 partition p1 values less than (10),
2973 partition p2 values less than (20),
2974 partition p3 values less than (30),
2975 partition p4 values less than (40),
2976 partition p5 values less than (50),
2977 partition pn values less than maxvalue);
2978 insert into t1 values (2), (12), (22), (32), (42), (52);
2979 # d,fail_create_before_create_frm: BEFORE failure (under LOCK TABLE)
2980 db.opt
2981 t1#P#p1.MYD
2982 t1#P#p1.MYI
2983 t1#P#p2.MYD
2984 t1#P#p2.MYI
2985 t1#P#p3.MYD
2986 t1#P#p3.MYI
2987 t1#P#p4.MYD
2988 t1#P#p4.MYI
2989 t1#P#p5.MYD
2990 t1#P#p5.MYI
2991 t1#P#pn.MYD
2992 t1#P#pn.MYI
2993 t1.frm
2994 t1.par
2995 SHOW CREATE TABLE t1;
2996 Table Create Table
2997 t1 CREATE TABLE `t1` (
2998 `x` int(11) NOT NULL,
2999 PRIMARY KEY (`x`)
3000 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3001 PARTITION BY RANGE (`x`)
3002 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3003 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3004 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3005 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3006 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3007 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3008 SELECT * FROM t1;
3009 x
3010 12
3011 2
3012 22
3013 32
3014 42
3015 52
3016 LOCK TABLE t1 WRITE;
3017 alter table t1 convert partition p2 to table tp2;
3018 ERROR HY000: Unknown error
3019 # d,fail_create_before_create_frm: AFTER failure (under LOCK TABLE)
3020 db.opt
3021 t1#P#p1.MYD
3022 t1#P#p1.MYI
3023 t1#P#p2.MYD
3024 t1#P#p2.MYI
3025 t1#P#p3.MYD
3026 t1#P#p3.MYI
3027 t1#P#p4.MYD
3028 t1#P#p4.MYI
3029 t1#P#p5.MYD
3030 t1#P#p5.MYI
3031 t1#P#pn.MYD
3032 t1#P#pn.MYI
3033 t1.frm
3034 t1.par
3035 SHOW CREATE TABLE t1;
3036 Table Create Table
3037 t1 CREATE TABLE `t1` (
3038 `x` int(11) NOT NULL,
3039 PRIMARY KEY (`x`)
3040 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3041 PARTITION BY RANGE (`x`)
3042 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3043 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3044 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3045 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3046 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3047 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3048 SELECT * FROM t1;
3049 x
3050 12
3051 2
3052 22
3053 32
3054 42
3055 52
3056 UNLOCK TABLES;
3057 DROP TABLE t1;
3058 set session debug_dbug=@save_dbug;
3059 set session debug_dbug="+d,fail_alter_partition_after_write_frm";
3060 create or replace table t1 (x int primary key)
3061 partition by range(x) (
3062 partition p1 values less than (10),
3063 partition p2 values less than (20),
3064 partition p3 values less than (30),
3065 partition p4 values less than (40),
3066 partition p5 values less than (50),
3067 partition pn values less than maxvalue);
3068 insert into t1 values (2), (12), (22), (32), (42), (52);
3069 # d,fail_alter_partition_after_write_frm: BEFORE failure
3070 db.opt
3071 t1#P#p1.MYD
3072 t1#P#p1.MYI
3073 t1#P#p2.MYD
3074 t1#P#p2.MYI
3075 t1#P#p3.MYD
3076 t1#P#p3.MYI
3077 t1#P#p4.MYD
3078 t1#P#p4.MYI
3079 t1#P#p5.MYD
3080 t1#P#p5.MYI
3081 t1#P#pn.MYD
3082 t1#P#pn.MYI
3083 t1.frm
3084 t1.par
3085 SHOW CREATE TABLE t1;
3086 Table Create Table
3087 t1 CREATE TABLE `t1` (
3088 `x` int(11) NOT NULL,
3089 PRIMARY KEY (`x`)
3090 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3091 PARTITION BY RANGE (`x`)
3092 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3093 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3094 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3095 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3096 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3097 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3098 SELECT * FROM t1;
3099 x
3100 12
3101 2
3102 22
3103 32
3104 42
3105 52
3106 alter table t1 convert partition p2 to table tp2;
3107 ERROR HY000: Unknown error
3108 # d,fail_alter_partition_after_write_frm: AFTER failure
3109 db.opt
3110 t1#P#p1.MYD
3111 t1#P#p1.MYI
3112 t1#P#p2.MYD
3113 t1#P#p2.MYI
3114 t1#P#p3.MYD
3115 t1#P#p3.MYI
3116 t1#P#p4.MYD
3117 t1#P#p4.MYI
3118 t1#P#p5.MYD
3119 t1#P#p5.MYI
3120 t1#P#pn.MYD
3121 t1#P#pn.MYI
3122 t1.frm
3123 t1.par
3124 SHOW CREATE TABLE t1;
3125 Table Create Table
3126 t1 CREATE TABLE `t1` (
3127 `x` int(11) NOT NULL,
3128 PRIMARY KEY (`x`)
3129 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3130 PARTITION BY RANGE (`x`)
3131 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3132 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3133 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3134 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3135 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3136 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3137 SELECT * FROM t1;
3138 x
3139 12
3140 2
3141 22
3142 32
3143 42
3144 52
3145 DROP TABLE t1;
3146 create or replace table t1 (x int primary key)
3147 partition by range(x) (
3148 partition p1 values less than (10),
3149 partition p2 values less than (20),
3150 partition p3 values less than (30),
3151 partition p4 values less than (40),
3152 partition p5 values less than (50),
3153 partition pn values less than maxvalue);
3154 insert into t1 values (2), (12), (22), (32), (42), (52);
3155 # d,fail_alter_partition_after_write_frm: BEFORE failure (under LOCK TABLE)
3156 db.opt
3157 t1#P#p1.MYD
3158 t1#P#p1.MYI
3159 t1#P#p2.MYD
3160 t1#P#p2.MYI
3161 t1#P#p3.MYD
3162 t1#P#p3.MYI
3163 t1#P#p4.MYD
3164 t1#P#p4.MYI
3165 t1#P#p5.MYD
3166 t1#P#p5.MYI
3167 t1#P#pn.MYD
3168 t1#P#pn.MYI
3169 t1.frm
3170 t1.par
3171 SHOW CREATE TABLE t1;
3172 Table Create Table
3173 t1 CREATE TABLE `t1` (
3174 `x` int(11) NOT NULL,
3175 PRIMARY KEY (`x`)
3176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3177 PARTITION BY RANGE (`x`)
3178 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3179 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3180 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3181 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3182 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3183 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3184 SELECT * FROM t1;
3185 x
3186 12
3187 2
3188 22
3189 32
3190 42
3191 52
3192 LOCK TABLE t1 WRITE;
3193 alter table t1 convert partition p2 to table tp2;
3194 ERROR HY000: Unknown error
3195 # d,fail_alter_partition_after_write_frm: AFTER failure (under LOCK TABLE)
3196 db.opt
3197 t1#P#p1.MYD
3198 t1#P#p1.MYI
3199 t1#P#p2.MYD
3200 t1#P#p2.MYI
3201 t1#P#p3.MYD
3202 t1#P#p3.MYI
3203 t1#P#p4.MYD
3204 t1#P#p4.MYI
3205 t1#P#p5.MYD
3206 t1#P#p5.MYI
3207 t1#P#pn.MYD
3208 t1#P#pn.MYI
3209 t1.frm
3210 t1.par
3211 SHOW CREATE TABLE t1;
3212 Table Create Table
3213 t1 CREATE TABLE `t1` (
3214 `x` int(11) NOT NULL,
3215 PRIMARY KEY (`x`)
3216 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3217 PARTITION BY RANGE (`x`)
3218 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3219 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3220 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3221 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3222 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3223 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3224 SELECT * FROM t1;
3225 x
3226 12
3227 2
3228 22
3229 32
3230 42
3231 52
3232 UNLOCK TABLES;
3233 DROP TABLE t1;
3234 set session debug_dbug=@save_dbug;
3235 set session debug_dbug="+d,error_convert_partition_00";
3236 create or replace table t1 (x int primary key)
3237 partition by range(x) (
3238 partition p1 values less than (10),
3239 partition p2 values less than (20),
3240 partition p3 values less than (30),
3241 partition p4 values less than (40),
3242 partition p5 values less than (50),
3243 partition pn values less than maxvalue);
3244 insert into t1 values (2), (12), (22), (32), (42), (52);
3245 # d,error_convert_partition_00: BEFORE failure
3246 db.opt
3247 t1#P#p1.MYD
3248 t1#P#p1.MYI
3249 t1#P#p2.MYD
3250 t1#P#p2.MYI
3251 t1#P#p3.MYD
3252 t1#P#p3.MYI
3253 t1#P#p4.MYD
3254 t1#P#p4.MYI
3255 t1#P#p5.MYD
3256 t1#P#p5.MYI
3257 t1#P#pn.MYD
3258 t1#P#pn.MYI
3259 t1.frm
3260 t1.par
3261 SHOW CREATE TABLE t1;
3262 Table Create Table
3263 t1 CREATE TABLE `t1` (
3264 `x` int(11) NOT NULL,
3265 PRIMARY KEY (`x`)
3266 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3267 PARTITION BY RANGE (`x`)
3268 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3269 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3270 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3271 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3272 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3273 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3274 SELECT * FROM t1;
3275 x
3276 12
3277 2
3278 22
3279 32
3280 42
3281 52
3282 alter table t1 convert partition p2 to table tp2;
3283 ERROR HY000: Error on rename of './test/t1#P#p2' to './test/tp2' (errno: 0 "Internal error/check (Not system error)")
3284 # d,error_convert_partition_00: AFTER failure
3285 db.opt
3286 t1#P#p1.MYD
3287 t1#P#p1.MYI
3288 t1#P#p2.MYD
3289 t1#P#p2.MYI
3290 t1#P#p3.MYD
3291 t1#P#p3.MYI
3292 t1#P#p4.MYD
3293 t1#P#p4.MYI
3294 t1#P#p5.MYD
3295 t1#P#p5.MYI
3296 t1#P#pn.MYD
3297 t1#P#pn.MYI
3298 t1.frm
3299 t1.par
3300 SHOW CREATE TABLE t1;
3301 Table Create Table
3302 t1 CREATE TABLE `t1` (
3303 `x` int(11) NOT NULL,
3304 PRIMARY KEY (`x`)
3305 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3306 PARTITION BY RANGE (`x`)
3307 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3308 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3309 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3310 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3311 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3312 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3313 SELECT * FROM t1;
3314 x
3315 12
3316 2
3317 22
3318 32
3319 42
3320 52
3321 DROP TABLE t1;
3322 create or replace table t1 (x int primary key)
3323 partition by range(x) (
3324 partition p1 values less than (10),
3325 partition p2 values less than (20),
3326 partition p3 values less than (30),
3327 partition p4 values less than (40),
3328 partition p5 values less than (50),
3329 partition pn values less than maxvalue);
3330 insert into t1 values (2), (12), (22), (32), (42), (52);
3331 # d,error_convert_partition_00: BEFORE failure (under LOCK TABLE)
3332 db.opt
3333 t1#P#p1.MYD
3334 t1#P#p1.MYI
3335 t1#P#p2.MYD
3336 t1#P#p2.MYI
3337 t1#P#p3.MYD
3338 t1#P#p3.MYI
3339 t1#P#p4.MYD
3340 t1#P#p4.MYI
3341 t1#P#p5.MYD
3342 t1#P#p5.MYI
3343 t1#P#pn.MYD
3344 t1#P#pn.MYI
3345 t1.frm
3346 t1.par
3347 SHOW CREATE TABLE t1;
3348 Table Create Table
3349 t1 CREATE TABLE `t1` (
3350 `x` int(11) NOT NULL,
3351 PRIMARY KEY (`x`)
3352 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3353 PARTITION BY RANGE (`x`)
3354 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3355 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3356 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3357 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3358 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3359 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3360 SELECT * FROM t1;
3361 x
3362 12
3363 2
3364 22
3365 32
3366 42
3367 52
3368 LOCK TABLE t1 WRITE;
3369 alter table t1 convert partition p2 to table tp2;
3370 ERROR HY000: Error on rename of './test/t1#P#p2' to './test/tp2' (errno: 0 "Internal error/check (Not system error)")
3371 # d,error_convert_partition_00: AFTER failure (under LOCK TABLE)
3372 db.opt
3373 t1#P#p1.MYD
3374 t1#P#p1.MYI
3375 t1#P#p2.MYD
3376 t1#P#p2.MYI
3377 t1#P#p3.MYD
3378 t1#P#p3.MYI
3379 t1#P#p4.MYD
3380 t1#P#p4.MYI
3381 t1#P#p5.MYD
3382 t1#P#p5.MYI
3383 t1#P#pn.MYD
3384 t1#P#pn.MYI
3385 t1.frm
3386 t1.par
3387 SHOW CREATE TABLE t1;
3388 Table Create Table
3389 t1 CREATE TABLE `t1` (
3390 `x` int(11) NOT NULL,
3391 PRIMARY KEY (`x`)
3392 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3393 PARTITION BY RANGE (`x`)
3394 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3395 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3396 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3397 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3398 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3399 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3400 SELECT * FROM t1;
3401 x
3402 12
3403 2
3404 22
3405 32
3406 42
3407 52
3408 UNLOCK TABLES;
3409 DROP TABLE t1;
3410 set session debug_dbug=@save_dbug;
3411 set session debug_dbug="+d,fail_convert_partition_1";
3412 create or replace table t1 (x int primary key)
3413 partition by range(x) (
3414 partition p1 values less than (10),
3415 partition p2 values less than (20),
3416 partition p3 values less than (30),
3417 partition p4 values less than (40),
3418 partition p5 values less than (50),
3419 partition pn values less than maxvalue);
3420 insert into t1 values (2), (12), (22), (32), (42), (52);
3421 # d,fail_convert_partition_1: BEFORE failure
3422 db.opt
3423 t1#P#p1.MYD
3424 t1#P#p1.MYI
3425 t1#P#p2.MYD
3426 t1#P#p2.MYI
3427 t1#P#p3.MYD
3428 t1#P#p3.MYI
3429 t1#P#p4.MYD
3430 t1#P#p4.MYI
3431 t1#P#p5.MYD
3432 t1#P#p5.MYI
3433 t1#P#pn.MYD
3434 t1#P#pn.MYI
3435 t1.frm
3436 t1.par
3437 SHOW CREATE TABLE t1;
3438 Table Create Table
3439 t1 CREATE TABLE `t1` (
3440 `x` int(11) NOT NULL,
3441 PRIMARY KEY (`x`)
3442 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3443 PARTITION BY RANGE (`x`)
3444 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3445 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3446 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3447 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3448 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3449 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3450 SELECT * FROM t1;
3451 x
3452 12
3453 2
3454 22
3455 32
3456 42
3457 52
3458 alter table t1 convert partition p2 to table tp2;
3459 ERROR HY000: Unknown error
3460 # d,fail_convert_partition_1: AFTER failure
3461 db.opt
3462 t1#P#p1.MYD
3463 t1#P#p1.MYI
3464 t1#P#p2.MYD
3465 t1#P#p2.MYI
3466 t1#P#p3.MYD
3467 t1#P#p3.MYI
3468 t1#P#p4.MYD
3469 t1#P#p4.MYI
3470 t1#P#p5.MYD
3471 t1#P#p5.MYI
3472 t1#P#pn.MYD
3473 t1#P#pn.MYI
3474 t1.frm
3475 t1.par
3476 SHOW CREATE TABLE t1;
3477 Table Create Table
3478 t1 CREATE TABLE `t1` (
3479 `x` int(11) NOT NULL,
3480 PRIMARY KEY (`x`)
3481 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3482 PARTITION BY RANGE (`x`)
3483 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3484 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3485 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3486 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3487 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3488 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3489 SELECT * FROM t1;
3490 x
3491 12
3492 2
3493 22
3494 32
3495 42
3496 52
3497 DROP TABLE t1;
3498 create or replace table t1 (x int primary key)
3499 partition by range(x) (
3500 partition p1 values less than (10),
3501 partition p2 values less than (20),
3502 partition p3 values less than (30),
3503 partition p4 values less than (40),
3504 partition p5 values less than (50),
3505 partition pn values less than maxvalue);
3506 insert into t1 values (2), (12), (22), (32), (42), (52);
3507 # d,fail_convert_partition_1: BEFORE failure (under LOCK TABLE)
3508 db.opt
3509 t1#P#p1.MYD
3510 t1#P#p1.MYI
3511 t1#P#p2.MYD
3512 t1#P#p2.MYI
3513 t1#P#p3.MYD
3514 t1#P#p3.MYI
3515 t1#P#p4.MYD
3516 t1#P#p4.MYI
3517 t1#P#p5.MYD
3518 t1#P#p5.MYI
3519 t1#P#pn.MYD
3520 t1#P#pn.MYI
3521 t1.frm
3522 t1.par
3523 SHOW CREATE TABLE t1;
3524 Table Create Table
3525 t1 CREATE TABLE `t1` (
3526 `x` int(11) NOT NULL,
3527 PRIMARY KEY (`x`)
3528 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3529 PARTITION BY RANGE (`x`)
3530 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3531 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3532 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3533 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3534 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3535 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3536 SELECT * FROM t1;
3537 x
3538 12
3539 2
3540 22
3541 32
3542 42
3543 52
3544 LOCK TABLE t1 WRITE;
3545 alter table t1 convert partition p2 to table tp2;
3546 ERROR HY000: Unknown error
3547 # d,fail_convert_partition_1: AFTER failure (under LOCK TABLE)
3548 db.opt
3549 t1#P#p1.MYD
3550 t1#P#p1.MYI
3551 t1#P#p2.MYD
3552 t1#P#p2.MYI
3553 t1#P#p3.MYD
3554 t1#P#p3.MYI
3555 t1#P#p4.MYD
3556 t1#P#p4.MYI
3557 t1#P#p5.MYD
3558 t1#P#p5.MYI
3559 t1#P#pn.MYD
3560 t1#P#pn.MYI
3561 t1.frm
3562 t1.par
3563 SHOW CREATE TABLE t1;
3564 Table Create Table
3565 t1 CREATE TABLE `t1` (
3566 `x` int(11) NOT NULL,
3567 PRIMARY KEY (`x`)
3568 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3569 PARTITION BY RANGE (`x`)
3570 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3571 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3572 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3573 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3574 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3575 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3576 SELECT * FROM t1;
3577 x
3578 12
3579 2
3580 22
3581 32
3582 42
3583 52
3584 UNLOCK TABLES;
3585 DROP TABLE t1;
3586 set session debug_dbug=@save_dbug;
3587 set session debug_dbug="+d,fail_convert_partition_2";
3588 create or replace table t1 (x int primary key)
3589 partition by range(x) (
3590 partition p1 values less than (10),
3591 partition p2 values less than (20),
3592 partition p3 values less than (30),
3593 partition p4 values less than (40),
3594 partition p5 values less than (50),
3595 partition pn values less than maxvalue);
3596 insert into t1 values (2), (12), (22), (32), (42), (52);
3597 # d,fail_convert_partition_2: BEFORE failure
3598 db.opt
3599 t1#P#p1.MYD
3600 t1#P#p1.MYI
3601 t1#P#p2.MYD
3602 t1#P#p2.MYI
3603 t1#P#p3.MYD
3604 t1#P#p3.MYI
3605 t1#P#p4.MYD
3606 t1#P#p4.MYI
3607 t1#P#p5.MYD
3608 t1#P#p5.MYI
3609 t1#P#pn.MYD
3610 t1#P#pn.MYI
3611 t1.frm
3612 t1.par
3613 SHOW CREATE TABLE t1;
3614 Table Create Table
3615 t1 CREATE TABLE `t1` (
3616 `x` int(11) NOT NULL,
3617 PRIMARY KEY (`x`)
3618 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3619 PARTITION BY RANGE (`x`)
3620 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3621 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3622 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3623 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3624 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3625 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3626 SELECT * FROM t1;
3627 x
3628 12
3629 2
3630 22
3631 32
3632 42
3633 52
3634 alter table t1 convert partition p2 to table tp2;
3635 ERROR HY000: Unknown error
3636 # d,fail_convert_partition_2: AFTER failure
3637 db.opt
3638 t1#P#p1.MYD
3639 t1#P#p1.MYI
3640 t1#P#p2.MYD
3641 t1#P#p2.MYI
3642 t1#P#p3.MYD
3643 t1#P#p3.MYI
3644 t1#P#p4.MYD
3645 t1#P#p4.MYI
3646 t1#P#p5.MYD
3647 t1#P#p5.MYI
3648 t1#P#pn.MYD
3649 t1#P#pn.MYI
3650 t1.frm
3651 t1.par
3652 SHOW CREATE TABLE t1;
3653 Table Create Table
3654 t1 CREATE TABLE `t1` (
3655 `x` int(11) NOT NULL,
3656 PRIMARY KEY (`x`)
3657 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3658 PARTITION BY RANGE (`x`)
3659 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3660 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3661 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3662 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3663 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3664 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3665 SELECT * FROM t1;
3666 x
3667 12
3668 2
3669 22
3670 32
3671 42
3672 52
3673 DROP TABLE t1;
3674 create or replace table t1 (x int primary key)
3675 partition by range(x) (
3676 partition p1 values less than (10),
3677 partition p2 values less than (20),
3678 partition p3 values less than (30),
3679 partition p4 values less than (40),
3680 partition p5 values less than (50),
3681 partition pn values less than maxvalue);
3682 insert into t1 values (2), (12), (22), (32), (42), (52);
3683 # d,fail_convert_partition_2: BEFORE failure (under LOCK TABLE)
3684 db.opt
3685 t1#P#p1.MYD
3686 t1#P#p1.MYI
3687 t1#P#p2.MYD
3688 t1#P#p2.MYI
3689 t1#P#p3.MYD
3690 t1#P#p3.MYI
3691 t1#P#p4.MYD
3692 t1#P#p4.MYI
3693 t1#P#p5.MYD
3694 t1#P#p5.MYI
3695 t1#P#pn.MYD
3696 t1#P#pn.MYI
3697 t1.frm
3698 t1.par
3699 SHOW CREATE TABLE t1;
3700 Table Create Table
3701 t1 CREATE TABLE `t1` (
3702 `x` int(11) NOT NULL,
3703 PRIMARY KEY (`x`)
3704 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3705 PARTITION BY RANGE (`x`)
3706 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3707 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3708 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3709 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3710 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3711 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3712 SELECT * FROM t1;
3713 x
3714 12
3715 2
3716 22
3717 32
3718 42
3719 52
3720 LOCK TABLE t1 WRITE;
3721 alter table t1 convert partition p2 to table tp2;
3722 ERROR HY000: Unknown error
3723 # d,fail_convert_partition_2: AFTER failure (under LOCK TABLE)
3724 db.opt
3725 t1#P#p1.MYD
3726 t1#P#p1.MYI
3727 t1#P#p2.MYD
3728 t1#P#p2.MYI
3729 t1#P#p3.MYD
3730 t1#P#p3.MYI
3731 t1#P#p4.MYD
3732 t1#P#p4.MYI
3733 t1#P#p5.MYD
3734 t1#P#p5.MYI
3735 t1#P#pn.MYD
3736 t1#P#pn.MYI
3737 t1.frm
3738 t1.par
3739 SHOW CREATE TABLE t1;
3740 Table Create Table
3741 t1 CREATE TABLE `t1` (
3742 `x` int(11) NOT NULL,
3743 PRIMARY KEY (`x`)
3744 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3745 PARTITION BY RANGE (`x`)
3746 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3747 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3748 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3749 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3750 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3751 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3752 SELECT * FROM t1;
3753 x
3754 12
3755 2
3756 22
3757 32
3758 42
3759 52
3760 UNLOCK TABLES;
3761 DROP TABLE t1;
3762 set session debug_dbug=@save_dbug;
3763 set session debug_dbug="+d,fail_convert_partition_3";
3764 create or replace table t1 (x int primary key)
3765 partition by range(x) (
3766 partition p1 values less than (10),
3767 partition p2 values less than (20),
3768 partition p3 values less than (30),
3769 partition p4 values less than (40),
3770 partition p5 values less than (50),
3771 partition pn values less than maxvalue);
3772 insert into t1 values (2), (12), (22), (32), (42), (52);
3773 # d,fail_convert_partition_3: BEFORE failure
3774 db.opt
3775 t1#P#p1.MYD
3776 t1#P#p1.MYI
3777 t1#P#p2.MYD
3778 t1#P#p2.MYI
3779 t1#P#p3.MYD
3780 t1#P#p3.MYI
3781 t1#P#p4.MYD
3782 t1#P#p4.MYI
3783 t1#P#p5.MYD
3784 t1#P#p5.MYI
3785 t1#P#pn.MYD
3786 t1#P#pn.MYI
3787 t1.frm
3788 t1.par
3789 SHOW CREATE TABLE t1;
3790 Table Create Table
3791 t1 CREATE TABLE `t1` (
3792 `x` int(11) NOT NULL,
3793 PRIMARY KEY (`x`)
3794 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3795 PARTITION BY RANGE (`x`)
3796 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3797 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3798 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3799 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3800 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3801 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3802 SELECT * FROM t1;
3803 x
3804 12
3805 2
3806 22
3807 32
3808 42
3809 52
3810 alter table t1 convert partition p2 to table tp2;
3811 ERROR HY000: Unknown error
3812 # d,fail_convert_partition_3: AFTER failure
3813 db.opt
3814 t1#P#p1.MYD
3815 t1#P#p1.MYI
3816 t1#P#p2.MYD
3817 t1#P#p2.MYI
3818 t1#P#p3.MYD
3819 t1#P#p3.MYI
3820 t1#P#p4.MYD
3821 t1#P#p4.MYI
3822 t1#P#p5.MYD
3823 t1#P#p5.MYI
3824 t1#P#pn.MYD
3825 t1#P#pn.MYI
3826 t1.frm
3827 t1.par
3828 SHOW CREATE TABLE t1;
3829 Table Create Table
3830 t1 CREATE TABLE `t1` (
3831 `x` int(11) NOT NULL,
3832 PRIMARY KEY (`x`)
3833 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3834 PARTITION BY RANGE (`x`)
3835 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3836 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3837 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3838 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3839 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3840 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3841 SELECT * FROM t1;
3842 x
3843 12
3844 2
3845 22
3846 32
3847 42
3848 52
3849 DROP TABLE t1;
3850 create or replace table t1 (x int primary key)
3851 partition by range(x) (
3852 partition p1 values less than (10),
3853 partition p2 values less than (20),
3854 partition p3 values less than (30),
3855 partition p4 values less than (40),
3856 partition p5 values less than (50),
3857 partition pn values less than maxvalue);
3858 insert into t1 values (2), (12), (22), (32), (42), (52);
3859 # d,fail_convert_partition_3: BEFORE failure (under LOCK TABLE)
3860 db.opt
3861 t1#P#p1.MYD
3862 t1#P#p1.MYI
3863 t1#P#p2.MYD
3864 t1#P#p2.MYI
3865 t1#P#p3.MYD
3866 t1#P#p3.MYI
3867 t1#P#p4.MYD
3868 t1#P#p4.MYI
3869 t1#P#p5.MYD
3870 t1#P#p5.MYI
3871 t1#P#pn.MYD
3872 t1#P#pn.MYI
3873 t1.frm
3874 t1.par
3875 SHOW CREATE TABLE t1;
3876 Table Create Table
3877 t1 CREATE TABLE `t1` (
3878 `x` int(11) NOT NULL,
3879 PRIMARY KEY (`x`)
3880 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3881 PARTITION BY RANGE (`x`)
3882 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3883 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3884 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3885 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3886 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3887 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3888 SELECT * FROM t1;
3889 x
3890 12
3891 2
3892 22
3893 32
3894 42
3895 52
3896 LOCK TABLE t1 WRITE;
3897 alter table t1 convert partition p2 to table tp2;
3898 ERROR HY000: Unknown error
3899 # d,fail_convert_partition_3: AFTER failure (under LOCK TABLE)
3900 db.opt
3901 t1#P#p1.MYD
3902 t1#P#p1.MYI
3903 t1#P#p2.MYD
3904 t1#P#p2.MYI
3905 t1#P#p3.MYD
3906 t1#P#p3.MYI
3907 t1#P#p4.MYD
3908 t1#P#p4.MYI
3909 t1#P#p5.MYD
3910 t1#P#p5.MYI
3911 t1#P#pn.MYD
3912 t1#P#pn.MYI
3913 t1.frm
3914 t1.par
3915 SHOW CREATE TABLE t1;
3916 Table Create Table
3917 t1 CREATE TABLE `t1` (
3918 `x` int(11) NOT NULL,
3919 PRIMARY KEY (`x`)
3920 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3921 PARTITION BY RANGE (`x`)
3922 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3923 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3924 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3925 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3926 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3927 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3928 SELECT * FROM t1;
3929 x
3930 12
3931 2
3932 22
3933 32
3934 42
3935 52
3936 UNLOCK TABLES;
3937 DROP TABLE t1;
3938 set session debug_dbug=@save_dbug;
3939 set session debug_dbug="+d,fail_convert_partition_4";
3940 create or replace table t1 (x int primary key)
3941 partition by range(x) (
3942 partition p1 values less than (10),
3943 partition p2 values less than (20),
3944 partition p3 values less than (30),
3945 partition p4 values less than (40),
3946 partition p5 values less than (50),
3947 partition pn values less than maxvalue);
3948 insert into t1 values (2), (12), (22), (32), (42), (52);
3949 # d,fail_convert_partition_4: BEFORE failure
3950 db.opt
3951 t1#P#p1.MYD
3952 t1#P#p1.MYI
3953 t1#P#p2.MYD
3954 t1#P#p2.MYI
3955 t1#P#p3.MYD
3956 t1#P#p3.MYI
3957 t1#P#p4.MYD
3958 t1#P#p4.MYI
3959 t1#P#p5.MYD
3960 t1#P#p5.MYI
3961 t1#P#pn.MYD
3962 t1#P#pn.MYI
3963 t1.frm
3964 t1.par
3965 SHOW CREATE TABLE t1;
3966 Table Create Table
3967 t1 CREATE TABLE `t1` (
3968 `x` int(11) NOT NULL,
3969 PRIMARY KEY (`x`)
3970 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
3971 PARTITION BY RANGE (`x`)
3972 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
3973 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
3974 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
3975 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
3976 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
3977 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
3978 SELECT * FROM t1;
3979 x
3980 12
3981 2
3982 22
3983 32
3984 42
3985 52
3986 alter table t1 convert partition p2 to table tp2;
3987 ERROR HY000: Unknown error
3988 # d,fail_convert_partition_4: AFTER failure
3989 db.opt
3990 t1#P#p1.MYD
3991 t1#P#p1.MYI
3992 t1#P#p2.MYD
3993 t1#P#p2.MYI
3994 t1#P#p3.MYD
3995 t1#P#p3.MYI
3996 t1#P#p4.MYD
3997 t1#P#p4.MYI
3998 t1#P#p5.MYD
3999 t1#P#p5.MYI
4000 t1#P#pn.MYD
4001 t1#P#pn.MYI
4002 t1.frm
4003 t1.par
4004 SHOW CREATE TABLE t1;
4005 Table Create Table
4006 t1 CREATE TABLE `t1` (
4007 `x` int(11) NOT NULL,
4008 PRIMARY KEY (`x`)
4009 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4010 PARTITION BY RANGE (`x`)
4011 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4012 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4013 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4014 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4015 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4016 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4017 SELECT * FROM t1;
4018 x
4019 12
4020 2
4021 22
4022 32
4023 42
4024 52
4025 DROP TABLE t1;
4026 create or replace table t1 (x int primary key)
4027 partition by range(x) (
4028 partition p1 values less than (10),
4029 partition p2 values less than (20),
4030 partition p3 values less than (30),
4031 partition p4 values less than (40),
4032 partition p5 values less than (50),
4033 partition pn values less than maxvalue);
4034 insert into t1 values (2), (12), (22), (32), (42), (52);
4035 # d,fail_convert_partition_4: BEFORE failure (under LOCK TABLE)
4036 db.opt
4037 t1#P#p1.MYD
4038 t1#P#p1.MYI
4039 t1#P#p2.MYD
4040 t1#P#p2.MYI
4041 t1#P#p3.MYD
4042 t1#P#p3.MYI
4043 t1#P#p4.MYD
4044 t1#P#p4.MYI
4045 t1#P#p5.MYD
4046 t1#P#p5.MYI
4047 t1#P#pn.MYD
4048 t1#P#pn.MYI
4049 t1.frm
4050 t1.par
4051 SHOW CREATE TABLE t1;
4052 Table Create Table
4053 t1 CREATE TABLE `t1` (
4054 `x` int(11) NOT NULL,
4055 PRIMARY KEY (`x`)
4056 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4057 PARTITION BY RANGE (`x`)
4058 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4059 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4060 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4061 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4062 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4063 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4064 SELECT * FROM t1;
4065 x
4066 12
4067 2
4068 22
4069 32
4070 42
4071 52
4072 LOCK TABLE t1 WRITE;
4073 alter table t1 convert partition p2 to table tp2;
4074 ERROR HY000: Unknown error
4075 # d,fail_convert_partition_4: AFTER failure (under LOCK TABLE)
4076 db.opt
4077 t1#P#p1.MYD
4078 t1#P#p1.MYI
4079 t1#P#p2.MYD
4080 t1#P#p2.MYI
4081 t1#P#p3.MYD
4082 t1#P#p3.MYI
4083 t1#P#p4.MYD
4084 t1#P#p4.MYI
4085 t1#P#p5.MYD
4086 t1#P#p5.MYI
4087 t1#P#pn.MYD
4088 t1#P#pn.MYI
4089 t1.frm
4090 t1.par
4091 SHOW CREATE TABLE t1;
4092 Table Create Table
4093 t1 CREATE TABLE `t1` (
4094 `x` int(11) NOT NULL,
4095 PRIMARY KEY (`x`)
4096 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4097 PARTITION BY RANGE (`x`)
4098 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4099 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4100 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4101 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4102 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4103 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4104 SELECT * FROM t1;
4105 x
4106 12
4107 2
4108 22
4109 32
4110 42
4111 52
4112 UNLOCK TABLES;
4113 DROP TABLE t1;
4114 set session debug_dbug=@save_dbug;
4115 set session debug_dbug="+d,fail_convert_partition_5";
4116 create or replace table t1 (x int primary key)
4117 partition by range(x) (
4118 partition p1 values less than (10),
4119 partition p2 values less than (20),
4120 partition p3 values less than (30),
4121 partition p4 values less than (40),
4122 partition p5 values less than (50),
4123 partition pn values less than maxvalue);
4124 insert into t1 values (2), (12), (22), (32), (42), (52);
4125 # d,fail_convert_partition_5: BEFORE failure
4126 db.opt
4127 t1#P#p1.MYD
4128 t1#P#p1.MYI
4129 t1#P#p2.MYD
4130 t1#P#p2.MYI
4131 t1#P#p3.MYD
4132 t1#P#p3.MYI
4133 t1#P#p4.MYD
4134 t1#P#p4.MYI
4135 t1#P#p5.MYD
4136 t1#P#p5.MYI
4137 t1#P#pn.MYD
4138 t1#P#pn.MYI
4139 t1.frm
4140 t1.par
4141 SHOW CREATE TABLE t1;
4142 Table Create Table
4143 t1 CREATE TABLE `t1` (
4144 `x` int(11) NOT NULL,
4145 PRIMARY KEY (`x`)
4146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4147 PARTITION BY RANGE (`x`)
4148 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4149 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4150 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4151 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4152 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4153 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4154 SELECT * FROM t1;
4155 x
4156 12
4157 2
4158 22
4159 32
4160 42
4161 52
4162 alter table t1 convert partition p2 to table tp2;
4163 ERROR HY000: Unknown error
4164 # d,fail_convert_partition_5: AFTER failure
4165 db.opt
4166 t1#P#p1.MYD
4167 t1#P#p1.MYI
4168 t1#P#p2.MYD
4169 t1#P#p2.MYI
4170 t1#P#p3.MYD
4171 t1#P#p3.MYI
4172 t1#P#p4.MYD
4173 t1#P#p4.MYI
4174 t1#P#p5.MYD
4175 t1#P#p5.MYI
4176 t1#P#pn.MYD
4177 t1#P#pn.MYI
4178 t1.frm
4179 t1.par
4180 SHOW CREATE TABLE t1;
4181 Table Create Table
4182 t1 CREATE TABLE `t1` (
4183 `x` int(11) NOT NULL,
4184 PRIMARY KEY (`x`)
4185 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4186 PARTITION BY RANGE (`x`)
4187 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4188 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4189 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4190 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4191 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4192 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4193 SELECT * FROM t1;
4194 x
4195 12
4196 2
4197 22
4198 32
4199 42
4200 52
4201 DROP TABLE t1;
4202 create or replace table t1 (x int primary key)
4203 partition by range(x) (
4204 partition p1 values less than (10),
4205 partition p2 values less than (20),
4206 partition p3 values less than (30),
4207 partition p4 values less than (40),
4208 partition p5 values less than (50),
4209 partition pn values less than maxvalue);
4210 insert into t1 values (2), (12), (22), (32), (42), (52);
4211 # d,fail_convert_partition_5: BEFORE failure (under LOCK TABLE)
4212 db.opt
4213 t1#P#p1.MYD
4214 t1#P#p1.MYI
4215 t1#P#p2.MYD
4216 t1#P#p2.MYI
4217 t1#P#p3.MYD
4218 t1#P#p3.MYI
4219 t1#P#p4.MYD
4220 t1#P#p4.MYI
4221 t1#P#p5.MYD
4222 t1#P#p5.MYI
4223 t1#P#pn.MYD
4224 t1#P#pn.MYI
4225 t1.frm
4226 t1.par
4227 SHOW CREATE TABLE t1;
4228 Table Create Table
4229 t1 CREATE TABLE `t1` (
4230 `x` int(11) NOT NULL,
4231 PRIMARY KEY (`x`)
4232 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4233 PARTITION BY RANGE (`x`)
4234 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4235 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4236 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4237 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4238 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4239 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4240 SELECT * FROM t1;
4241 x
4242 12
4243 2
4244 22
4245 32
4246 42
4247 52
4248 LOCK TABLE t1 WRITE;
4249 alter table t1 convert partition p2 to table tp2;
4250 ERROR HY000: Unknown error
4251 # d,fail_convert_partition_5: AFTER failure (under LOCK TABLE)
4252 db.opt
4253 t1#P#p1.MYD
4254 t1#P#p1.MYI
4255 t1#P#p2.MYD
4256 t1#P#p2.MYI
4257 t1#P#p3.MYD
4258 t1#P#p3.MYI
4259 t1#P#p4.MYD
4260 t1#P#p4.MYI
4261 t1#P#p5.MYD
4262 t1#P#p5.MYI
4263 t1#P#pn.MYD
4264 t1#P#pn.MYI
4265 t1.frm
4266 t1.par
4267 SHOW CREATE TABLE t1;
4268 Table Create Table
4269 t1 CREATE TABLE `t1` (
4270 `x` int(11) NOT NULL,
4271 PRIMARY KEY (`x`)
4272 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4273 PARTITION BY RANGE (`x`)
4274 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4275 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4276 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4277 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4278 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4279 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4280 SELECT * FROM t1;
4281 x
4282 12
4283 2
4284 22
4285 32
4286 42
4287 52
4288 UNLOCK TABLES;
4289 DROP TABLE t1;
4290 set session debug_dbug=@save_dbug;
4291 set session debug_dbug="+d,fail_convert_partition_6";
4292 create or replace table t1 (x int primary key)
4293 partition by range(x) (
4294 partition p1 values less than (10),
4295 partition p2 values less than (20),
4296 partition p3 values less than (30),
4297 partition p4 values less than (40),
4298 partition p5 values less than (50),
4299 partition pn values less than maxvalue);
4300 insert into t1 values (2), (12), (22), (32), (42), (52);
4301 # d,fail_convert_partition_6: BEFORE failure
4302 db.opt
4303 t1#P#p1.MYD
4304 t1#P#p1.MYI
4305 t1#P#p2.MYD
4306 t1#P#p2.MYI
4307 t1#P#p3.MYD
4308 t1#P#p3.MYI
4309 t1#P#p4.MYD
4310 t1#P#p4.MYI
4311 t1#P#p5.MYD
4312 t1#P#p5.MYI
4313 t1#P#pn.MYD
4314 t1#P#pn.MYI
4315 t1.frm
4316 t1.par
4317 SHOW CREATE TABLE t1;
4318 Table Create Table
4319 t1 CREATE TABLE `t1` (
4320 `x` int(11) NOT NULL,
4321 PRIMARY KEY (`x`)
4322 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4323 PARTITION BY RANGE (`x`)
4324 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4325 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4326 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4327 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4328 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4329 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4330 SELECT * FROM t1;
4331 x
4332 12
4333 2
4334 22
4335 32
4336 42
4337 52
4338 alter table t1 convert partition p2 to table tp2;
4339 ERROR HY000: Unknown error
4340 # d,fail_convert_partition_6: AFTER failure
4341 db.opt
4342 t1#P#p1.MYD
4343 t1#P#p1.MYI
4344 t1#P#p2.MYD
4345 t1#P#p2.MYI
4346 t1#P#p3.MYD
4347 t1#P#p3.MYI
4348 t1#P#p4.MYD
4349 t1#P#p4.MYI
4350 t1#P#p5.MYD
4351 t1#P#p5.MYI
4352 t1#P#pn.MYD
4353 t1#P#pn.MYI
4354 t1.frm
4355 t1.par
4356 SHOW CREATE TABLE t1;
4357 Table Create Table
4358 t1 CREATE TABLE `t1` (
4359 `x` int(11) NOT NULL,
4360 PRIMARY KEY (`x`)
4361 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4362 PARTITION BY RANGE (`x`)
4363 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4364 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4365 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4366 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4367 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4368 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4369 SELECT * FROM t1;
4370 x
4371 12
4372 2
4373 22
4374 32
4375 42
4376 52
4377 DROP TABLE t1;
4378 create or replace table t1 (x int primary key)
4379 partition by range(x) (
4380 partition p1 values less than (10),
4381 partition p2 values less than (20),
4382 partition p3 values less than (30),
4383 partition p4 values less than (40),
4384 partition p5 values less than (50),
4385 partition pn values less than maxvalue);
4386 insert into t1 values (2), (12), (22), (32), (42), (52);
4387 # d,fail_convert_partition_6: BEFORE failure (under LOCK TABLE)
4388 db.opt
4389 t1#P#p1.MYD
4390 t1#P#p1.MYI
4391 t1#P#p2.MYD
4392 t1#P#p2.MYI
4393 t1#P#p3.MYD
4394 t1#P#p3.MYI
4395 t1#P#p4.MYD
4396 t1#P#p4.MYI
4397 t1#P#p5.MYD
4398 t1#P#p5.MYI
4399 t1#P#pn.MYD
4400 t1#P#pn.MYI
4401 t1.frm
4402 t1.par
4403 SHOW CREATE TABLE t1;
4404 Table Create Table
4405 t1 CREATE TABLE `t1` (
4406 `x` int(11) NOT NULL,
4407 PRIMARY KEY (`x`)
4408 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4409 PARTITION BY RANGE (`x`)
4410 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4411 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4412 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4413 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4414 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4415 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4416 SELECT * FROM t1;
4417 x
4418 12
4419 2
4420 22
4421 32
4422 42
4423 52
4424 LOCK TABLE t1 WRITE;
4425 alter table t1 convert partition p2 to table tp2;
4426 ERROR HY000: Unknown error
4427 # d,fail_convert_partition_6: AFTER failure (under LOCK TABLE)
4428 db.opt
4429 t1#P#p1.MYD
4430 t1#P#p1.MYI
4431 t1#P#p2.MYD
4432 t1#P#p2.MYI
4433 t1#P#p3.MYD
4434 t1#P#p3.MYI
4435 t1#P#p4.MYD
4436 t1#P#p4.MYI
4437 t1#P#p5.MYD
4438 t1#P#p5.MYI
4439 t1#P#pn.MYD
4440 t1#P#pn.MYI
4441 t1.frm
4442 t1.par
4443 SHOW CREATE TABLE t1;
4444 Table Create Table
4445 t1 CREATE TABLE `t1` (
4446 `x` int(11) NOT NULL,
4447 PRIMARY KEY (`x`)
4448 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4449 PARTITION BY RANGE (`x`)
4450 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4451 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4452 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4453 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4454 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4455 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4456 SELECT * FROM t1;
4457 x
4458 12
4459 2
4460 22
4461 32
4462 42
4463 52
4464 UNLOCK TABLES;
4465 DROP TABLE t1;
4466 set session debug_dbug=@save_dbug;
4467 set session debug_dbug="+d,fail_convert_partition_7";
4468 create or replace table t1 (x int primary key)
4469 partition by range(x) (
4470 partition p1 values less than (10),
4471 partition p2 values less than (20),
4472 partition p3 values less than (30),
4473 partition p4 values less than (40),
4474 partition p5 values less than (50),
4475 partition pn values less than maxvalue);
4476 insert into t1 values (2), (12), (22), (32), (42), (52);
4477 # d,fail_convert_partition_7: BEFORE failure
4478 db.opt
4479 t1#P#p1.MYD
4480 t1#P#p1.MYI
4481 t1#P#p2.MYD
4482 t1#P#p2.MYI
4483 t1#P#p3.MYD
4484 t1#P#p3.MYI
4485 t1#P#p4.MYD
4486 t1#P#p4.MYI
4487 t1#P#p5.MYD
4488 t1#P#p5.MYI
4489 t1#P#pn.MYD
4490 t1#P#pn.MYI
4491 t1.frm
4492 t1.par
4493 SHOW CREATE TABLE t1;
4494 Table Create Table
4495 t1 CREATE TABLE `t1` (
4496 `x` int(11) NOT NULL,
4497 PRIMARY KEY (`x`)
4498 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4499 PARTITION BY RANGE (`x`)
4500 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4501 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4502 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4503 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4504 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4505 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4506 SELECT * FROM t1;
4507 x
4508 12
4509 2
4510 22
4511 32
4512 42
4513 52
4514 alter table t1 convert partition p2 to table tp2;
4515 ERROR HY000: Unknown error
4516 # d,fail_convert_partition_7: AFTER failure
4517 db.opt
4518 t1#P#p1.MYD
4519 t1#P#p1.MYI
4520 t1#P#p2.MYD
4521 t1#P#p2.MYI
4522 t1#P#p3.MYD
4523 t1#P#p3.MYI
4524 t1#P#p4.MYD
4525 t1#P#p4.MYI
4526 t1#P#p5.MYD
4527 t1#P#p5.MYI
4528 t1#P#pn.MYD
4529 t1#P#pn.MYI
4530 t1.frm
4531 t1.par
4532 SHOW CREATE TABLE t1;
4533 Table Create Table
4534 t1 CREATE TABLE `t1` (
4535 `x` int(11) NOT NULL,
4536 PRIMARY KEY (`x`)
4537 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4538 PARTITION BY RANGE (`x`)
4539 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4540 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4541 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4542 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4543 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4544 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4545 SELECT * FROM t1;
4546 x
4547 12
4548 2
4549 22
4550 32
4551 42
4552 52
4553 DROP TABLE t1;
4554 create or replace table t1 (x int primary key)
4555 partition by range(x) (
4556 partition p1 values less than (10),
4557 partition p2 values less than (20),
4558 partition p3 values less than (30),
4559 partition p4 values less than (40),
4560 partition p5 values less than (50),
4561 partition pn values less than maxvalue);
4562 insert into t1 values (2), (12), (22), (32), (42), (52);
4563 # d,fail_convert_partition_7: BEFORE failure (under LOCK TABLE)
4564 db.opt
4565 t1#P#p1.MYD
4566 t1#P#p1.MYI
4567 t1#P#p2.MYD
4568 t1#P#p2.MYI
4569 t1#P#p3.MYD
4570 t1#P#p3.MYI
4571 t1#P#p4.MYD
4572 t1#P#p4.MYI
4573 t1#P#p5.MYD
4574 t1#P#p5.MYI
4575 t1#P#pn.MYD
4576 t1#P#pn.MYI
4577 t1.frm
4578 t1.par
4579 SHOW CREATE TABLE t1;
4580 Table Create Table
4581 t1 CREATE TABLE `t1` (
4582 `x` int(11) NOT NULL,
4583 PRIMARY KEY (`x`)
4584 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4585 PARTITION BY RANGE (`x`)
4586 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4587 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4588 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4589 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4590 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4591 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4592 SELECT * FROM t1;
4593 x
4594 12
4595 2
4596 22
4597 32
4598 42
4599 52
4600 LOCK TABLE t1 WRITE;
4601 alter table t1 convert partition p2 to table tp2;
4602 ERROR HY000: Unknown error
4603 # d,fail_convert_partition_7: AFTER failure (under LOCK TABLE)
4604 db.opt
4605 t1#P#p1.MYD
4606 t1#P#p1.MYI
4607 t1#P#p2.MYD
4608 t1#P#p2.MYI
4609 t1#P#p3.MYD
4610 t1#P#p3.MYI
4611 t1#P#p4.MYD
4612 t1#P#p4.MYI
4613 t1#P#p5.MYD
4614 t1#P#p5.MYI
4615 t1#P#pn.MYD
4616 t1#P#pn.MYI
4617 t1.frm
4618 t1.par
4619 SHOW CREATE TABLE t1;
4620 Table Create Table
4621 t1 CREATE TABLE `t1` (
4622 `x` int(11) NOT NULL,
4623 PRIMARY KEY (`x`)
4624 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4625 PARTITION BY RANGE (`x`)
4626 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4627 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4628 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4629 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4630 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4631 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4632 SELECT * FROM t1;
4633 x
4634 12
4635 2
4636 22
4637 32
4638 42
4639 52
4640 UNLOCK TABLES;
4641 DROP TABLE t1;
4642 set session debug_dbug=@save_dbug;
4643 set session debug_dbug="+d,fail_convert_partition_8";
4644 create or replace table t1 (x int primary key)
4645 partition by range(x) (
4646 partition p1 values less than (10),
4647 partition p2 values less than (20),
4648 partition p3 values less than (30),
4649 partition p4 values less than (40),
4650 partition p5 values less than (50),
4651 partition pn values less than maxvalue);
4652 insert into t1 values (2), (12), (22), (32), (42), (52);
4653 # d,fail_convert_partition_8: BEFORE failure
4654 db.opt
4655 t1#P#p1.MYD
4656 t1#P#p1.MYI
4657 t1#P#p2.MYD
4658 t1#P#p2.MYI
4659 t1#P#p3.MYD
4660 t1#P#p3.MYI
4661 t1#P#p4.MYD
4662 t1#P#p4.MYI
4663 t1#P#p5.MYD
4664 t1#P#p5.MYI
4665 t1#P#pn.MYD
4666 t1#P#pn.MYI
4667 t1.frm
4668 t1.par
4669 SHOW CREATE TABLE t1;
4670 Table Create Table
4671 t1 CREATE TABLE `t1` (
4672 `x` int(11) NOT NULL,
4673 PRIMARY KEY (`x`)
4674 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4675 PARTITION BY RANGE (`x`)
4676 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4677 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4678 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4679 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4680 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4681 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4682 SELECT * FROM t1;
4683 x
4684 12
4685 2
4686 22
4687 32
4688 42
4689 52
4690 alter table t1 convert partition p2 to table tp2;
4691 ERROR HY000: Unknown error
4692 # d,fail_convert_partition_8: AFTER failure
4693 db.opt
4694 t1#P#p1.MYD
4695 t1#P#p1.MYI
4696 t1#P#p2.MYD
4697 t1#P#p2.MYI
4698 t1#P#p3.MYD
4699 t1#P#p3.MYI
4700 t1#P#p4.MYD
4701 t1#P#p4.MYI
4702 t1#P#p5.MYD
4703 t1#P#p5.MYI
4704 t1#P#pn.MYD
4705 t1#P#pn.MYI
4706 t1.frm
4707 t1.par
4708 SHOW CREATE TABLE t1;
4709 Table Create Table
4710 t1 CREATE TABLE `t1` (
4711 `x` int(11) NOT NULL,
4712 PRIMARY KEY (`x`)
4713 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4714 PARTITION BY RANGE (`x`)
4715 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4716 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4717 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4718 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4719 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4720 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4721 SELECT * FROM t1;
4722 x
4723 12
4724 2
4725 22
4726 32
4727 42
4728 52
4729 DROP TABLE t1;
4730 create or replace table t1 (x int primary key)
4731 partition by range(x) (
4732 partition p1 values less than (10),
4733 partition p2 values less than (20),
4734 partition p3 values less than (30),
4735 partition p4 values less than (40),
4736 partition p5 values less than (50),
4737 partition pn values less than maxvalue);
4738 insert into t1 values (2), (12), (22), (32), (42), (52);
4739 # d,fail_convert_partition_8: BEFORE failure (under LOCK TABLE)
4740 db.opt
4741 t1#P#p1.MYD
4742 t1#P#p1.MYI
4743 t1#P#p2.MYD
4744 t1#P#p2.MYI
4745 t1#P#p3.MYD
4746 t1#P#p3.MYI
4747 t1#P#p4.MYD
4748 t1#P#p4.MYI
4749 t1#P#p5.MYD
4750 t1#P#p5.MYI
4751 t1#P#pn.MYD
4752 t1#P#pn.MYI
4753 t1.frm
4754 t1.par
4755 SHOW CREATE TABLE t1;
4756 Table Create Table
4757 t1 CREATE TABLE `t1` (
4758 `x` int(11) NOT NULL,
4759 PRIMARY KEY (`x`)
4760 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4761 PARTITION BY RANGE (`x`)
4762 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4763 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4764 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4765 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4766 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4767 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4768 SELECT * FROM t1;
4769 x
4770 12
4771 2
4772 22
4773 32
4774 42
4775 52
4776 LOCK TABLE t1 WRITE;
4777 alter table t1 convert partition p2 to table tp2;
4778 ERROR HY000: Unknown error
4779 # d,fail_convert_partition_8: AFTER failure (under LOCK TABLE)
4780 db.opt
4781 t1#P#p1.MYD
4782 t1#P#p1.MYI
4783 t1#P#p2.MYD
4784 t1#P#p2.MYI
4785 t1#P#p3.MYD
4786 t1#P#p3.MYI
4787 t1#P#p4.MYD
4788 t1#P#p4.MYI
4789 t1#P#p5.MYD
4790 t1#P#p5.MYI
4791 t1#P#pn.MYD
4792 t1#P#pn.MYI
4793 t1.frm
4794 t1.par
4795 SHOW CREATE TABLE t1;
4796 Table Create Table
4797 t1 CREATE TABLE `t1` (
4798 `x` int(11) NOT NULL,
4799 PRIMARY KEY (`x`)
4800 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4801 PARTITION BY RANGE (`x`)
4802 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4803 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4804 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4805 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4806 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4807 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4808 SELECT * FROM t1;
4809 x
4810 12
4811 2
4812 22
4813 32
4814 42
4815 52
4816 UNLOCK TABLES;
4817 DROP TABLE t1;
4818 set session debug_dbug=@save_dbug;
4819 set session debug_dbug="+d,fail_convert_partition_9";
4820 create or replace table t1 (x int primary key)
4821 partition by range(x) (
4822 partition p1 values less than (10),
4823 partition p2 values less than (20),
4824 partition p3 values less than (30),
4825 partition p4 values less than (40),
4826 partition p5 values less than (50),
4827 partition pn values less than maxvalue);
4828 insert into t1 values (2), (12), (22), (32), (42), (52);
4829 # d,fail_convert_partition_9: BEFORE failure
4830 db.opt
4831 t1#P#p1.MYD
4832 t1#P#p1.MYI
4833 t1#P#p2.MYD
4834 t1#P#p2.MYI
4835 t1#P#p3.MYD
4836 t1#P#p3.MYI
4837 t1#P#p4.MYD
4838 t1#P#p4.MYI
4839 t1#P#p5.MYD
4840 t1#P#p5.MYI
4841 t1#P#pn.MYD
4842 t1#P#pn.MYI
4843 t1.frm
4844 t1.par
4845 SHOW CREATE TABLE t1;
4846 Table Create Table
4847 t1 CREATE TABLE `t1` (
4848 `x` int(11) NOT NULL,
4849 PRIMARY KEY (`x`)
4850 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4851 PARTITION BY RANGE (`x`)
4852 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4853 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4854 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4855 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4856 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4857 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4858 SELECT * FROM t1;
4859 x
4860 12
4861 2
4862 22
4863 32
4864 42
4865 52
4866 alter table t1 convert partition p2 to table tp2;
4867 ERROR HY000: Unknown error
4868 # d,fail_convert_partition_9: AFTER failure
4869 db.opt
4870 t1#P#p1.MYD
4871 t1#P#p1.MYI
4872 t1#P#p2.MYD
4873 t1#P#p2.MYI
4874 t1#P#p3.MYD
4875 t1#P#p3.MYI
4876 t1#P#p4.MYD
4877 t1#P#p4.MYI
4878 t1#P#p5.MYD
4879 t1#P#p5.MYI
4880 t1#P#pn.MYD
4881 t1#P#pn.MYI
4882 t1.frm
4883 t1.par
4884 SHOW CREATE TABLE t1;
4885 Table Create Table
4886 t1 CREATE TABLE `t1` (
4887 `x` int(11) NOT NULL,
4888 PRIMARY KEY (`x`)
4889 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4890 PARTITION BY RANGE (`x`)
4891 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4892 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4893 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4894 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4895 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4896 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4897 SELECT * FROM t1;
4898 x
4899 12
4900 2
4901 22
4902 32
4903 42
4904 52
4905 DROP TABLE t1;
4906 create or replace table t1 (x int primary key)
4907 partition by range(x) (
4908 partition p1 values less than (10),
4909 partition p2 values less than (20),
4910 partition p3 values less than (30),
4911 partition p4 values less than (40),
4912 partition p5 values less than (50),
4913 partition pn values less than maxvalue);
4914 insert into t1 values (2), (12), (22), (32), (42), (52);
4915 # d,fail_convert_partition_9: BEFORE failure (under LOCK TABLE)
4916 db.opt
4917 t1#P#p1.MYD
4918 t1#P#p1.MYI
4919 t1#P#p2.MYD
4920 t1#P#p2.MYI
4921 t1#P#p3.MYD
4922 t1#P#p3.MYI
4923 t1#P#p4.MYD
4924 t1#P#p4.MYI
4925 t1#P#p5.MYD
4926 t1#P#p5.MYI
4927 t1#P#pn.MYD
4928 t1#P#pn.MYI
4929 t1.frm
4930 t1.par
4931 SHOW CREATE TABLE t1;
4932 Table Create Table
4933 t1 CREATE TABLE `t1` (
4934 `x` int(11) NOT NULL,
4935 PRIMARY KEY (`x`)
4936 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4937 PARTITION BY RANGE (`x`)
4938 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4939 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4940 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4941 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4942 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4943 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4944 SELECT * FROM t1;
4945 x
4946 12
4947 2
4948 22
4949 32
4950 42
4951 52
4952 LOCK TABLE t1 WRITE;
4953 alter table t1 convert partition p2 to table tp2;
4954 ERROR HY000: Unknown error
4955 # d,fail_convert_partition_9: AFTER failure (under LOCK TABLE)
4956 db.opt
4957 t1#P#p1.MYD
4958 t1#P#p1.MYI
4959 t1#P#p2.MYD
4960 t1#P#p2.MYI
4961 t1#P#p3.MYD
4962 t1#P#p3.MYI
4963 t1#P#p4.MYD
4964 t1#P#p4.MYI
4965 t1#P#p5.MYD
4966 t1#P#p5.MYI
4967 t1#P#pn.MYD
4968 t1#P#pn.MYI
4969 t1.frm
4970 t1.par
4971 SHOW CREATE TABLE t1;
4972 Table Create Table
4973 t1 CREATE TABLE `t1` (
4974 `x` int(11) NOT NULL,
4975 PRIMARY KEY (`x`)
4976 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
4977 PARTITION BY RANGE (`x`)
4978 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
4979 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
4980 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
4981 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
4982 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
4983 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
4984 SELECT * FROM t1;
4985 x
4986 12
4987 2
4988 22
4989 32
4990 42
4991 52
4992 UNLOCK TABLES;
4993 DROP TABLE t1;
4994 set session debug_dbug=@save_dbug;
4995 set session debug_dbug="+d,fail_convert_partition_11";
4996 # Already finished DDL logging, so tp2 now exists:
4997 create or replace table t1 (x int primary key)
4998 partition by range(x) (
4999 partition p1 values less than (10),
5000 partition p2 values less than (20),
5001 partition p3 values less than (30),
5002 partition p4 values less than (40),
5003 partition p5 values less than (50),
5004 partition pn values less than maxvalue);
5005 insert into t1 values (2), (12), (22), (32), (42), (52);
5006 # d,fail_convert_partition_11: BEFORE failure
5007 db.opt
5008 t1#P#p1.MYD
5009 t1#P#p1.MYI
5010 t1#P#p2.MYD
5011 t1#P#p2.MYI
5012 t1#P#p3.MYD
5013 t1#P#p3.MYI
5014 t1#P#p4.MYD
5015 t1#P#p4.MYI
5016 t1#P#p5.MYD
5017 t1#P#p5.MYI
5018 t1#P#pn.MYD
5019 t1#P#pn.MYI
5020 t1.frm
5021 t1.par
5022 SHOW CREATE TABLE t1;
5023 Table Create Table
5024 t1 CREATE TABLE `t1` (
5025 `x` int(11) NOT NULL,
5026 PRIMARY KEY (`x`)
5027 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
5028 PARTITION BY RANGE (`x`)
5029 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
5030 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
5031 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
5032 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
5033 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
5034 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
5035 SELECT * FROM t1;
5036 x
5037 12
5038 2
5039 22
5040 32
5041 42
5042 52
5043 alter table t1 convert partition p2 to table tp2;
5044 ERROR HY000: Unknown error
5045 # d,fail_convert_partition_11: AFTER failure
5046 db.opt
5047 t1#P#p1.MYD
5048 t1#P#p1.MYI
5049 t1#P#p3.MYD
5050 t1#P#p3.MYI
5051 t1#P#p4.MYD
5052 t1#P#p4.MYI
5053 t1#P#p5.MYD
5054 t1#P#p5.MYI
5055 t1#P#pn.MYD
5056 t1#P#pn.MYI
5057 t1.frm
5058 t1.par
5059 tp2.MYD
5060 tp2.MYI
5061 tp2.frm
5062 SHOW CREATE TABLE t1;
5063 Table Create Table
5064 t1 CREATE TABLE `t1` (
5065 `x` int(11) NOT NULL,
5066 PRIMARY KEY (`x`)
5067 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
5068 PARTITION BY RANGE (`x`)
5069 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
5070 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
5071 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
5072 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
5073 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
5074 SELECT * FROM t1;
5075 x
5076 2
5077 22
5078 32
5079 42
5080 52
5081 DROP TABLE t1;
5082 create or replace table t1 (x int primary key)
5083 partition by range(x) (
5084 partition p1 values less than (10),
5085 partition p2 values less than (20),
5086 partition p3 values less than (30),
5087 partition p4 values less than (40),
5088 partition p5 values less than (50),
5089 partition pn values less than maxvalue);
5090 insert into t1 values (2), (12), (22), (32), (42), (52);
5091 # d,fail_convert_partition_11: BEFORE failure (under LOCK TABLE)
5092 db.opt
5093 t1#P#p1.MYD
5094 t1#P#p1.MYI
5095 t1#P#p2.MYD
5096 t1#P#p2.MYI
5097 t1#P#p3.MYD
5098 t1#P#p3.MYI
5099 t1#P#p4.MYD
5100 t1#P#p4.MYI
5101 t1#P#p5.MYD
5102 t1#P#p5.MYI
5103 t1#P#pn.MYD
5104 t1#P#pn.MYI
5105 t1.frm
5106 t1.par
5107 tp2.MYD
5108 tp2.MYI
5109 tp2.frm
5110 SHOW CREATE TABLE t1;
5111 Table Create Table
5112 t1 CREATE TABLE `t1` (
5113 `x` int(11) NOT NULL,
5114 PRIMARY KEY (`x`)
5115 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
5116 PARTITION BY RANGE (`x`)
5117 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
5118 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
5119 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
5120 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
5121 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
5122 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
5123 SELECT * FROM t1;
5124 x
5125 12
5126 2
5127 22
5128 32
5129 42
5130 52
5131 LOCK TABLE t1 WRITE;
5132 alter table t1 convert partition p2 to table tp2;
5133 ERROR 42S01: Table 'tp2' already exists
5134 # d,fail_convert_partition_11: AFTER failure (under LOCK TABLE)
5135 db.opt
5136 t1#P#p1.MYD
5137 t1#P#p1.MYI
5138 t1#P#p2.MYD
5139 t1#P#p2.MYI
5140 t1#P#p3.MYD
5141 t1#P#p3.MYI
5142 t1#P#p4.MYD
5143 t1#P#p4.MYI
5144 t1#P#p5.MYD
5145 t1#P#p5.MYI
5146 t1#P#pn.MYD
5147 t1#P#pn.MYI
5148 t1.frm
5149 t1.par
5150 tp2.MYD
5151 tp2.MYI
5152 tp2.frm
5153 SHOW CREATE TABLE t1;
5154 Table Create Table
5155 t1 CREATE TABLE `t1` (
5156 `x` int(11) NOT NULL,
5157 PRIMARY KEY (`x`)
5158 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
5159 PARTITION BY RANGE (`x`)
5160 (PARTITION `p1` VALUES LESS THAN (10) ENGINE = MyISAM,
5161 PARTITION `p2` VALUES LESS THAN (20) ENGINE = MyISAM,
5162 PARTITION `p3` VALUES LESS THAN (30) ENGINE = MyISAM,
5163 PARTITION `p4` VALUES LESS THAN (40) ENGINE = MyISAM,
5164 PARTITION `p5` VALUES LESS THAN (50) ENGINE = MyISAM,
5165 PARTITION `pn` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
5166 SELECT * FROM t1;
5167 x
5168 12
5169 2
5170 22
5171 32
5172 42
5173 52
5174 UNLOCK TABLES;
5175 DROP TABLE t1;
5176 set session debug_dbug=@save_dbug;
5177 show create table tp2;
5178 Table Create Table
5179 tp2 CREATE TABLE `tp2` (
5180 `x` int(11) NOT NULL,
5181 PRIMARY KEY (`x`)
5182 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
5183 select * from tp2;
5184 x
5185 12
5186 drop table tp2;