Debian Codegraph @

mysql-test/suite/parts/r/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 NOT NULL,
20 `c2` char(5) DEFAULT NULL
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
22 /*!50100 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 NOT NULL,
42 `c2` char(5) DEFAULT NULL
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 /*!50100 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 NOT NULL,
64 `c2` char(5) DEFAULT NULL
65 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
66 /*!50100 PARTITION BY HASH (`c1`)
67 PARTITIONS 2 */
68 SHOW CREATE TABLE t1;
69 Table Create Table
70 t1 CREATE TABLE `t1` (
71 `c1` tinyint NOT NULL,
72 `c2` char(5) DEFAULT NULL
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
74 /*!50100 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 NOT NULL,
98 `c2` char(5) DEFAULT NULL
99 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 /*!50100 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 NOT NULL,
120 `c2` char(5) DEFAULT NULL
121 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 /*!50100 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 NOT NULL,
142 `c2` char(5) DEFAULT NULL
143 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 /*!50100 PARTITION BY HASH (`c1`)
145 PARTITIONS 2 */
146 SHOW CREATE TABLE t1;
147 Table Create Table
148 t1 CREATE TABLE `t1` (
149 `c1` smallint NOT NULL,
150 `c2` char(5) DEFAULT NULL
151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
152 /*!50100 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 NOT NULL,
176 `c2` char(5) DEFAULT NULL
177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
178 /*!50100 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 NOT NULL,
198 `c2` char(5) DEFAULT NULL
199 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
200 /*!50100 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 NOT NULL,
220 `c2` char(5) DEFAULT NULL
221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
222 /*!50100 PARTITION BY HASH (`c1`)
223 PARTITIONS 2 */
224 SHOW CREATE TABLE t1;
225 Table Create Table
226 t1 CREATE TABLE `t1` (
227 `c1` mediumint NOT NULL,
228 `c2` char(5) DEFAULT NULL
229 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
230 /*!50100 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 NOT NULL,
254 `c2` char(5) DEFAULT NULL
255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
256 /*!50100 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 NOT NULL,
276 `c2` char(5) DEFAULT NULL
277 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
278 /*!50100 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 NOT NULL,
298 `c2` char(5) DEFAULT NULL
299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
300 /*!50100 PARTITION BY HASH (`c1`)
301 PARTITIONS 2 */
302 SHOW CREATE TABLE t1;
303 Table Create Table
304 t1 CREATE TABLE `t1` (
305 `c1` int NOT NULL,
306 `c2` char(5) DEFAULT NULL
307 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
308 /*!50100 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 NOT NULL,
332 `c2` char(5) DEFAULT NULL
333 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
334 /*!50100 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 NOT NULL,
354 `c2` char(5) DEFAULT NULL
355 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
356 /*!50100 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 NOT NULL,
376 `c2` char(5) DEFAULT NULL
377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 /*!50100 PARTITION BY HASH (`c1`)
379 PARTITIONS 2 */
380 SHOW CREATE TABLE t1;
381 Table Create Table
382 t1 CREATE TABLE `t1` (
383 `c1` int NOT NULL,
384 `c2` char(5) DEFAULT NULL
385 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
386 /*!50100 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 NOT NULL,
410 `c2` char(5) DEFAULT NULL
411 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
412 /*!50100 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 NOT NULL,
432 `c2` char(5) DEFAULT NULL
433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
434 /*!50100 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 NOT NULL,
454 `c2` char(5) DEFAULT NULL
455 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
456 /*!50100 PARTITION BY HASH (`c1`)
457 PARTITIONS 2 */
458 SHOW CREATE TABLE t1;
459 Table Create Table
460 t1 CREATE TABLE `t1` (
461 `c1` bigint NOT NULL,
462 `c2` char(5) DEFAULT NULL
463 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
464 /*!50100 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 NOT NULL,
488 `c2` char(5) DEFAULT NULL
489 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
490 /*!50100 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 NOT NULL,
510 `c2` char(5) DEFAULT NULL
511 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
512 /*!50100 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 NOT NULL,
532 `c2` char(5) DEFAULT NULL
533 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
534 /*!50100 PARTITION BY KEY (c1)
535 PARTITIONS 2 */
536 SHOW CREATE TABLE t1;
537 Table Create Table
538 t1 CREATE TABLE `t1` (
539 `c1` tinyint NOT NULL,
540 `c2` char(5) DEFAULT NULL
541 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
542 /*!50100 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 NOT NULL,
566 `c2` char(5) DEFAULT NULL
567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
568 /*!50100 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 NOT NULL,
588 `c2` char(5) DEFAULT NULL
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
590 /*!50100 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 NOT NULL,
610 `c2` char(5) DEFAULT NULL
611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
612 /*!50100 PARTITION BY KEY (c1)
613 PARTITIONS 2 */
614 SHOW CREATE TABLE t1;
615 Table Create Table
616 t1 CREATE TABLE `t1` (
617 `c1` smallint NOT NULL,
618 `c2` char(5) DEFAULT NULL
619 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
620 /*!50100 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 NOT NULL,
644 `c2` char(5) DEFAULT NULL
645 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
646 /*!50100 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 NOT NULL,
666 `c2` char(5) DEFAULT NULL
667 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
668 /*!50100 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 NOT NULL,
688 `c2` char(5) DEFAULT NULL
689 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
690 /*!50100 PARTITION BY KEY (c1)
691 PARTITIONS 2 */
692 SHOW CREATE TABLE t1;
693 Table Create Table
694 t1 CREATE TABLE `t1` (
695 `c1` mediumint NOT NULL,
696 `c2` char(5) DEFAULT NULL
697 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
698 /*!50100 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 NOT NULL,
722 `c2` char(5) DEFAULT NULL
723 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
724 /*!50100 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 NOT NULL,
744 `c2` char(5) DEFAULT NULL
745 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
746 /*!50100 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 NOT NULL,
766 `c2` char(5) DEFAULT NULL
767 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
768 /*!50100 PARTITION BY KEY (c1)
769 PARTITIONS 2 */
770 SHOW CREATE TABLE t1;
771 Table Create Table
772 t1 CREATE TABLE `t1` (
773 `c1` int NOT NULL,
774 `c2` char(5) DEFAULT NULL
775 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
776 /*!50100 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 NOT NULL,
800 `c2` char(5) DEFAULT NULL
801 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
802 /*!50100 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 NOT NULL,
822 `c2` char(5) DEFAULT NULL
823 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
824 /*!50100 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 NOT NULL,
844 `c2` char(5) DEFAULT NULL
845 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
846 /*!50100 PARTITION BY KEY (c1)
847 PARTITIONS 2 */
848 SHOW CREATE TABLE t1;
849 Table Create Table
850 t1 CREATE TABLE `t1` (
851 `c1` int NOT NULL,
852 `c2` char(5) DEFAULT NULL
853 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
854 /*!50100 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 NOT NULL,
878 `c2` char(5) DEFAULT NULL
879 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
880 /*!50100 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 NOT NULL,
900 `c2` char(5) DEFAULT NULL
901 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
902 /*!50100 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 NOT NULL,
922 `c2` char(5) DEFAULT NULL
923 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
924 /*!50100 PARTITION BY KEY (c1)
925 PARTITIONS 2 */
926 DROP TABLE t1;
927 SHOW TABLES;
928 Tables_in_test
929 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
930 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
931 SELECT * FROM t1 ORDER BY c1;
932 c1 c2
933 0 abc
934 5 abc
935 10 abc
936 15 abc
937 20 abc
938 25 abc
939 30 abc
940 35 abc
941 SHOW TABLES;
942 Tables_in_test
943 t1
944 SHOW CREATE TABLE t1;
945 Table Create Table
946 t1 CREATE TABLE `t1` (
947 `c1` tinyint NOT NULL,
948 `c2` char(5) DEFAULT NULL
949 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
950 /*!50100 PARTITION BY LINEAR KEY (c1)
951 PARTITIONS 10 */
952 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
953 SELECT * FROM t1 ORDER BY c1;
954 c1 c2
955 0 abc
956 5 abc
957 10 abc
958 15 abc
959 20 abc
960 25 abc
961 30 abc
962 35 abc
963 SHOW TABLES;
964 Tables_in_test
965 t1
966 SHOW CREATE TABLE t1;
967 Table Create Table
968 t1 CREATE TABLE `t1` (
969 `c1` tinyint NOT NULL,
970 `c2` char(5) DEFAULT NULL
971 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
972 /*!50100 PARTITION BY LINEAR KEY (c1)
973 PARTITIONS 20 */
974 ALTER TABLE t1 COALESCE PARTITION 18;
975 SELECT * FROM t1 ORDER BY c1;
976 c1 c2
977 0 abc
978 5 abc
979 10 abc
980 15 abc
981 20 abc
982 25 abc
983 30 abc
984 35 abc
985 SHOW TABLES;
986 Tables_in_test
987 t1
988 SHOW CREATE TABLE t1;
989 Table Create Table
990 t1 CREATE TABLE `t1` (
991 `c1` tinyint NOT NULL,
992 `c2` char(5) DEFAULT NULL
993 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
994 /*!50100 PARTITION BY LINEAR KEY (c1)
995 PARTITIONS 2 */
996 SHOW CREATE TABLE t1;
997 Table Create Table
998 t1 CREATE TABLE `t1` (
999 `c1` tinyint NOT NULL,
1000 `c2` char(5) DEFAULT NULL
1001 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1002 /*!50100 PARTITION BY LINEAR KEY (c1)
1003 PARTITIONS 2 */
1004 DROP TABLE t1;
1005 SHOW TABLES;
1006 Tables_in_test
1007 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1008 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1009 SELECT * FROM t1 ORDER BY c1;
1010 c1 c2
1011 0 abc
1012 5 abc
1013 10 abc
1014 15 abc
1015 20 abc
1016 25 abc
1017 30 abc
1018 35 abc
1019 SHOW TABLES;
1020 Tables_in_test
1021 t1
1022 SHOW CREATE TABLE t1;
1023 Table Create Table
1024 t1 CREATE TABLE `t1` (
1025 `c1` smallint NOT NULL,
1026 `c2` char(5) DEFAULT NULL
1027 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1028 /*!50100 PARTITION BY LINEAR KEY (c1)
1029 PARTITIONS 10 */
1030 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1031 SELECT * FROM t1 ORDER BY c1;
1032 c1 c2
1033 0 abc
1034 5 abc
1035 10 abc
1036 15 abc
1037 20 abc
1038 25 abc
1039 30 abc
1040 35 abc
1041 SHOW TABLES;
1042 Tables_in_test
1043 t1
1044 SHOW CREATE TABLE t1;
1045 Table Create Table
1046 t1 CREATE TABLE `t1` (
1047 `c1` smallint NOT NULL,
1048 `c2` char(5) DEFAULT NULL
1049 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1050 /*!50100 PARTITION BY LINEAR KEY (c1)
1051 PARTITIONS 20 */
1052 ALTER TABLE t1 COALESCE PARTITION 18;
1053 SELECT * FROM t1 ORDER BY c1;
1054 c1 c2
1055 0 abc
1056 5 abc
1057 10 abc
1058 15 abc
1059 20 abc
1060 25 abc
1061 30 abc
1062 35 abc
1063 SHOW TABLES;
1064 Tables_in_test
1065 t1
1066 SHOW CREATE TABLE t1;
1067 Table Create Table
1068 t1 CREATE TABLE `t1` (
1069 `c1` smallint NOT NULL,
1070 `c2` char(5) DEFAULT NULL
1071 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1072 /*!50100 PARTITION BY LINEAR KEY (c1)
1073 PARTITIONS 2 */
1074 SHOW CREATE TABLE t1;
1075 Table Create Table
1076 t1 CREATE TABLE `t1` (
1077 `c1` smallint NOT NULL,
1078 `c2` char(5) DEFAULT NULL
1079 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1080 /*!50100 PARTITION BY LINEAR KEY (c1)
1081 PARTITIONS 2 */
1082 DROP TABLE t1;
1083 SHOW TABLES;
1084 Tables_in_test
1085 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1086 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1087 SELECT * FROM t1 ORDER BY c1;
1088 c1 c2
1089 0 abc
1090 5 abc
1091 10 abc
1092 15 abc
1093 20 abc
1094 25 abc
1095 30 abc
1096 35 abc
1097 SHOW TABLES;
1098 Tables_in_test
1099 t1
1100 SHOW CREATE TABLE t1;
1101 Table Create Table
1102 t1 CREATE TABLE `t1` (
1103 `c1` mediumint NOT NULL,
1104 `c2` char(5) DEFAULT NULL
1105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1106 /*!50100 PARTITION BY LINEAR KEY (c1)
1107 PARTITIONS 10 */
1108 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1109 SELECT * FROM t1 ORDER BY c1;
1110 c1 c2
1111 0 abc
1112 5 abc
1113 10 abc
1114 15 abc
1115 20 abc
1116 25 abc
1117 30 abc
1118 35 abc
1119 SHOW TABLES;
1120 Tables_in_test
1121 t1
1122 SHOW CREATE TABLE t1;
1123 Table Create Table
1124 t1 CREATE TABLE `t1` (
1125 `c1` mediumint NOT NULL,
1126 `c2` char(5) DEFAULT NULL
1127 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1128 /*!50100 PARTITION BY LINEAR KEY (c1)
1129 PARTITIONS 20 */
1130 ALTER TABLE t1 COALESCE PARTITION 18;
1131 SELECT * FROM t1 ORDER BY c1;
1132 c1 c2
1133 0 abc
1134 5 abc
1135 10 abc
1136 15 abc
1137 20 abc
1138 25 abc
1139 30 abc
1140 35 abc
1141 SHOW TABLES;
1142 Tables_in_test
1143 t1
1144 SHOW CREATE TABLE t1;
1145 Table Create Table
1146 t1 CREATE TABLE `t1` (
1147 `c1` mediumint NOT NULL,
1148 `c2` char(5) DEFAULT NULL
1149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1150 /*!50100 PARTITION BY LINEAR KEY (c1)
1151 PARTITIONS 2 */
1152 SHOW CREATE TABLE t1;
1153 Table Create Table
1154 t1 CREATE TABLE `t1` (
1155 `c1` mediumint NOT NULL,
1156 `c2` char(5) DEFAULT NULL
1157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1158 /*!50100 PARTITION BY LINEAR KEY (c1)
1159 PARTITIONS 2 */
1160 DROP TABLE t1;
1161 SHOW TABLES;
1162 Tables_in_test
1163 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1164 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1165 SELECT * FROM t1 ORDER BY c1;
1166 c1 c2
1167 0 abc
1168 5 abc
1169 10 abc
1170 15 abc
1171 20 abc
1172 25 abc
1173 30 abc
1174 35 abc
1175 SHOW TABLES;
1176 Tables_in_test
1177 t1
1178 SHOW CREATE TABLE t1;
1179 Table Create Table
1180 t1 CREATE TABLE `t1` (
1181 `c1` int NOT NULL,
1182 `c2` char(5) DEFAULT NULL
1183 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1184 /*!50100 PARTITION BY LINEAR KEY (c1)
1185 PARTITIONS 10 */
1186 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1187 SELECT * FROM t1 ORDER BY c1;
1188 c1 c2
1189 0 abc
1190 5 abc
1191 10 abc
1192 15 abc
1193 20 abc
1194 25 abc
1195 30 abc
1196 35 abc
1197 SHOW TABLES;
1198 Tables_in_test
1199 t1
1200 SHOW CREATE TABLE t1;
1201 Table Create Table
1202 t1 CREATE TABLE `t1` (
1203 `c1` int NOT NULL,
1204 `c2` char(5) DEFAULT NULL
1205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1206 /*!50100 PARTITION BY LINEAR KEY (c1)
1207 PARTITIONS 20 */
1208 ALTER TABLE t1 COALESCE PARTITION 18;
1209 SELECT * FROM t1 ORDER BY c1;
1210 c1 c2
1211 0 abc
1212 5 abc
1213 10 abc
1214 15 abc
1215 20 abc
1216 25 abc
1217 30 abc
1218 35 abc
1219 SHOW TABLES;
1220 Tables_in_test
1221 t1
1222 SHOW CREATE TABLE t1;
1223 Table Create Table
1224 t1 CREATE TABLE `t1` (
1225 `c1` int NOT NULL,
1226 `c2` char(5) DEFAULT NULL
1227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1228 /*!50100 PARTITION BY LINEAR KEY (c1)
1229 PARTITIONS 2 */
1230 SHOW CREATE TABLE t1;
1231 Table Create Table
1232 t1 CREATE TABLE `t1` (
1233 `c1` int NOT NULL,
1234 `c2` char(5) DEFAULT NULL
1235 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1236 /*!50100 PARTITION BY LINEAR KEY (c1)
1237 PARTITIONS 2 */
1238 DROP TABLE t1;
1239 SHOW TABLES;
1240 Tables_in_test
1241 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1242 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1243 SELECT * FROM t1 ORDER BY c1;
1244 c1 c2
1245 0 abc
1246 5 abc
1247 10 abc
1248 15 abc
1249 20 abc
1250 25 abc
1251 30 abc
1252 35 abc
1253 SHOW TABLES;
1254 Tables_in_test
1255 t1
1256 SHOW CREATE TABLE t1;
1257 Table Create Table
1258 t1 CREATE TABLE `t1` (
1259 `c1` int NOT NULL,
1260 `c2` char(5) DEFAULT NULL
1261 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1262 /*!50100 PARTITION BY LINEAR KEY (c1)
1263 PARTITIONS 10 */
1264 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1265 SELECT * FROM t1 ORDER BY c1;
1266 c1 c2
1267 0 abc
1268 5 abc
1269 10 abc
1270 15 abc
1271 20 abc
1272 25 abc
1273 30 abc
1274 35 abc
1275 SHOW TABLES;
1276 Tables_in_test
1277 t1
1278 SHOW CREATE TABLE t1;
1279 Table Create Table
1280 t1 CREATE TABLE `t1` (
1281 `c1` int NOT NULL,
1282 `c2` char(5) DEFAULT NULL
1283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1284 /*!50100 PARTITION BY LINEAR KEY (c1)
1285 PARTITIONS 20 */
1286 ALTER TABLE t1 COALESCE PARTITION 18;
1287 SELECT * FROM t1 ORDER BY c1;
1288 c1 c2
1289 0 abc
1290 5 abc
1291 10 abc
1292 15 abc
1293 20 abc
1294 25 abc
1295 30 abc
1296 35 abc
1297 SHOW TABLES;
1298 Tables_in_test
1299 t1
1300 SHOW CREATE TABLE t1;
1301 Table Create Table
1302 t1 CREATE TABLE `t1` (
1303 `c1` int NOT NULL,
1304 `c2` char(5) DEFAULT NULL
1305 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1306 /*!50100 PARTITION BY LINEAR KEY (c1)
1307 PARTITIONS 2 */
1308 SHOW CREATE TABLE t1;
1309 Table Create Table
1310 t1 CREATE TABLE `t1` (
1311 `c1` int NOT NULL,
1312 `c2` char(5) DEFAULT NULL
1313 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1314 /*!50100 PARTITION BY LINEAR KEY (c1)
1315 PARTITIONS 2 */
1316 DROP TABLE t1;
1317 SHOW TABLES;
1318 Tables_in_test
1319 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
1320 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
1321 SELECT * FROM t1 ORDER BY c1;
1322 c1 c2
1323 0 abc
1324 5 abc
1325 10 abc
1326 15 abc
1327 20 abc
1328 25 abc
1329 30 abc
1330 35 abc
1331 SHOW TABLES;
1332 Tables_in_test
1333 t1
1334 SHOW CREATE TABLE t1;
1335 Table Create Table
1336 t1 CREATE TABLE `t1` (
1337 `c1` bigint NOT NULL,
1338 `c2` char(5) DEFAULT NULL
1339 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1340 /*!50100 PARTITION BY LINEAR KEY (c1)
1341 PARTITIONS 10 */
1342 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
1343 SELECT * FROM t1 ORDER BY c1;
1344 c1 c2
1345 0 abc
1346 5 abc
1347 10 abc
1348 15 abc
1349 20 abc
1350 25 abc
1351 30 abc
1352 35 abc
1353 SHOW TABLES;
1354 Tables_in_test
1355 t1
1356 SHOW CREATE TABLE t1;
1357 Table Create Table
1358 t1 CREATE TABLE `t1` (
1359 `c1` bigint NOT NULL,
1360 `c2` char(5) DEFAULT NULL
1361 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1362 /*!50100 PARTITION BY LINEAR KEY (c1)
1363 PARTITIONS 20 */
1364 ALTER TABLE t1 COALESCE PARTITION 18;
1365 SELECT * FROM t1 ORDER BY c1;
1366 c1 c2
1367 0 abc
1368 5 abc
1369 10 abc
1370 15 abc
1371 20 abc
1372 25 abc
1373 30 abc
1374 35 abc
1375 SHOW TABLES;
1376 Tables_in_test
1377 t1
1378 SHOW CREATE TABLE t1;
1379 Table Create Table
1380 t1 CREATE TABLE `t1` (
1381 `c1` bigint NOT NULL,
1382 `c2` char(5) DEFAULT NULL
1383 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1384 /*!50100 PARTITION BY LINEAR KEY (c1)
1385 PARTITIONS 2 */
1386 SHOW CREATE TABLE t1;
1387 Table Create Table
1388 t1 CREATE TABLE `t1` (
1389 `c1` bigint NOT NULL,
1390 `c2` char(5) DEFAULT NULL
1391 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1392 /*!50100 PARTITION BY LINEAR KEY (c1)
1393 PARTITIONS 2 */
1394 DROP TABLE t1;
1395 SHOW TABLES;
1396 Tables_in_test