Debian Codegraph @

mysql-test/suite/parts/t/partition_change_from_range_to_hash_key.test

raw
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;
8 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
9 SELECT * FROM t1 ORDER BY c1;
10 SHOW TABLES;
11 SHOW CREATE TABLE t1;
12 ALTER TABLE t1 COALESCE PARTITION 2;
13 SELECT * FROM t1 ORDER BY c1;
14 SHOW TABLES;
15 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
16 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
17 PARTITION p0 VALUES LESS THAN (10),
18 PARTITION p1 VALUES LESS THAN (20),
19 PARTITION p2 VALUES LESS THAN (30),
20 PARTITION p3 VALUES LESS THAN MAXVALUE);
21 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
22 SELECT * FROM t1 ORDER BY c1;
23 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
24 SELECT * FROM t1 ORDER BY c1;
25 SHOW TABLES;
26 SHOW CREATE TABLE t1;
27 ALTER TABLE t1 COALESCE PARTITION 2;
28 SELECT * FROM t1 ORDER BY c1;
29 SHOW TABLES;
30 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
31 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
32 PARTITION p0 VALUES LESS THAN (10),
33 PARTITION p1 VALUES LESS THAN (20),
34 PARTITION p2 VALUES LESS THAN (30),
35 PARTITION p3 VALUES LESS THAN MAXVALUE);
36 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
37 SELECT * FROM t1 ORDER BY c1;
38 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
39 SELECT * FROM t1 ORDER BY c1;
40 SHOW TABLES;
41 SHOW CREATE TABLE t1;
42 ALTER TABLE t1 COALESCE PARTITION 2;
43 SELECT * FROM t1 ORDER BY c1;
44 SHOW TABLES;
45 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
46 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
47 PARTITION p0 VALUES LESS THAN (10),
48 PARTITION p1 VALUES LESS THAN (20),
49 PARTITION p2 VALUES LESS THAN (30),
50 PARTITION p3 VALUES LESS THAN MAXVALUE);
51 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
52 SELECT * FROM t1 ORDER BY c1;
53 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
54 SELECT * FROM t1 ORDER BY c1;
55 SHOW TABLES;
56 SHOW CREATE TABLE t1;
57 ALTER TABLE t1 COALESCE PARTITION 2;
58 SELECT * FROM t1 ORDER BY c1;
59 SHOW TABLES;
60 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
61 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
62 PARTITION p0 VALUES LESS THAN (10),
63 PARTITION p1 VALUES LESS THAN (20),
64 PARTITION p2 VALUES LESS THAN (30),
65 PARTITION p3 VALUES LESS THAN MAXVALUE);
66 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
67 SELECT * FROM t1 ORDER BY c1;
68 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
69 SELECT * FROM t1 ORDER BY c1;
70 SHOW TABLES;
71 SHOW CREATE TABLE t1;
72 ALTER TABLE t1 COALESCE PARTITION 2;
73 SELECT * FROM t1 ORDER BY c1;
74 SHOW TABLES;
75 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
76 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
77 PARTITION p0 VALUES LESS THAN (10),
78 PARTITION p1 VALUES LESS THAN (20),
79 PARTITION p2 VALUES LESS THAN (30),
80 PARTITION p3 VALUES LESS THAN MAXVALUE);
81 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
82 SELECT * FROM t1 ORDER BY c1;
83 ALTER TABLE t1 PARTITION BY HASH(c1) PARTITIONS 5;
84 SELECT * FROM t1 ORDER BY c1;
85 SHOW TABLES;
86 SHOW CREATE TABLE t1;
87 ALTER TABLE t1 COALESCE PARTITION 2;
88 SELECT * FROM t1 ORDER BY c1;
89 SHOW TABLES;
90 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
91 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
92 PARTITION p0 VALUES LESS THAN (10),
93 PARTITION p1 VALUES LESS THAN (20),
94 PARTITION p2 VALUES LESS THAN (30),
95 PARTITION p3 VALUES LESS THAN MAXVALUE);
96 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
97 SELECT * FROM t1 ORDER BY c1;
98 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
99 SELECT * FROM t1 ORDER BY c1;
100 SHOW TABLES;
101 SHOW CREATE TABLE t1;
102 ALTER TABLE t1 COALESCE PARTITION 2;
103 SELECT * FROM t1 ORDER BY c1;
104 SHOW TABLES;
105 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
106 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
107 PARTITION p0 VALUES LESS THAN (10),
108 PARTITION p1 VALUES LESS THAN (20),
109 PARTITION p2 VALUES LESS THAN (30),
110 PARTITION p3 VALUES LESS THAN MAXVALUE);
111 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
112 SELECT * FROM t1 ORDER BY c1;
113 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
114 SELECT * FROM t1 ORDER BY c1;
115 SHOW TABLES;
116 SHOW CREATE TABLE t1;
117 ALTER TABLE t1 COALESCE PARTITION 2;
118 SELECT * FROM t1 ORDER BY c1;
119 SHOW TABLES;
120 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
121 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
122 PARTITION p0 VALUES LESS THAN (10),
123 PARTITION p1 VALUES LESS THAN (20),
124 PARTITION p2 VALUES LESS THAN (30),
125 PARTITION p3 VALUES LESS THAN MAXVALUE);
126 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
127 SELECT * FROM t1 ORDER BY c1;
128 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
129 SELECT * FROM t1 ORDER BY c1;
130 SHOW TABLES;
131 SHOW CREATE TABLE t1;
132 ALTER TABLE t1 COALESCE PARTITION 2;
133 SELECT * FROM t1 ORDER BY c1;
134 SHOW TABLES;
135 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
136 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
137 PARTITION p0 VALUES LESS THAN (10),
138 PARTITION p1 VALUES LESS THAN (20),
139 PARTITION p2 VALUES LESS THAN (30),
140 PARTITION p3 VALUES LESS THAN MAXVALUE);
141 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
142 SELECT * FROM t1 ORDER BY c1;
143 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
144 SELECT * FROM t1 ORDER BY c1;
145 SHOW TABLES;
146 SHOW CREATE TABLE t1;
147 ALTER TABLE t1 COALESCE PARTITION 2;
148 SELECT * FROM t1 ORDER BY c1;
149 SHOW TABLES;
150 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
151 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
152 PARTITION p0 VALUES LESS THAN (10),
153 PARTITION p1 VALUES LESS THAN (20),
154 PARTITION p2 VALUES LESS THAN (30),
155 PARTITION p3 VALUES LESS THAN MAXVALUE);
156 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
157 SELECT * FROM t1 ORDER BY c1;
158 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
159 SELECT * FROM t1 ORDER BY c1;
160 SHOW TABLES;
161 SHOW CREATE TABLE t1;
162 ALTER TABLE t1 COALESCE PARTITION 2;
163 SELECT * FROM t1 ORDER BY c1;
164 SHOW TABLES;
165 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
166 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY RANGE ( c1 ) (
167 PARTITION p0 VALUES LESS THAN (10),
168 PARTITION p1 VALUES LESS THAN (20),
169 PARTITION p2 VALUES LESS THAN (30),
170 PARTITION p3 VALUES LESS THAN MAXVALUE);
171 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
172 SELECT * FROM t1 ORDER BY c1;
173 ALTER TABLE t1 PARTITION BY KEY(c1) PARTITIONS 5;
174 SELECT * FROM t1 ORDER BY c1;
175 SHOW TABLES;
176 SHOW CREATE TABLE t1;
177 ALTER TABLE t1 COALESCE PARTITION 2;
178 SELECT * FROM t1 ORDER BY c1;
179 SHOW TABLES;
180 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;