1
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
2
PARTITION p0 VALUES LESS THAN (10),
3
PARTITION p1 VALUES LESS THAN (20),
4
PARTITION p2 VALUES LESS THAN (30),
5
PARTITION p3 VALUES LESS THAN MAXVALUE);
6
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
7
SELECT * FROM t1 ORDER BY c1;
17
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
18
SELECT * FROM t1 ORDER BY c1;
33
t1 CREATE TABLE `t1` (
34
`c1` tinyint(4) NOT NULL,
35
`c2` char(5) DEFAULT NULL
36
) ENGINE=ENGINE DEFAULT CHARSET=latin1
37
/*!50100 PARTITION BY HASH (c1)
39
ALTER TABLE t1 COALESCE PARTITION 2;
40
SELECT * FROM t1 ORDER BY c1;
55
t1 CREATE TABLE `t1` (
56
`c1` tinyint(4) NOT NULL,
57
`c2` char(5) DEFAULT NULL
58
) ENGINE=ENGINE DEFAULT CHARSET=latin1
59
/*!50100 PARTITION BY HASH (c1)
64
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
65
PARTITION p0 VALUES LESS THAN (10),
66
PARTITION p1 VALUES LESS THAN (20),
67
PARTITION p2 VALUES LESS THAN (30),
68
PARTITION p3 VALUES LESS THAN MAXVALUE);
69
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
70
SELECT * FROM t1 ORDER BY c1;
80
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
81
SELECT * FROM t1 ORDER BY c1;
96
t1 CREATE TABLE `t1` (
97
`c1` smallint(6) NOT NULL,
98
`c2` char(5) DEFAULT NULL
99
) ENGINE=ENGINE DEFAULT CHARSET=latin1
100
/*!50100 PARTITION BY HASH (c1)
102
ALTER TABLE t1 COALESCE PARTITION 2;
103
SELECT * FROM t1 ORDER BY c1;
116
SHOW CREATE TABLE t1;
118
t1 CREATE TABLE `t1` (
119
`c1` smallint(6) NOT NULL,
120
`c2` char(5) DEFAULT NULL
121
) ENGINE=ENGINE DEFAULT CHARSET=latin1
122
/*!50100 PARTITION BY HASH (c1)
127
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
128
PARTITION p0 VALUES LESS THAN (10),
129
PARTITION p1 VALUES LESS THAN (20),
130
PARTITION p2 VALUES LESS THAN (30),
131
PARTITION p3 VALUES LESS THAN MAXVALUE);
132
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
133
SELECT * FROM t1 ORDER BY c1;
143
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
144
SELECT * FROM t1 ORDER BY c1;
157
SHOW CREATE TABLE t1;
159
t1 CREATE TABLE `t1` (
160
`c1` mediumint(9) NOT NULL,
161
`c2` char(5) DEFAULT NULL
162
) ENGINE=ENGINE DEFAULT CHARSET=latin1
163
/*!50100 PARTITION BY HASH (c1)
165
ALTER TABLE t1 COALESCE PARTITION 2;
166
SELECT * FROM t1 ORDER BY c1;
179
SHOW CREATE TABLE t1;
181
t1 CREATE TABLE `t1` (
182
`c1` mediumint(9) NOT NULL,
183
`c2` char(5) DEFAULT NULL
184
) ENGINE=ENGINE DEFAULT CHARSET=latin1
185
/*!50100 PARTITION BY HASH (c1)
190
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
191
PARTITION p0 VALUES LESS THAN (10),
192
PARTITION p1 VALUES LESS THAN (20),
193
PARTITION p2 VALUES LESS THAN (30),
194
PARTITION p3 VALUES LESS THAN MAXVALUE);
195
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
196
SELECT * FROM t1 ORDER BY c1;
206
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
207
SELECT * FROM t1 ORDER BY c1;
220
SHOW CREATE TABLE t1;
222
t1 CREATE TABLE `t1` (
223
`c1` int(11) NOT NULL,
224
`c2` char(5) DEFAULT NULL
225
) ENGINE=ENGINE DEFAULT CHARSET=latin1
226
/*!50100 PARTITION BY HASH (c1)
228
ALTER TABLE t1 COALESCE PARTITION 2;
229
SELECT * FROM t1 ORDER BY c1;
242
SHOW CREATE TABLE t1;
244
t1 CREATE TABLE `t1` (
245
`c1` int(11) NOT NULL,
246
`c2` char(5) DEFAULT NULL
247
) ENGINE=ENGINE DEFAULT CHARSET=latin1
248
/*!50100 PARTITION BY HASH (c1)
253
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
254
PARTITION p0 VALUES LESS THAN (10),
255
PARTITION p1 VALUES LESS THAN (20),
256
PARTITION p2 VALUES LESS THAN (30),
257
PARTITION p3 VALUES LESS THAN MAXVALUE);
258
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
259
SELECT * FROM t1 ORDER BY c1;
269
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
270
SELECT * FROM t1 ORDER BY c1;
283
SHOW CREATE TABLE t1;
285
t1 CREATE TABLE `t1` (
286
`c1` int(11) NOT NULL,
287
`c2` char(5) DEFAULT NULL
288
) ENGINE=ENGINE DEFAULT CHARSET=latin1
289
/*!50100 PARTITION BY HASH (c1)
291
ALTER TABLE t1 COALESCE PARTITION 2;
292
SELECT * FROM t1 ORDER BY c1;
305
SHOW CREATE TABLE t1;
307
t1 CREATE TABLE `t1` (
308
`c1` int(11) NOT NULL,
309
`c2` char(5) DEFAULT NULL
310
) ENGINE=ENGINE DEFAULT CHARSET=latin1
311
/*!50100 PARTITION BY HASH (c1)
316
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
317
PARTITION p0 VALUES LESS THAN (10),
318
PARTITION p1 VALUES LESS THAN (20),
319
PARTITION p2 VALUES LESS THAN (30),
320
PARTITION p3 VALUES LESS THAN MAXVALUE);
321
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
322
SELECT * FROM t1 ORDER BY c1;
332
ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
333
SELECT * FROM t1 ORDER BY c1;
346
SHOW CREATE TABLE t1;
348
t1 CREATE TABLE `t1` (
349
`c1` bigint(20) NOT NULL,
350
`c2` char(5) DEFAULT NULL
351
) ENGINE=ENGINE DEFAULT CHARSET=latin1
352
/*!50100 PARTITION BY HASH (c1)
354
ALTER TABLE t1 COALESCE PARTITION 2;
355
SELECT * FROM t1 ORDER BY c1;
368
SHOW CREATE TABLE t1;
370
t1 CREATE TABLE `t1` (
371
`c1` bigint(20) NOT NULL,
372
`c2` char(5) DEFAULT NULL
373
) ENGINE=ENGINE DEFAULT CHARSET=latin1
374
/*!50100 PARTITION BY HASH (c1)
379
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
380
PARTITION p0 VALUES LESS THAN (10),
381
PARTITION p1 VALUES LESS THAN (20),
382
PARTITION p2 VALUES LESS THAN (30),
383
PARTITION p3 VALUES LESS THAN MAXVALUE);
384
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
385
SELECT * FROM t1 ORDER BY c1;
395
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
396
SELECT * FROM t1 ORDER BY c1;
409
SHOW CREATE TABLE t1;
411
t1 CREATE TABLE `t1` (
412
`c1` tinyint(4) NOT NULL,
413
`c2` char(5) DEFAULT NULL
414
) ENGINE=ENGINE DEFAULT CHARSET=latin1
415
/*!50100 PARTITION BY KEY (c1)
417
ALTER TABLE t1 COALESCE PARTITION 2;
418
SELECT * FROM t1 ORDER BY c1;
431
SHOW CREATE TABLE t1;
433
t1 CREATE TABLE `t1` (
434
`c1` tinyint(4) NOT NULL,
435
`c2` char(5) DEFAULT NULL
436
) ENGINE=ENGINE DEFAULT CHARSET=latin1
437
/*!50100 PARTITION BY KEY (c1)
442
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
443
PARTITION p0 VALUES LESS THAN (10),
444
PARTITION p1 VALUES LESS THAN (20),
445
PARTITION p2 VALUES LESS THAN (30),
446
PARTITION p3 VALUES LESS THAN MAXVALUE);
447
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
448
SELECT * FROM t1 ORDER BY c1;
458
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
459
SELECT * FROM t1 ORDER BY c1;
472
SHOW CREATE TABLE t1;
474
t1 CREATE TABLE `t1` (
475
`c1` smallint(6) NOT NULL,
476
`c2` char(5) DEFAULT NULL
477
) ENGINE=ENGINE DEFAULT CHARSET=latin1
478
/*!50100 PARTITION BY KEY (c1)
480
ALTER TABLE t1 COALESCE PARTITION 2;
481
SELECT * FROM t1 ORDER BY c1;
494
SHOW CREATE TABLE t1;
496
t1 CREATE TABLE `t1` (
497
`c1` smallint(6) NOT NULL,
498
`c2` char(5) DEFAULT NULL
499
) ENGINE=ENGINE DEFAULT CHARSET=latin1
500
/*!50100 PARTITION BY KEY (c1)
505
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
506
PARTITION p0 VALUES LESS THAN (10),
507
PARTITION p1 VALUES LESS THAN (20),
508
PARTITION p2 VALUES LESS THAN (30),
509
PARTITION p3 VALUES LESS THAN MAXVALUE);
510
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
511
SELECT * FROM t1 ORDER BY c1;
521
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
522
SELECT * FROM t1 ORDER BY c1;
535
SHOW CREATE TABLE t1;
537
t1 CREATE TABLE `t1` (
538
`c1` mediumint(9) NOT NULL,
539
`c2` char(5) DEFAULT NULL
540
) ENGINE=ENGINE DEFAULT CHARSET=latin1
541
/*!50100 PARTITION BY KEY (c1)
543
ALTER TABLE t1 COALESCE PARTITION 2;
544
SELECT * FROM t1 ORDER BY c1;
557
SHOW CREATE TABLE t1;
559
t1 CREATE TABLE `t1` (
560
`c1` mediumint(9) NOT NULL,
561
`c2` char(5) DEFAULT NULL
562
) ENGINE=ENGINE DEFAULT CHARSET=latin1
563
/*!50100 PARTITION BY KEY (c1)
568
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
569
PARTITION p0 VALUES LESS THAN (10),
570
PARTITION p1 VALUES LESS THAN (20),
571
PARTITION p2 VALUES LESS THAN (30),
572
PARTITION p3 VALUES LESS THAN MAXVALUE);
573
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
574
SELECT * FROM t1 ORDER BY c1;
584
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
585
SELECT * FROM t1 ORDER BY c1;
598
SHOW CREATE TABLE t1;
600
t1 CREATE TABLE `t1` (
601
`c1` int(11) NOT NULL,
602
`c2` char(5) DEFAULT NULL
603
) ENGINE=ENGINE DEFAULT CHARSET=latin1
604
/*!50100 PARTITION BY KEY (c1)
606
ALTER TABLE t1 COALESCE PARTITION 2;
607
SELECT * FROM t1 ORDER BY c1;
620
SHOW CREATE TABLE t1;
622
t1 CREATE TABLE `t1` (
623
`c1` int(11) NOT NULL,
624
`c2` char(5) DEFAULT NULL
625
) ENGINE=ENGINE DEFAULT CHARSET=latin1
626
/*!50100 PARTITION BY KEY (c1)
631
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
632
PARTITION p0 VALUES LESS THAN (10),
633
PARTITION p1 VALUES LESS THAN (20),
634
PARTITION p2 VALUES LESS THAN (30),
635
PARTITION p3 VALUES LESS THAN MAXVALUE);
636
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
637
SELECT * FROM t1 ORDER BY c1;
647
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
648
SELECT * FROM t1 ORDER BY c1;
661
SHOW CREATE TABLE t1;
663
t1 CREATE TABLE `t1` (
664
`c1` int(11) NOT NULL,
665
`c2` char(5) DEFAULT NULL
666
) ENGINE=ENGINE DEFAULT CHARSET=latin1
667
/*!50100 PARTITION BY KEY (c1)
669
ALTER TABLE t1 COALESCE PARTITION 2;
670
SELECT * FROM t1 ORDER BY c1;
683
SHOW CREATE TABLE t1;
685
t1 CREATE TABLE `t1` (
686
`c1` int(11) NOT NULL,
687
`c2` char(5) DEFAULT NULL
688
) ENGINE=ENGINE DEFAULT CHARSET=latin1
689
/*!50100 PARTITION BY KEY (c1)
694
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
695
PARTITION p0 VALUES LESS THAN (10),
696
PARTITION p1 VALUES LESS THAN (20),
697
PARTITION p2 VALUES LESS THAN (30),
698
PARTITION p3 VALUES LESS THAN MAXVALUE);
699
INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
700
SELECT * FROM t1 ORDER BY c1;
710
ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
711
SELECT * FROM t1 ORDER BY c1;
724
SHOW CREATE TABLE t1;
726
t1 CREATE TABLE `t1` (
727
`c1` bigint(20) NOT NULL,
728
`c2` char(5) DEFAULT NULL
729
) ENGINE=ENGINE DEFAULT CHARSET=latin1
730
/*!50100 PARTITION BY KEY (c1)
732
ALTER TABLE t1 COALESCE PARTITION 2;
733
SELECT * FROM t1 ORDER BY c1;
746
SHOW CREATE TABLE t1;
748
t1 CREATE TABLE `t1` (
749
`c1` bigint(20) NOT NULL,
750
`c2` char(5) DEFAULT NULL
751
) ENGINE=ENGINE DEFAULT CHARSET=latin1
752
/*!50100 PARTITION BY KEY (c1)