Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_partition_reorg_hash_key.result

raw
1 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
2 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
3 SELECT * FROM t1 ORDER BY c1;
4 c1 c2
5 0 abc
6 5 abc
7 10 abc
8 15 abc
9 20 abc
10 25 abc
11 30 abc
12 35 abc
13 SHOW TABLES;
14 Tables_in_test
15 t1
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` tinyint(4) NOT NULL,
20 `c2` char(5) DEFAULT NULL
21 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
22 PARTITION BY HASH (`c1`)
23 PARTITIONS 10
24 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
25 SELECT * FROM t1 ORDER BY c1;
26 c1 c2
27 0 abc
28 5 abc
29 10 abc
30 15 abc
31 20 abc
32 25 abc
33 30 abc
34 35 abc
35 SHOW TABLES;
36 Tables_in_test
37 t1
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `c1` tinyint(4) NOT NULL,
42 `c2` char(5) DEFAULT NULL
43 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 PARTITION BY HASH (`c1`)
45 PARTITIONS 20
46 ALTER TABLE t1 COALESCE PARTITION 18;
47 SHOW TABLES;
48 Tables_in_test
49 t1
50 SELECT * FROM t1 ORDER BY c1;
51 c1 c2
52 0 abc
53 5 abc
54 10 abc
55 15 abc
56 20 abc
57 25 abc
58 30 abc
59 35 abc
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `c1` tinyint(4) NOT NULL,
64 `c2` char(5) DEFAULT NULL
65 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
66 PARTITION BY HASH (`c1`)
67 PARTITIONS 2
68 SHOW CREATE TABLE t1;
69 Table Create Table
70 t1 CREATE TABLE `t1` (
71 `c1` tinyint(4) NOT NULL,
72 `c2` char(5) DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
74 PARTITION BY HASH (`c1`)
75 PARTITIONS 2
76 DROP TABLE t1;
77 SHOW TABLES;
78 Tables_in_test
79 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
80 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
81 SELECT * FROM t1 ORDER BY c1;
82 c1 c2
83 0 abc
84 5 abc
85 10 abc
86 15 abc
87 20 abc
88 25 abc
89 30 abc
90 35 abc
91 SHOW TABLES;
92 Tables_in_test
93 t1
94 SHOW CREATE TABLE t1;
95 Table Create Table
96 t1 CREATE TABLE `t1` (
97 `c1` smallint(6) NOT NULL,
98 `c2` char(5) DEFAULT NULL
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
100 PARTITION BY HASH (`c1`)
101 PARTITIONS 10
102 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
103 SELECT * FROM t1 ORDER BY c1;
104 c1 c2
105 0 abc
106 5 abc
107 10 abc
108 15 abc
109 20 abc
110 25 abc
111 30 abc
112 35 abc
113 SHOW TABLES;
114 Tables_in_test
115 t1
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `c1` smallint(6) NOT NULL,
120 `c2` char(5) DEFAULT NULL
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
122 PARTITION BY HASH (`c1`)
123 PARTITIONS 20
124 ALTER TABLE t1 COALESCE PARTITION 18;
125 SELECT * FROM t1 ORDER BY c1;
126 c1 c2
127 0 abc
128 5 abc
129 10 abc
130 15 abc
131 20 abc
132 25 abc
133 30 abc
134 35 abc
135 SHOW TABLES;
136 Tables_in_test
137 t1
138 SHOW CREATE TABLE t1;
139 Table Create Table
140 t1 CREATE TABLE `t1` (
141 `c1` smallint(6) NOT NULL,
142 `c2` char(5) DEFAULT NULL
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
144 PARTITION BY HASH (`c1`)
145 PARTITIONS 2
146 SHOW CREATE TABLE t1;
147 Table Create Table
148 t1 CREATE TABLE `t1` (
149 `c1` smallint(6) NOT NULL,
150 `c2` char(5) DEFAULT NULL
151 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
152 PARTITION BY HASH (`c1`)
153 PARTITIONS 2
154 DROP TABLE t1;
155 SHOW TABLES;
156 Tables_in_test
157 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
158 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
159 SELECT * FROM t1 ORDER BY c1;
160 c1 c2
161 0 abc
162 5 abc
163 10 abc
164 15 abc
165 20 abc
166 25 abc
167 30 abc
168 35 abc
169 SHOW TABLES;
170 Tables_in_test
171 t1
172 SHOW CREATE TABLE t1;
173 Table Create Table
174 t1 CREATE TABLE `t1` (
175 `c1` mediumint(9) NOT NULL,
176 `c2` char(5) DEFAULT NULL
177 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
178 PARTITION BY HASH (`c1`)
179 PARTITIONS 10
180 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
181 SELECT * FROM t1 ORDER BY c1;
182 c1 c2
183 0 abc
184 5 abc
185 10 abc
186 15 abc
187 20 abc
188 25 abc
189 30 abc
190 35 abc
191 SHOW TABLES;
192 Tables_in_test
193 t1
194 SHOW CREATE TABLE t1;
195 Table Create Table
196 t1 CREATE TABLE `t1` (
197 `c1` mediumint(9) NOT NULL,
198 `c2` char(5) DEFAULT NULL
199 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
200 PARTITION BY HASH (`c1`)
201 PARTITIONS 20
202 ALTER TABLE t1 COALESCE PARTITION 18;
203 SELECT * FROM t1 ORDER BY c1;
204 c1 c2
205 0 abc
206 5 abc
207 10 abc
208 15 abc
209 20 abc
210 25 abc
211 30 abc
212 35 abc
213 SHOW TABLES;
214 Tables_in_test
215 t1
216 SHOW CREATE TABLE t1;
217 Table Create Table
218 t1 CREATE TABLE `t1` (
219 `c1` mediumint(9) NOT NULL,
220 `c2` char(5) DEFAULT NULL
221 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
222 PARTITION BY HASH (`c1`)
223 PARTITIONS 2
224 SHOW CREATE TABLE t1;
225 Table Create Table
226 t1 CREATE TABLE `t1` (
227 `c1` mediumint(9) NOT NULL,
228 `c2` char(5) DEFAULT NULL
229 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
230 PARTITION BY HASH (`c1`)
231 PARTITIONS 2
232 DROP TABLE t1;
233 SHOW TABLES;
234 Tables_in_test
235 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
236 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
237 SELECT * FROM t1 ORDER BY c1;
238 c1 c2
239 0 abc
240 5 abc
241 10 abc
242 15 abc
243 20 abc
244 25 abc
245 30 abc
246 35 abc
247 SHOW TABLES;
248 Tables_in_test
249 t1
250 SHOW CREATE TABLE t1;
251 Table Create Table
252 t1 CREATE TABLE `t1` (
253 `c1` int(11) NOT NULL,
254 `c2` char(5) DEFAULT NULL
255 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
256 PARTITION BY HASH (`c1`)
257 PARTITIONS 10
258 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
259 SELECT * FROM t1 ORDER BY c1;
260 c1 c2
261 0 abc
262 5 abc
263 10 abc
264 15 abc
265 20 abc
266 25 abc
267 30 abc
268 35 abc
269 SHOW TABLES;
270 Tables_in_test
271 t1
272 SHOW CREATE TABLE t1;
273 Table Create Table
274 t1 CREATE TABLE `t1` (
275 `c1` int(11) NOT NULL,
276 `c2` char(5) DEFAULT NULL
277 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
278 PARTITION BY HASH (`c1`)
279 PARTITIONS 20
280 ALTER TABLE t1 COALESCE PARTITION 18;
281 SELECT * FROM t1 ORDER BY c1;
282 c1 c2
283 0 abc
284 5 abc
285 10 abc
286 15 abc
287 20 abc
288 25 abc
289 30 abc
290 35 abc
291 SHOW TABLES;
292 Tables_in_test
293 t1
294 SHOW CREATE TABLE t1;
295 Table Create Table
296 t1 CREATE TABLE `t1` (
297 `c1` int(11) NOT NULL,
298 `c2` char(5) DEFAULT NULL
299 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
300 PARTITION BY HASH (`c1`)
301 PARTITIONS 2
302 SHOW CREATE TABLE t1;
303 Table Create Table
304 t1 CREATE TABLE `t1` (
305 `c1` int(11) NOT NULL,
306 `c2` char(5) DEFAULT NULL
307 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
308 PARTITION BY HASH (`c1`)
309 PARTITIONS 2
310 DROP TABLE t1;
311 SHOW TABLES;
312 Tables_in_test
313 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
314 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
315 SELECT * FROM t1 ORDER BY c1;
316 c1 c2
317 0 abc
318 5 abc
319 10 abc
320 15 abc
321 20 abc
322 25 abc
323 30 abc
324 35 abc
325 SHOW TABLES;
326 Tables_in_test
327 t1
328 SHOW CREATE TABLE t1;
329 Table Create Table
330 t1 CREATE TABLE `t1` (
331 `c1` int(11) NOT NULL,
332 `c2` char(5) DEFAULT NULL
333 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
334 PARTITION BY HASH (`c1`)
335 PARTITIONS 10
336 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
337 SELECT * FROM t1 ORDER BY c1;
338 c1 c2
339 0 abc
340 5 abc
341 10 abc
342 15 abc
343 20 abc
344 25 abc
345 30 abc
346 35 abc
347 SHOW TABLES;
348 Tables_in_test
349 t1
350 SHOW CREATE TABLE t1;
351 Table Create Table
352 t1 CREATE TABLE `t1` (
353 `c1` int(11) NOT NULL,
354 `c2` char(5) DEFAULT NULL
355 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
356 PARTITION BY HASH (`c1`)
357 PARTITIONS 20
358 ALTER TABLE t1 COALESCE PARTITION 18;
359 SELECT * FROM t1 ORDER BY c1;
360 c1 c2
361 0 abc
362 5 abc
363 10 abc
364 15 abc
365 20 abc
366 25 abc
367 30 abc
368 35 abc
369 SHOW TABLES;
370 Tables_in_test
371 t1
372 SHOW CREATE TABLE t1;
373 Table Create Table
374 t1 CREATE TABLE `t1` (
375 `c1` int(11) NOT NULL,
376 `c2` char(5) DEFAULT NULL
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
378 PARTITION BY HASH (`c1`)
379 PARTITIONS 2
380 SHOW CREATE TABLE t1;
381 Table Create Table
382 t1 CREATE TABLE `t1` (
383 `c1` int(11) NOT NULL,
384 `c2` char(5) DEFAULT NULL
385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
386 PARTITION BY HASH (`c1`)
387 PARTITIONS 2
388 DROP TABLE t1;
389 SHOW TABLES;
390 Tables_in_test
391 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
392 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
393 SELECT * FROM t1 ORDER BY c1;
394 c1 c2
395 0 abc
396 5 abc
397 10 abc
398 15 abc
399 20 abc
400 25 abc
401 30 abc
402 35 abc
403 SHOW TABLES;
404 Tables_in_test
405 t1
406 SHOW CREATE TABLE t1;
407 Table Create Table
408 t1 CREATE TABLE `t1` (
409 `c1` bigint(20) NOT NULL,
410 `c2` char(5) DEFAULT NULL
411 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
412 PARTITION BY HASH (`c1`)
413 PARTITIONS 10
414 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
415 SELECT * FROM t1 ORDER BY c1;
416 c1 c2
417 0 abc
418 5 abc
419 10 abc
420 15 abc
421 20 abc
422 25 abc
423 30 abc
424 35 abc
425 SHOW TABLES;
426 Tables_in_test
427 t1
428 SHOW CREATE TABLE t1;
429 Table Create Table
430 t1 CREATE TABLE `t1` (
431 `c1` bigint(20) NOT NULL,
432 `c2` char(5) DEFAULT NULL
433 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
434 PARTITION BY HASH (`c1`)
435 PARTITIONS 20
436 ALTER TABLE t1 COALESCE PARTITION 18;
437 SELECT * FROM t1 ORDER BY c1;
438 c1 c2
439 0 abc
440 5 abc
441 10 abc
442 15 abc
443 20 abc
444 25 abc
445 30 abc
446 35 abc
447 SHOW TABLES;
448 Tables_in_test
449 t1
450 SHOW CREATE TABLE t1;
451 Table Create Table
452 t1 CREATE TABLE `t1` (
453 `c1` bigint(20) NOT NULL,
454 `c2` char(5) DEFAULT NULL
455 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
456 PARTITION BY HASH (`c1`)
457 PARTITIONS 2
458 SHOW CREATE TABLE t1;
459 Table Create Table
460 t1 CREATE TABLE `t1` (
461 `c1` bigint(20) NOT NULL,
462 `c2` char(5) DEFAULT NULL
463 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
464 PARTITION BY HASH (`c1`)
465 PARTITIONS 2
466 DROP TABLE t1;
467 SHOW TABLES;
468 Tables_in_test
469 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
470 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
471 SELECT * FROM t1 ORDER BY c1;
472 c1 c2
473 0 abc
474 5 abc
475 10 abc
476 15 abc
477 20 abc
478 25 abc
479 30 abc
480 35 abc
481 SHOW TABLES;
482 Tables_in_test
483 t1
484 SHOW CREATE TABLE t1;
485 Table Create Table
486 t1 CREATE TABLE `t1` (
487 `c1` tinyint(4) NOT NULL,
488 `c2` char(5) DEFAULT NULL
489 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
490 PARTITION BY KEY (`c1`)
491 PARTITIONS 10
492 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
493 SELECT * FROM t1 ORDER BY c1;
494 c1 c2
495 0 abc
496 5 abc
497 10 abc
498 15 abc
499 20 abc
500 25 abc
501 30 abc
502 35 abc
503 SHOW TABLES;
504 Tables_in_test
505 t1
506 SHOW CREATE TABLE t1;
507 Table Create Table
508 t1 CREATE TABLE `t1` (
509 `c1` tinyint(4) NOT NULL,
510 `c2` char(5) DEFAULT NULL
511 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
512 PARTITION BY KEY (`c1`)
513 PARTITIONS 20
514 ALTER TABLE t1 COALESCE PARTITION 18;
515 SELECT * FROM t1 ORDER BY c1;
516 c1 c2
517 0 abc
518 5 abc
519 10 abc
520 15 abc
521 20 abc
522 25 abc
523 30 abc
524 35 abc
525 SHOW TABLES;
526 Tables_in_test
527 t1
528 SHOW CREATE TABLE t1;
529 Table Create Table
530 t1 CREATE TABLE `t1` (
531 `c1` tinyint(4) NOT NULL,
532 `c2` char(5) DEFAULT NULL
533 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
534 PARTITION BY KEY (`c1`)
535 PARTITIONS 2
536 SHOW CREATE TABLE t1;
537 Table Create Table
538 t1 CREATE TABLE `t1` (
539 `c1` tinyint(4) NOT NULL,
540 `c2` char(5) DEFAULT NULL
541 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
542 PARTITION BY KEY (`c1`)
543 PARTITIONS 2
544 DROP TABLE t1;
545 SHOW TABLES;
546 Tables_in_test
547 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
548 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
549 SELECT * FROM t1 ORDER BY c1;
550 c1 c2
551 0 abc
552 5 abc
553 10 abc
554 15 abc
555 20 abc
556 25 abc
557 30 abc
558 35 abc
559 SHOW TABLES;
560 Tables_in_test
561 t1
562 SHOW CREATE TABLE t1;
563 Table Create Table
564 t1 CREATE TABLE `t1` (
565 `c1` smallint(6) NOT NULL,
566 `c2` char(5) DEFAULT NULL
567 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
568 PARTITION BY KEY (`c1`)
569 PARTITIONS 10
570 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
571 SELECT * FROM t1 ORDER BY c1;
572 c1 c2
573 0 abc
574 5 abc
575 10 abc
576 15 abc
577 20 abc
578 25 abc
579 30 abc
580 35 abc
581 SHOW TABLES;
582 Tables_in_test
583 t1
584 SHOW CREATE TABLE t1;
585 Table Create Table
586 t1 CREATE TABLE `t1` (
587 `c1` smallint(6) NOT NULL,
588 `c2` char(5) DEFAULT NULL
589 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
590 PARTITION BY KEY (`c1`)
591 PARTITIONS 20
592 ALTER TABLE t1 COALESCE PARTITION 18;
593 SELECT * FROM t1 ORDER BY c1;
594 c1 c2
595 0 abc
596 5 abc
597 10 abc
598 15 abc
599 20 abc
600 25 abc
601 30 abc
602 35 abc
603 SHOW TABLES;
604 Tables_in_test
605 t1
606 SHOW CREATE TABLE t1;
607 Table Create Table
608 t1 CREATE TABLE `t1` (
609 `c1` smallint(6) NOT NULL,
610 `c2` char(5) DEFAULT NULL
611 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
612 PARTITION BY KEY (`c1`)
613 PARTITIONS 2
614 SHOW CREATE TABLE t1;
615 Table Create Table
616 t1 CREATE TABLE `t1` (
617 `c1` smallint(6) NOT NULL,
618 `c2` char(5) DEFAULT NULL
619 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
620 PARTITION BY KEY (`c1`)
621 PARTITIONS 2
622 DROP TABLE t1;
623 SHOW TABLES;
624 Tables_in_test
625 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
626 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
627 SELECT * FROM t1 ORDER BY c1;
628 c1 c2
629 0 abc
630 5 abc
631 10 abc
632 15 abc
633 20 abc
634 25 abc
635 30 abc
636 35 abc
637 SHOW TABLES;
638 Tables_in_test
639 t1
640 SHOW CREATE TABLE t1;
641 Table Create Table
642 t1 CREATE TABLE `t1` (
643 `c1` mediumint(9) NOT NULL,
644 `c2` char(5) DEFAULT NULL
645 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
646 PARTITION BY KEY (`c1`)
647 PARTITIONS 10
648 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
649 SELECT * FROM t1 ORDER BY c1;
650 c1 c2
651 0 abc
652 5 abc
653 10 abc
654 15 abc
655 20 abc
656 25 abc
657 30 abc
658 35 abc
659 SHOW TABLES;
660 Tables_in_test
661 t1
662 SHOW CREATE TABLE t1;
663 Table Create Table
664 t1 CREATE TABLE `t1` (
665 `c1` mediumint(9) NOT NULL,
666 `c2` char(5) DEFAULT NULL
667 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
668 PARTITION BY KEY (`c1`)
669 PARTITIONS 20
670 ALTER TABLE t1 COALESCE PARTITION 18;
671 SELECT * FROM t1 ORDER BY c1;
672 c1 c2
673 0 abc
674 5 abc
675 10 abc
676 15 abc
677 20 abc
678 25 abc
679 30 abc
680 35 abc
681 SHOW TABLES;
682 Tables_in_test
683 t1
684 SHOW CREATE TABLE t1;
685 Table Create Table
686 t1 CREATE TABLE `t1` (
687 `c1` mediumint(9) NOT NULL,
688 `c2` char(5) DEFAULT NULL
689 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
690 PARTITION BY KEY (`c1`)
691 PARTITIONS 2
692 SHOW CREATE TABLE t1;
693 Table Create Table
694 t1 CREATE TABLE `t1` (
695 `c1` mediumint(9) NOT NULL,
696 `c2` char(5) DEFAULT NULL
697 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
698 PARTITION BY KEY (`c1`)
699 PARTITIONS 2
700 DROP TABLE t1;
701 SHOW TABLES;
702 Tables_in_test
703 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
704 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
705 SELECT * FROM t1 ORDER BY c1;
706 c1 c2
707 0 abc
708 5 abc
709 10 abc
710 15 abc
711 20 abc
712 25 abc
713 30 abc
714 35 abc
715 SHOW TABLES;
716 Tables_in_test
717 t1
718 SHOW CREATE TABLE t1;
719 Table Create Table
720 t1 CREATE TABLE `t1` (
721 `c1` int(11) NOT NULL,
722 `c2` char(5) DEFAULT NULL
723 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
724 PARTITION BY KEY (`c1`)
725 PARTITIONS 10
726 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
727 SELECT * FROM t1 ORDER BY c1;
728 c1 c2
729 0 abc
730 5 abc
731 10 abc
732 15 abc
733 20 abc
734 25 abc
735 30 abc
736 35 abc
737 SHOW TABLES;
738 Tables_in_test
739 t1
740 SHOW CREATE TABLE t1;
741 Table Create Table
742 t1 CREATE TABLE `t1` (
743 `c1` int(11) NOT NULL,
744 `c2` char(5) DEFAULT NULL
745 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
746 PARTITION BY KEY (`c1`)
747 PARTITIONS 20
748 ALTER TABLE t1 COALESCE PARTITION 18;
749 SELECT * FROM t1 ORDER BY c1;
750 c1 c2
751 0 abc
752 5 abc
753 10 abc
754 15 abc
755 20 abc
756 25 abc
757 30 abc
758 35 abc
759 SHOW TABLES;
760 Tables_in_test
761 t1
762 SHOW CREATE TABLE t1;
763 Table Create Table
764 t1 CREATE TABLE `t1` (
765 `c1` int(11) NOT NULL,
766 `c2` char(5) DEFAULT NULL
767 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
768 PARTITION BY KEY (`c1`)
769 PARTITIONS 2
770 SHOW CREATE TABLE t1;
771 Table Create Table
772 t1 CREATE TABLE `t1` (
773 `c1` int(11) NOT NULL,
774 `c2` char(5) DEFAULT NULL
775 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
776 PARTITION BY KEY (`c1`)
777 PARTITIONS 2
778 DROP TABLE t1;
779 SHOW TABLES;
780 Tables_in_test
781 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
782 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
783 SELECT * FROM t1 ORDER BY c1;
784 c1 c2
785 0 abc
786 5 abc
787 10 abc
788 15 abc
789 20 abc
790 25 abc
791 30 abc
792 35 abc
793 SHOW TABLES;
794 Tables_in_test
795 t1
796 SHOW CREATE TABLE t1;
797 Table Create Table
798 t1 CREATE TABLE `t1` (
799 `c1` int(11) NOT NULL,
800 `c2` char(5) DEFAULT NULL
801 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
802 PARTITION BY KEY (`c1`)
803 PARTITIONS 10
804 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
805 SELECT * FROM t1 ORDER BY c1;
806 c1 c2
807 0 abc
808 5 abc
809 10 abc
810 15 abc
811 20 abc
812 25 abc
813 30 abc
814 35 abc
815 SHOW TABLES;
816 Tables_in_test
817 t1
818 SHOW CREATE TABLE t1;
819 Table Create Table
820 t1 CREATE TABLE `t1` (
821 `c1` int(11) NOT NULL,
822 `c2` char(5) DEFAULT NULL
823 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
824 PARTITION BY KEY (`c1`)
825 PARTITIONS 20
826 ALTER TABLE t1 COALESCE PARTITION 18;
827 SELECT * FROM t1 ORDER BY c1;
828 c1 c2
829 0 abc
830 5 abc
831 10 abc
832 15 abc
833 20 abc
834 25 abc
835 30 abc
836 35 abc
837 SHOW TABLES;
838 Tables_in_test
839 t1
840 SHOW CREATE TABLE t1;
841 Table Create Table
842 t1 CREATE TABLE `t1` (
843 `c1` int(11) NOT NULL,
844 `c2` char(5) DEFAULT NULL
845 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
846 PARTITION BY KEY (`c1`)
847 PARTITIONS 2
848 SHOW CREATE TABLE t1;
849 Table Create Table
850 t1 CREATE TABLE `t1` (
851 `c1` int(11) NOT NULL,
852 `c2` char(5) DEFAULT NULL
853 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
854 PARTITION BY KEY (`c1`)
855 PARTITIONS 2
856 DROP TABLE t1;
857 SHOW TABLES;
858 Tables_in_test
859 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
860 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
861 SELECT * FROM t1 ORDER BY c1;
862 c1 c2
863 0 abc
864 5 abc
865 10 abc
866 15 abc
867 20 abc
868 25 abc
869 30 abc
870 35 abc
871 SHOW TABLES;
872 Tables_in_test
873 t1
874 SHOW CREATE TABLE t1;
875 Table Create Table
876 t1 CREATE TABLE `t1` (
877 `c1` bigint(20) NOT NULL,
878 `c2` char(5) DEFAULT NULL
879 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
880 PARTITION BY KEY (`c1`)
881 PARTITIONS 10
882 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
883 SELECT * FROM t1 ORDER BY c1;
884 c1 c2
885 0 abc
886 5 abc
887 10 abc
888 15 abc
889 20 abc
890 25 abc
891 30 abc
892 35 abc
893 SHOW TABLES;
894 Tables_in_test
895 t1
896 SHOW CREATE TABLE t1;
897 Table Create Table
898 t1 CREATE TABLE `t1` (
899 `c1` bigint(20) NOT NULL,
900 `c2` char(5) DEFAULT NULL
901 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
902 PARTITION BY KEY (`c1`)
903 PARTITIONS 20
904 ALTER TABLE t1 COALESCE PARTITION 18;
905 SELECT * FROM t1 ORDER BY c1;
906 c1 c2
907 0 abc
908 5 abc
909 10 abc
910 15 abc
911 20 abc
912 25 abc
913 30 abc
914 35 abc
915 SHOW TABLES;
916 Tables_in_test
917 t1
918 SHOW CREATE TABLE t1;
919 Table Create Table
920 t1 CREATE TABLE `t1` (
921 `c1` bigint(20) NOT NULL,
922 `c2` char(5) DEFAULT NULL
923 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
924 PARTITION BY KEY (`c1`)
925 PARTITIONS 2
926 SHOW CREATE TABLE t1;
927 Table Create Table
928 t1 CREATE TABLE `t1` (
929 `c1` bigint(20) NOT NULL,
930 `c2` char(5) DEFAULT NULL
931 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
932 PARTITION BY KEY (`c1`)
933 PARTITIONS 2
934 DROP TABLE t1;
935 SHOW TABLES;
936 Tables_in_test
937 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
938 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
939 SELECT * FROM t1 ORDER BY c1;
940 c1 c2
941 0 abc
942 5 abc
943 10 abc
944 15 abc
945 20 abc
946 25 abc
947 30 abc
948 35 abc
949 SHOW TABLES;
950 Tables_in_test
951 t1
952 SHOW CREATE TABLE t1;
953 Table Create Table
954 t1 CREATE TABLE `t1` (
955 `c1` tinyint(4) NOT NULL,
956 `c2` char(5) DEFAULT NULL
957 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
958 PARTITION BY LINEAR KEY (`c1`)
959 PARTITIONS 10
960 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
961 SELECT * FROM t1 ORDER BY c1;
962 c1 c2
963 0 abc
964 5 abc
965 10 abc
966 15 abc
967 20 abc
968 25 abc
969 30 abc
970 35 abc
971 SHOW TABLES;
972 Tables_in_test
973 t1
974 SHOW CREATE TABLE t1;
975 Table Create Table
976 t1 CREATE TABLE `t1` (
977 `c1` tinyint(4) NOT NULL,
978 `c2` char(5) DEFAULT NULL
979 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
980 PARTITION BY LINEAR KEY (`c1`)
981 PARTITIONS 20
982 ALTER TABLE t1 COALESCE PARTITION 18;
983 SELECT * FROM t1 ORDER BY c1;
984 c1 c2
985 0 abc
986 5 abc
987 10 abc
988 15 abc
989 20 abc
990 25 abc
991 30 abc
992 35 abc
993 SHOW TABLES;
994 Tables_in_test
995 t1
996 SHOW CREATE TABLE t1;
997 Table Create Table
998 t1 CREATE TABLE `t1` (
999 `c1` tinyint(4) NOT NULL,
1000 `c2` char(5) DEFAULT NULL
1001 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1002 PARTITION BY LINEAR KEY (`c1`)
1003 PARTITIONS 2
1004 SHOW CREATE TABLE t1;
1005 Table Create Table
1006 t1 CREATE TABLE `t1` (
1007 `c1` tinyint(4) NOT NULL,
1008 `c2` char(5) DEFAULT NULL
1009 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1010 PARTITION BY LINEAR KEY (`c1`)
1011 PARTITIONS 2
1012 DROP TABLE t1;
1013 SHOW TABLES;
1014 Tables_in_test
1015 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1016 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1017 SELECT * FROM t1 ORDER BY c1;
1018 c1 c2
1019 0 abc
1020 5 abc
1021 10 abc
1022 15 abc
1023 20 abc
1024 25 abc
1025 30 abc
1026 35 abc
1027 SHOW TABLES;
1028 Tables_in_test
1029 t1
1030 SHOW CREATE TABLE t1;
1031 Table Create Table
1032 t1 CREATE TABLE `t1` (
1033 `c1` smallint(6) NOT NULL,
1034 `c2` char(5) DEFAULT NULL
1035 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1036 PARTITION BY LINEAR KEY (`c1`)
1037 PARTITIONS 10
1038 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1039 SELECT * FROM t1 ORDER BY c1;
1040 c1 c2
1041 0 abc
1042 5 abc
1043 10 abc
1044 15 abc
1045 20 abc
1046 25 abc
1047 30 abc
1048 35 abc
1049 SHOW TABLES;
1050 Tables_in_test
1051 t1
1052 SHOW CREATE TABLE t1;
1053 Table Create Table
1054 t1 CREATE TABLE `t1` (
1055 `c1` smallint(6) NOT NULL,
1056 `c2` char(5) DEFAULT NULL
1057 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1058 PARTITION BY LINEAR KEY (`c1`)
1059 PARTITIONS 20
1060 ALTER TABLE t1 COALESCE PARTITION 18;
1061 SELECT * FROM t1 ORDER BY c1;
1062 c1 c2
1063 0 abc
1064 5 abc
1065 10 abc
1066 15 abc
1067 20 abc
1068 25 abc
1069 30 abc
1070 35 abc
1071 SHOW TABLES;
1072 Tables_in_test
1073 t1
1074 SHOW CREATE TABLE t1;
1075 Table Create Table
1076 t1 CREATE TABLE `t1` (
1077 `c1` smallint(6) NOT NULL,
1078 `c2` char(5) DEFAULT NULL
1079 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1080 PARTITION BY LINEAR KEY (`c1`)
1081 PARTITIONS 2
1082 SHOW CREATE TABLE t1;
1083 Table Create Table
1084 t1 CREATE TABLE `t1` (
1085 `c1` smallint(6) NOT NULL,
1086 `c2` char(5) DEFAULT NULL
1087 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1088 PARTITION BY LINEAR KEY (`c1`)
1089 PARTITIONS 2
1090 DROP TABLE t1;
1091 SHOW TABLES;
1092 Tables_in_test
1093 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1094 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1095 SELECT * FROM t1 ORDER BY c1;
1096 c1 c2
1097 0 abc
1098 5 abc
1099 10 abc
1100 15 abc
1101 20 abc
1102 25 abc
1103 30 abc
1104 35 abc
1105 SHOW TABLES;
1106 Tables_in_test
1107 t1
1108 SHOW CREATE TABLE t1;
1109 Table Create Table
1110 t1 CREATE TABLE `t1` (
1111 `c1` mediumint(9) NOT NULL,
1112 `c2` char(5) DEFAULT NULL
1113 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1114 PARTITION BY LINEAR KEY (`c1`)
1115 PARTITIONS 10
1116 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1117 SELECT * FROM t1 ORDER BY c1;
1118 c1 c2
1119 0 abc
1120 5 abc
1121 10 abc
1122 15 abc
1123 20 abc
1124 25 abc
1125 30 abc
1126 35 abc
1127 SHOW TABLES;
1128 Tables_in_test
1129 t1
1130 SHOW CREATE TABLE t1;
1131 Table Create Table
1132 t1 CREATE TABLE `t1` (
1133 `c1` mediumint(9) NOT NULL,
1134 `c2` char(5) DEFAULT NULL
1135 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1136 PARTITION BY LINEAR KEY (`c1`)
1137 PARTITIONS 20
1138 ALTER TABLE t1 COALESCE PARTITION 18;
1139 SELECT * FROM t1 ORDER BY c1;
1140 c1 c2
1141 0 abc
1142 5 abc
1143 10 abc
1144 15 abc
1145 20 abc
1146 25 abc
1147 30 abc
1148 35 abc
1149 SHOW TABLES;
1150 Tables_in_test
1151 t1
1152 SHOW CREATE TABLE t1;
1153 Table Create Table
1154 t1 CREATE TABLE `t1` (
1155 `c1` mediumint(9) NOT NULL,
1156 `c2` char(5) DEFAULT NULL
1157 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1158 PARTITION BY LINEAR KEY (`c1`)
1159 PARTITIONS 2
1160 SHOW CREATE TABLE t1;
1161 Table Create Table
1162 t1 CREATE TABLE `t1` (
1163 `c1` mediumint(9) NOT NULL,
1164 `c2` char(5) DEFAULT NULL
1165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1166 PARTITION BY LINEAR KEY (`c1`)
1167 PARTITIONS 2
1168 DROP TABLE t1;
1169 SHOW TABLES;
1170 Tables_in_test
1171 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1172 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1173 SELECT * FROM t1 ORDER BY c1;
1174 c1 c2
1175 0 abc
1176 5 abc
1177 10 abc
1178 15 abc
1179 20 abc
1180 25 abc
1181 30 abc
1182 35 abc
1183 SHOW TABLES;
1184 Tables_in_test
1185 t1
1186 SHOW CREATE TABLE t1;
1187 Table Create Table
1188 t1 CREATE TABLE `t1` (
1189 `c1` int(11) NOT NULL,
1190 `c2` char(5) DEFAULT NULL
1191 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1192 PARTITION BY LINEAR KEY (`c1`)
1193 PARTITIONS 10
1194 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1195 SELECT * FROM t1 ORDER BY c1;
1196 c1 c2
1197 0 abc
1198 5 abc
1199 10 abc
1200 15 abc
1201 20 abc
1202 25 abc
1203 30 abc
1204 35 abc
1205 SHOW TABLES;
1206 Tables_in_test
1207 t1
1208 SHOW CREATE TABLE t1;
1209 Table Create Table
1210 t1 CREATE TABLE `t1` (
1211 `c1` int(11) NOT NULL,
1212 `c2` char(5) DEFAULT NULL
1213 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1214 PARTITION BY LINEAR KEY (`c1`)
1215 PARTITIONS 20
1216 ALTER TABLE t1 COALESCE PARTITION 18;
1217 SELECT * FROM t1 ORDER BY c1;
1218 c1 c2
1219 0 abc
1220 5 abc
1221 10 abc
1222 15 abc
1223 20 abc
1224 25 abc
1225 30 abc
1226 35 abc
1227 SHOW TABLES;
1228 Tables_in_test
1229 t1
1230 SHOW CREATE TABLE t1;
1231 Table Create Table
1232 t1 CREATE TABLE `t1` (
1233 `c1` int(11) NOT NULL,
1234 `c2` char(5) DEFAULT NULL
1235 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1236 PARTITION BY LINEAR KEY (`c1`)
1237 PARTITIONS 2
1238 SHOW CREATE TABLE t1;
1239 Table Create Table
1240 t1 CREATE TABLE `t1` (
1241 `c1` int(11) NOT NULL,
1242 `c2` char(5) DEFAULT NULL
1243 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1244 PARTITION BY LINEAR KEY (`c1`)
1245 PARTITIONS 2
1246 DROP TABLE t1;
1247 SHOW TABLES;
1248 Tables_in_test
1249 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1250 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1251 SELECT * FROM t1 ORDER BY c1;
1252 c1 c2
1253 0 abc
1254 5 abc
1255 10 abc
1256 15 abc
1257 20 abc
1258 25 abc
1259 30 abc
1260 35 abc
1261 SHOW TABLES;
1262 Tables_in_test
1263 t1
1264 SHOW CREATE TABLE t1;
1265 Table Create Table
1266 t1 CREATE TABLE `t1` (
1267 `c1` int(11) NOT NULL,
1268 `c2` char(5) DEFAULT NULL
1269 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1270 PARTITION BY LINEAR KEY (`c1`)
1271 PARTITIONS 10
1272 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1273 SELECT * FROM t1 ORDER BY c1;
1274 c1 c2
1275 0 abc
1276 5 abc
1277 10 abc
1278 15 abc
1279 20 abc
1280 25 abc
1281 30 abc
1282 35 abc
1283 SHOW TABLES;
1284 Tables_in_test
1285 t1
1286 SHOW CREATE TABLE t1;
1287 Table Create Table
1288 t1 CREATE TABLE `t1` (
1289 `c1` int(11) NOT NULL,
1290 `c2` char(5) DEFAULT NULL
1291 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1292 PARTITION BY LINEAR KEY (`c1`)
1293 PARTITIONS 20
1294 ALTER TABLE t1 COALESCE PARTITION 18;
1295 SELECT * FROM t1 ORDER BY c1;
1296 c1 c2
1297 0 abc
1298 5 abc
1299 10 abc
1300 15 abc
1301 20 abc
1302 25 abc
1303 30 abc
1304 35 abc
1305 SHOW TABLES;
1306 Tables_in_test
1307 t1
1308 SHOW CREATE TABLE t1;
1309 Table Create Table
1310 t1 CREATE TABLE `t1` (
1311 `c1` int(11) NOT NULL,
1312 `c2` char(5) DEFAULT NULL
1313 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1314 PARTITION BY LINEAR KEY (`c1`)
1315 PARTITIONS 2
1316 SHOW CREATE TABLE t1;
1317 Table Create Table
1318 t1 CREATE TABLE `t1` (
1319 `c1` int(11) NOT NULL,
1320 `c2` char(5) DEFAULT NULL
1321 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1322 PARTITION BY LINEAR KEY (`c1`)
1323 PARTITIONS 2
1324 DROP TABLE t1;
1325 SHOW TABLES;
1326 Tables_in_test
1327 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1328 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1329 SELECT * FROM t1 ORDER BY c1;
1330 c1 c2
1331 0 abc
1332 5 abc
1333 10 abc
1334 15 abc
1335 20 abc
1336 25 abc
1337 30 abc
1338 35 abc
1339 SHOW TABLES;
1340 Tables_in_test
1341 t1
1342 SHOW CREATE TABLE t1;
1343 Table Create Table
1344 t1 CREATE TABLE `t1` (
1345 `c1` bigint(20) NOT NULL,
1346 `c2` char(5) DEFAULT NULL
1347 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1348 PARTITION BY LINEAR KEY (`c1`)
1349 PARTITIONS 10
1350 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1351 SELECT * FROM t1 ORDER BY c1;
1352 c1 c2
1353 0 abc
1354 5 abc
1355 10 abc
1356 15 abc
1357 20 abc
1358 25 abc
1359 30 abc
1360 35 abc
1361 SHOW TABLES;
1362 Tables_in_test
1363 t1
1364 SHOW CREATE TABLE t1;
1365 Table Create Table
1366 t1 CREATE TABLE `t1` (
1367 `c1` bigint(20) NOT NULL,
1368 `c2` char(5) DEFAULT NULL
1369 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1370 PARTITION BY LINEAR KEY (`c1`)
1371 PARTITIONS 20
1372 ALTER TABLE t1 COALESCE PARTITION 18;
1373 SELECT * FROM t1 ORDER BY c1;
1374 c1 c2
1375 0 abc
1376 5 abc
1377 10 abc
1378 15 abc
1379 20 abc
1380 25 abc
1381 30 abc
1382 35 abc
1383 SHOW TABLES;
1384 Tables_in_test
1385 t1
1386 SHOW CREATE TABLE t1;
1387 Table Create Table
1388 t1 CREATE TABLE `t1` (
1389 `c1` bigint(20) NOT NULL,
1390 `c2` char(5) DEFAULT NULL
1391 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1392 PARTITION BY LINEAR KEY (`c1`)
1393 PARTITIONS 2
1394 SHOW CREATE TABLE t1;
1395 Table Create Table
1396 t1 CREATE TABLE `t1` (
1397 `c1` bigint(20) NOT NULL,
1398 `c2` char(5) DEFAULT NULL
1399 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1400 PARTITION BY LINEAR KEY (`c1`)
1401 PARTITIONS 2
1402 DROP TABLE t1;
1403 SHOW TABLES;
1404 Tables_in_test