Debian Codegraph @

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

raw
1 --source include/no_valgrind_without_big.inc
2
3 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
4 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
5 SELECT * FROM t1 ORDER BY c1;
6
7 SHOW TABLES;
8
9 SHOW CREATE TABLE t1;
10 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
11 SELECT * FROM t1 ORDER BY c1;
12
13 SHOW TABLES;
14
15 SHOW CREATE TABLE t1;
16 ALTER TABLE t1 COALESCE PARTITION 18;
17
18 SHOW TABLES;
19 SELECT * FROM t1 ORDER BY c1;
20
21 SHOW CREATE TABLE t1;
22
23 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
24 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
25 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
26 SELECT * FROM t1 ORDER BY c1;
27
28 SHOW TABLES;
29
30 SHOW CREATE TABLE t1;
31 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
32 SELECT * FROM t1 ORDER BY c1;
33
34 SHOW TABLES;
35
36 SHOW CREATE TABLE t1;
37 ALTER TABLE t1 COALESCE PARTITION 18;
38 SELECT * FROM t1 ORDER BY c1;
39
40 SHOW TABLES;
41
42 SHOW CREATE TABLE t1;
43
44 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
45 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
46 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
47 SELECT * FROM t1 ORDER BY c1;
48
49 SHOW TABLES;
50
51 SHOW CREATE TABLE t1;
52 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
53 SELECT * FROM t1 ORDER BY c1;
54
55 SHOW TABLES;
56
57 SHOW CREATE TABLE t1;
58 ALTER TABLE t1 COALESCE PARTITION 18;
59 SELECT * FROM t1 ORDER BY c1;
60
61 SHOW TABLES;
62
63 SHOW CREATE TABLE t1;
64
65 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
66 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
67 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
68 SELECT * FROM t1 ORDER BY c1;
69
70 SHOW TABLES;
71
72 SHOW CREATE TABLE t1;
73 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
74 SELECT * FROM t1 ORDER BY c1;
75
76 SHOW TABLES;
77
78 SHOW CREATE TABLE t1;
79 ALTER TABLE t1 COALESCE PARTITION 18;
80 SELECT * FROM t1 ORDER BY c1;
81
82 SHOW TABLES;
83
84 SHOW CREATE TABLE t1;
85
86 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
87 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
88 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
89 SELECT * FROM t1 ORDER BY c1;
90
91 SHOW TABLES;
92
93 SHOW CREATE TABLE t1;
94 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
95 SELECT * FROM t1 ORDER BY c1;
96
97 SHOW TABLES;
98
99 SHOW CREATE TABLE t1;
100 ALTER TABLE t1 COALESCE PARTITION 18;
101 SELECT * FROM t1 ORDER BY c1;
102
103 SHOW TABLES;
104
105 SHOW CREATE TABLE t1;
106
107 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
108 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
109 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
110 SELECT * FROM t1 ORDER BY c1;
111
112 SHOW TABLES;
113
114 SHOW CREATE TABLE t1;
115 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
116 SELECT * FROM t1 ORDER BY c1;
117
118 SHOW TABLES;
119
120 SHOW CREATE TABLE t1;
121 ALTER TABLE t1 COALESCE PARTITION 18;
122 SELECT * FROM t1 ORDER BY c1;
123
124 SHOW TABLES;
125
126 SHOW CREATE TABLE t1;
127
128 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
129 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
130 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
131 SELECT * FROM t1 ORDER BY c1;
132
133 SHOW TABLES;
134
135 SHOW CREATE TABLE t1;
136 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
137 SELECT * FROM t1 ORDER BY c1;
138
139 SHOW TABLES;
140
141 SHOW CREATE TABLE t1;
142 ALTER TABLE t1 COALESCE PARTITION 18;
143 SELECT * FROM t1 ORDER BY c1;
144
145 SHOW TABLES;
146
147 SHOW CREATE TABLE t1;
148
149 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
150 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
151 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
152 SELECT * FROM t1 ORDER BY c1;
153
154 SHOW TABLES;
155
156 SHOW CREATE TABLE t1;
157 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
158 SELECT * FROM t1 ORDER BY c1;
159
160 SHOW TABLES;
161
162 SHOW CREATE TABLE t1;
163 ALTER TABLE t1 COALESCE PARTITION 18;
164 SELECT * FROM t1 ORDER BY c1;
165
166 SHOW TABLES;
167
168 SHOW CREATE TABLE t1;
169
170 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
171 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
172 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
173 SELECT * FROM t1 ORDER BY c1;
174
175 SHOW TABLES;
176
177 SHOW CREATE TABLE t1;
178 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
179 SELECT * FROM t1 ORDER BY c1;
180
181 SHOW TABLES;
182
183 SHOW CREATE TABLE t1;
184 ALTER TABLE t1 COALESCE PARTITION 18;
185 SELECT * FROM t1 ORDER BY c1;
186
187 SHOW TABLES;
188
189 SHOW CREATE TABLE t1;
190
191 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
192 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
193 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
194 SELECT * FROM t1 ORDER BY c1;
195
196 SHOW TABLES;
197
198 SHOW CREATE TABLE t1;
199 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
200 SELECT * FROM t1 ORDER BY c1;
201
202 SHOW TABLES;
203
204 SHOW CREATE TABLE t1;
205 ALTER TABLE t1 COALESCE PARTITION 18;
206 SELECT * FROM t1 ORDER BY c1;
207
208 SHOW TABLES;
209
210 SHOW CREATE TABLE t1;
211
212 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
213 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
214 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
215 SELECT * FROM t1 ORDER BY c1;
216
217 SHOW TABLES;
218
219 SHOW CREATE TABLE t1;
220 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
221 SELECT * FROM t1 ORDER BY c1;
222
223 SHOW TABLES;
224
225 SHOW CREATE TABLE t1;
226 ALTER TABLE t1 COALESCE PARTITION 18;
227 SELECT * FROM t1 ORDER BY c1;
228
229 SHOW TABLES;
230
231 SHOW CREATE TABLE t1;
232
233 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
234 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
235 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
236 SELECT * FROM t1 ORDER BY c1;
237
238 SHOW TABLES;
239
240 SHOW CREATE TABLE t1;
241 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
242 SELECT * FROM t1 ORDER BY c1;
243
244 SHOW TABLES;
245
246 SHOW CREATE TABLE t1;
247 ALTER TABLE t1 COALESCE PARTITION 18;
248 SELECT * FROM t1 ORDER BY c1;
249
250 SHOW TABLES;
251
252 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
253 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
254 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
255 SELECT * FROM t1 ORDER BY c1;
256
257 SHOW TABLES;
258
259 SHOW CREATE TABLE t1;
260 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
261 SELECT * FROM t1 ORDER BY c1;
262
263 SHOW TABLES;
264
265 SHOW CREATE TABLE t1;
266 ALTER TABLE t1 COALESCE PARTITION 18;
267 SELECT * FROM t1 ORDER BY c1;
268
269 SHOW TABLES;
270
271 SHOW CREATE TABLE t1;
272
273 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
274 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
275 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
276 SELECT * FROM t1 ORDER BY c1;
277
278 SHOW TABLES;
279
280 SHOW CREATE TABLE t1;
281 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
282 SELECT * FROM t1 ORDER BY c1;
283
284 SHOW TABLES;
285
286 SHOW CREATE TABLE t1;
287 ALTER TABLE t1 COALESCE PARTITION 18;
288 SELECT * FROM t1 ORDER BY c1;
289
290 SHOW TABLES;
291
292 SHOW CREATE TABLE t1;
293
294 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
295 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
296 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
297 SELECT * FROM t1 ORDER BY c1;
298
299 SHOW TABLES;
300
301 SHOW CREATE TABLE t1;
302 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
303 SELECT * FROM t1 ORDER BY c1;
304
305 SHOW TABLES;
306
307 SHOW CREATE TABLE t1;
308 ALTER TABLE t1 COALESCE PARTITION 18;
309 SELECT * FROM t1 ORDER BY c1;
310
311 SHOW TABLES;
312
313 SHOW CREATE TABLE t1;
314
315 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
316 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
317 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
318 SELECT * FROM t1 ORDER BY c1;
319
320 SHOW TABLES;
321
322 SHOW CREATE TABLE t1;
323 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
324 SELECT * FROM t1 ORDER BY c1;
325
326 SHOW TABLES;
327
328 SHOW CREATE TABLE t1;
329 ALTER TABLE t1 COALESCE PARTITION 18;
330 SELECT * FROM t1 ORDER BY c1;
331
332 SHOW TABLES;
333
334 SHOW CREATE TABLE t1;
335
336 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
337 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
338 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
339 SELECT * FROM t1 ORDER BY c1;
340
341 SHOW TABLES;
342
343 SHOW CREATE TABLE t1;
344 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
345 SELECT * FROM t1 ORDER BY c1;
346
347 SHOW TABLES;
348
349 SHOW CREATE TABLE t1;
350 ALTER TABLE t1 COALESCE PARTITION 18;
351 SELECT * FROM t1 ORDER BY c1;
352
353 SHOW TABLES;
354
355 SHOW CREATE TABLE t1;
356
357 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
358 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
359 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
360 SELECT * FROM t1 ORDER BY c1;
361
362 SHOW TABLES;
363
364 SHOW CREATE TABLE t1;
365 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
366 SELECT * FROM t1 ORDER BY c1;
367
368 SHOW TABLES;
369
370 SHOW CREATE TABLE t1;
371 ALTER TABLE t1 COALESCE PARTITION 18;
372 SELECT * FROM t1 ORDER BY c1;
373
374 SHOW TABLES;
375 SHOW CREATE TABLE t1;
376 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;