Debian Codegraph @

mysql-test/suite/parts/r/partition_remove.result

raw
1 DROP TABLE IF EXISTS t1;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
4 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
5 Warnings:
6 Warning 1264 Out of range value for column 'c1' at row 3
7 Warning 1264 Out of range value for column 'c1' at row 4
8 Warning 1264 Out of range value for column 'c1' at row 5
9 SELECT * FROM t1 ORDER BY c1;
10 c1 c2
11 0 abc
12 100 abc
13 127 abc
14 127 abc
15 127 abc
16 SHOW TABLES;
17 Tables_in_test
18 t1
19 SHOW CREATE TABLE t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `c1` tinyint DEFAULT NULL,
23 `c2` char(5) DEFAULT NULL
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 /*!50100 PARTITION BY HASH (`c1`) */
26 ALTER TABLE t1 REMOVE PARTITIONING;
27 SELECT * FROM t1 ORDER BY c1;
28 c1 c2
29 0 abc
30 100 abc
31 127 abc
32 127 abc
33 127 abc
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` tinyint DEFAULT NULL,
41 `c2` char(5) DEFAULT NULL
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
47 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
48 SELECT * FROM t1 ORDER BY c1;
49 c1 c2
50 0 abc
51 100 abc
52 200 abc
53 300 abc
54 400 abc
55 SHOW TABLES;
56 Tables_in_test
57 t1
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `c1` smallint DEFAULT NULL,
62 `c2` char(5) DEFAULT NULL
63 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
64 /*!50100 PARTITION BY HASH (`c1`) */
65 ALTER TABLE t1 REMOVE PARTITIONING;
66 SELECT * FROM t1 ORDER BY c1;
67 c1 c2
68 0 abc
69 100 abc
70 200 abc
71 300 abc
72 400 abc
73 SHOW TABLES;
74 Tables_in_test
75 t1
76 SHOW CREATE TABLE t1;
77 Table Create Table
78 t1 CREATE TABLE `t1` (
79 `c1` smallint DEFAULT NULL,
80 `c2` char(5) DEFAULT NULL
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
82 DROP TABLE t1;
83 SHOW TABLES;
84 Tables_in_test
85 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
86 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
87 SELECT * FROM t1 ORDER BY c1;
88 c1 c2
89 0 abc
90 100 abc
91 200 abc
92 300 abc
93 400 abc
94 SHOW TABLES;
95 Tables_in_test
96 t1
97 SHOW CREATE TABLE t1;
98 Table Create Table
99 t1 CREATE TABLE `t1` (
100 `c1` mediumint DEFAULT NULL,
101 `c2` char(5) DEFAULT NULL
102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
103 /*!50100 PARTITION BY HASH (`c1`) */
104 ALTER TABLE t1 REMOVE PARTITIONING;
105 SELECT * FROM t1 ORDER BY c1;
106 c1 c2
107 0 abc
108 100 abc
109 200 abc
110 300 abc
111 400 abc
112 SHOW TABLES;
113 Tables_in_test
114 t1
115 SHOW CREATE TABLE t1;
116 Table Create Table
117 t1 CREATE TABLE `t1` (
118 `c1` mediumint DEFAULT NULL,
119 `c2` char(5) DEFAULT NULL
120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 DROP TABLE t1;
122 SHOW TABLES;
123 Tables_in_test
124 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
125 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
126 SELECT * FROM t1 ORDER BY c1;
127 c1 c2
128 0 abc
129 100 abc
130 200 abc
131 300 abc
132 400 abc
133 SHOW TABLES;
134 Tables_in_test
135 t1
136 SHOW CREATE TABLE t1;
137 Table Create Table
138 t1 CREATE TABLE `t1` (
139 `c1` int DEFAULT NULL,
140 `c2` char(5) DEFAULT NULL
141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
142 /*!50100 PARTITION BY HASH (`c1`) */
143 ALTER TABLE t1 REMOVE PARTITIONING;
144 SELECT * FROM t1 ORDER BY c1;
145 c1 c2
146 0 abc
147 100 abc
148 200 abc
149 300 abc
150 400 abc
151 SHOW TABLES;
152 Tables_in_test
153 t1
154 SHOW CREATE TABLE t1;
155 Table Create Table
156 t1 CREATE TABLE `t1` (
157 `c1` int DEFAULT NULL,
158 `c2` char(5) DEFAULT NULL
159 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
160 DROP TABLE t1;
161 SHOW TABLES;
162 Tables_in_test
163 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
164 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
165 SELECT * FROM t1 ORDER BY c1;
166 c1 c2
167 0 abc
168 100 abc
169 200 abc
170 300 abc
171 400 abc
172 SHOW TABLES;
173 Tables_in_test
174 t1
175 SHOW CREATE TABLE t1;
176 Table Create Table
177 t1 CREATE TABLE `t1` (
178 `c1` int DEFAULT NULL,
179 `c2` char(5) DEFAULT NULL
180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
181 /*!50100 PARTITION BY HASH (`c1`) */
182 ALTER TABLE t1 REMOVE PARTITIONING;
183 SELECT * FROM t1 ORDER BY c1;
184 c1 c2
185 0 abc
186 100 abc
187 200 abc
188 300 abc
189 400 abc
190 SHOW TABLES;
191 Tables_in_test
192 t1
193 SHOW CREATE TABLE t1;
194 Table Create Table
195 t1 CREATE TABLE `t1` (
196 `c1` int DEFAULT NULL,
197 `c2` char(5) DEFAULT NULL
198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
199 DROP TABLE t1;
200 SHOW TABLES;
201 Tables_in_test
202 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
203 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
204 SELECT * FROM t1 ORDER BY c1;
205 c1 c2
206 0 abc
207 100 abc
208 200 abc
209 300 abc
210 400 abc
211 SHOW TABLES;
212 Tables_in_test
213 t1
214 SHOW CREATE TABLE t1;
215 Table Create Table
216 t1 CREATE TABLE `t1` (
217 `c1` bigint DEFAULT NULL,
218 `c2` char(5) DEFAULT NULL
219 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
220 /*!50100 PARTITION BY HASH (`c1`) */
221 ALTER TABLE t1 REMOVE PARTITIONING;
222 SELECT * FROM t1 ORDER BY c1;
223 c1 c2
224 0 abc
225 100 abc
226 200 abc
227 300 abc
228 400 abc
229 SHOW TABLES;
230 Tables_in_test
231 t1
232 SHOW CREATE TABLE t1;
233 Table Create Table
234 t1 CREATE TABLE `t1` (
235 `c1` bigint DEFAULT NULL,
236 `c2` char(5) DEFAULT NULL
237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 DROP TABLE t1;
239 SHOW TABLES;
240 Tables_in_test
241 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
242 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
243 Warnings:
244 Warning 1264 Out of range value for column 'c1' at row 3
245 Warning 1264 Out of range value for column 'c1' at row 4
246 Warning 1264 Out of range value for column 'c1' at row 5
247 SELECT * FROM t1 ORDER BY c1;
248 c1 c2
249 0 abc
250 100 abc
251 127 abc
252 127 abc
253 127 abc
254 SHOW TABLES;
255 Tables_in_test
256 t1
257 SHOW CREATE TABLE t1;
258 Table Create Table
259 t1 CREATE TABLE `t1` (
260 `c1` tinyint NOT NULL,
261 `c2` char(5) DEFAULT NULL
262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 /*!50100 PARTITION BY HASH (`c1`) */
264 ALTER TABLE t1 REMOVE PARTITIONING;
265 SELECT * FROM t1 ORDER BY c1;
266 c1 c2
267 0 abc
268 100 abc
269 127 abc
270 127 abc
271 127 abc
272 SHOW TABLES;
273 Tables_in_test
274 t1
275 SHOW CREATE TABLE t1;
276 Table Create Table
277 t1 CREATE TABLE `t1` (
278 `c1` tinyint NOT NULL,
279 `c2` char(5) DEFAULT NULL
280 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
281 DROP TABLE t1;
282 SHOW TABLES;
283 Tables_in_test
284 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
285 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
286 SELECT * FROM t1 ORDER BY c1;
287 c1 c2
288 0 abc
289 100 abc
290 200 abc
291 300 abc
292 400 abc
293 SHOW TABLES;
294 Tables_in_test
295 t1
296 SHOW CREATE TABLE t1;
297 Table Create Table
298 t1 CREATE TABLE `t1` (
299 `c1` smallint NOT NULL,
300 `c2` char(5) DEFAULT NULL
301 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
302 /*!50100 PARTITION BY HASH (`c1`) */
303 ALTER TABLE t1 REMOVE PARTITIONING;
304 SELECT * FROM t1 ORDER BY c1;
305 c1 c2
306 0 abc
307 100 abc
308 200 abc
309 300 abc
310 400 abc
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` smallint NOT NULL,
318 `c2` char(5) DEFAULT NULL
319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
320 DROP TABLE t1;
321 SHOW TABLES;
322 Tables_in_test
323 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
324 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
325 SELECT * FROM t1 ORDER BY c1;
326 c1 c2
327 0 abc
328 100 abc
329 200 abc
330 300 abc
331 400 abc
332 SHOW TABLES;
333 Tables_in_test
334 t1
335 SHOW CREATE TABLE t1;
336 Table Create Table
337 t1 CREATE TABLE `t1` (
338 `c1` mediumint NOT NULL,
339 `c2` char(5) DEFAULT NULL
340 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 /*!50100 PARTITION BY HASH (`c1`) */
342 ALTER TABLE t1 REMOVE PARTITIONING;
343 SELECT * FROM t1 ORDER BY c1;
344 c1 c2
345 0 abc
346 100 abc
347 200 abc
348 300 abc
349 400 abc
350 SHOW TABLES;
351 Tables_in_test
352 t1
353 SHOW CREATE TABLE t1;
354 Table Create Table
355 t1 CREATE TABLE `t1` (
356 `c1` mediumint NOT NULL,
357 `c2` char(5) DEFAULT NULL
358 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
359 DROP TABLE t1;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
363 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
364 SELECT * FROM t1 ORDER BY c1;
365 c1 c2
366 0 abc
367 100 abc
368 200 abc
369 300 abc
370 400 abc
371 SHOW TABLES;
372 Tables_in_test
373 t1
374 SHOW CREATE TABLE t1;
375 Table Create Table
376 t1 CREATE TABLE `t1` (
377 `c1` int NOT NULL,
378 `c2` char(5) DEFAULT NULL
379 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
380 /*!50100 PARTITION BY HASH (`c1`) */
381 ALTER TABLE t1 REMOVE PARTITIONING;
382 SELECT * FROM t1 ORDER BY c1;
383 c1 c2
384 0 abc
385 100 abc
386 200 abc
387 300 abc
388 400 abc
389 SHOW TABLES;
390 Tables_in_test
391 t1
392 SHOW CREATE TABLE t1;
393 Table Create Table
394 t1 CREATE TABLE `t1` (
395 `c1` int NOT NULL,
396 `c2` char(5) DEFAULT NULL
397 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
398 DROP TABLE t1;
399 SHOW TABLES;
400 Tables_in_test
401 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
402 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
403 SELECT * FROM t1 ORDER BY c1;
404 c1 c2
405 0 abc
406 100 abc
407 200 abc
408 300 abc
409 400 abc
410 SHOW TABLES;
411 Tables_in_test
412 t1
413 SHOW CREATE TABLE t1;
414 Table Create Table
415 t1 CREATE TABLE `t1` (
416 `c1` int NOT NULL,
417 `c2` char(5) DEFAULT NULL
418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 /*!50100 PARTITION BY HASH (`c1`) */
420 ALTER TABLE t1 REMOVE PARTITIONING;
421 SELECT * FROM t1 ORDER BY c1;
422 c1 c2
423 0 abc
424 100 abc
425 200 abc
426 300 abc
427 400 abc
428 SHOW TABLES;
429 Tables_in_test
430 t1
431 SHOW CREATE TABLE t1;
432 Table Create Table
433 t1 CREATE TABLE `t1` (
434 `c1` int NOT NULL,
435 `c2` char(5) DEFAULT NULL
436 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
437 DROP TABLE t1;
438 SHOW TABLES;
439 Tables_in_test
440 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
441 INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
442 SELECT * FROM t1 ORDER BY c1;
443 c1 c2
444 0 abc
445 100 abc
446 200 abc
447 300 abc
448 400 abc
449 SHOW TABLES;
450 Tables_in_test
451 t1
452 SHOW CREATE TABLE t1;
453 Table Create Table
454 t1 CREATE TABLE `t1` (
455 `c1` bigint NOT NULL,
456 `c2` char(5) DEFAULT NULL
457 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
458 /*!50100 PARTITION BY HASH (`c1`) */
459 ALTER TABLE t1 REMOVE PARTITIONING;
460 SELECT * FROM t1 ORDER BY c1;
461 c1 c2
462 0 abc
463 100 abc
464 200 abc
465 300 abc
466 400 abc
467 SHOW TABLES;
468 Tables_in_test
469 t1
470 SHOW CREATE TABLE t1;
471 Table Create Table
472 t1 CREATE TABLE `t1` (
473 `c1` bigint NOT NULL,
474 `c2` char(5) DEFAULT NULL
475 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
476 DROP TABLE t1;
477 SHOW TABLES;
478 Tables_in_test
479 SET sql_mode=default;