Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_partition_remove.result

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