1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY LIST (c1) (
3 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
4 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
5 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
6 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
12 t1 CREATE TABLE `t1` (
13 `c1` smallint(6) DEFAULT NULL,
14 `c2` int(11) DEFAULT NULL
15 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
16 /*!50100 PARTITION BY LIST (c1)
17 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
18 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
19 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
20 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) */
24 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
25 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
26 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
27 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
28 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
34 t1 CREATE TABLE `t1` (
35 `c1` mediumint(9) DEFAULT NULL,
36 `c2` int(11) DEFAULT NULL
37 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
38 /*!50100 PARTITION BY LIST (c1)
39 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
40 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
41 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
42 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) */
46 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
47 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
48 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
49 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
50 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
56 t1 CREATE TABLE `t1` (
57 `c1` int(11) DEFAULT NULL,
58 `c2` int(11) DEFAULT NULL
59 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
60 /*!50100 PARTITION BY LIST (c1)
61 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
62 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
63 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
64 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) */
68 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
69 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
70 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
71 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
72 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
78 t1 CREATE TABLE `t1` (
79 `c1` int(11) DEFAULT NULL,
80 `c2` int(11) DEFAULT NULL
81 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
82 /*!50100 PARTITION BY LIST (c1)
83 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
84 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
85 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
86 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) */
90 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
91 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
92 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
93 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
94 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
100 t1 CREATE TABLE `t1` (
101 `c1` bigint(20) DEFAULT NULL,
102 `c2` int(11) DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
104 /*!50100 PARTITION BY LIST (c1)
105 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
106 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
107 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
108 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) */