Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` tinyint(4) DEFAULT NULL,
10 `c2` char(5) DEFAULT NULL
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
12 PARTITION BY HASH (`c1`)
13 PARTITIONS 1
14 DROP TABLE t1;
15 SHOW TABLES;
16 Tables_in_test
17 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
18 SHOW TABLES;
19 Tables_in_test
20 t1
21 SHOW CREATE TABLE t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `c1` smallint(6) DEFAULT NULL,
25 `c2` char(5) DEFAULT NULL
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
27 PARTITION BY HASH (`c1`)
28 PARTITIONS 1
29 DROP TABLE t1;
30 SHOW TABLES;
31 Tables_in_test
32 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
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` mediumint(9) DEFAULT NULL,
40 `c2` char(5) DEFAULT NULL
41 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 PARTITION BY HASH (`c1`)
43 PARTITIONS 1
44 DROP TABLE t1;
45 SHOW TABLES;
46 Tables_in_test
47 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
48 SHOW TABLES;
49 Tables_in_test
50 t1
51 SHOW CREATE TABLE t1;
52 Table Create Table
53 t1 CREATE TABLE `t1` (
54 `c1` int(11) DEFAULT NULL,
55 `c2` char(5) DEFAULT NULL
56 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
57 PARTITION BY HASH (`c1`)
58 PARTITIONS 1
59 DROP TABLE t1;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
63 SHOW TABLES;
64 Tables_in_test
65 t1
66 SHOW CREATE TABLE t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `c1` int(11) DEFAULT NULL,
70 `c2` char(5) DEFAULT NULL
71 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
72 PARTITION BY HASH (`c1`)
73 PARTITIONS 1
74 DROP TABLE t1;
75 SHOW TABLES;
76 Tables_in_test
77 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` bigint(20) DEFAULT NULL,
85 `c2` char(5) DEFAULT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
87 PARTITION BY HASH (`c1`)
88 PARTITIONS 1
89 DROP TABLE t1;
90 SHOW TABLES;
91 Tables_in_test
92 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
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` tinyint(4) NOT NULL,
100 `c2` char(5) DEFAULT NULL
101 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
102 PARTITION BY HASH (`c1`)
103 PARTITIONS 1
104 DROP TABLE t1;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
108 SHOW TABLES;
109 Tables_in_test
110 t1
111 SHOW CREATE TABLE t1;
112 Table Create Table
113 t1 CREATE TABLE `t1` (
114 `c1` smallint(6) NOT NULL,
115 `c2` char(5) DEFAULT NULL
116 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
117 PARTITION BY HASH (`c1`)
118 PARTITIONS 1
119 DROP TABLE t1;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
123 SHOW TABLES;
124 Tables_in_test
125 t1
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TABLE `t1` (
129 `c1` mediumint(9) NOT NULL,
130 `c2` char(5) DEFAULT NULL
131 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
132 PARTITION BY HASH (`c1`)
133 PARTITIONS 1
134 DROP TABLE t1;
135 SHOW TABLES;
136 Tables_in_test
137 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
138 SHOW TABLES;
139 Tables_in_test
140 t1
141 SHOW CREATE TABLE t1;
142 Table Create Table
143 t1 CREATE TABLE `t1` (
144 `c1` int(11) NOT NULL,
145 `c2` char(5) DEFAULT NULL
146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
147 PARTITION BY HASH (`c1`)
148 PARTITIONS 1
149 DROP TABLE t1;
150 SHOW TABLES;
151 Tables_in_test
152 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
153 SHOW TABLES;
154 Tables_in_test
155 t1
156 SHOW CREATE TABLE t1;
157 Table Create Table
158 t1 CREATE TABLE `t1` (
159 `c1` int(11) NOT NULL,
160 `c2` char(5) DEFAULT NULL
161 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
162 PARTITION BY HASH (`c1`)
163 PARTITIONS 1
164 DROP TABLE t1;
165 SHOW TABLES;
166 Tables_in_test
167 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
168 SHOW TABLES;
169 Tables_in_test
170 t1
171 SHOW CREATE TABLE t1;
172 Table Create Table
173 t1 CREATE TABLE `t1` (
174 `c1` bigint(20) NOT NULL,
175 `c2` char(5) DEFAULT NULL
176 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
177 PARTITION BY HASH (`c1`)
178 PARTITIONS 1
179 DROP TABLE t1;
180 SHOW TABLES;
181 Tables_in_test
182 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
183 SHOW TABLES;
184 Tables_in_test
185 t1
186 SHOW CREATE TABLE t1;
187 Table Create Table
188 t1 CREATE TABLE `t1` (
189 `c1` tinyint(4) DEFAULT NULL,
190 `c2` char(5) DEFAULT NULL
191 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
192 PARTITION BY HASH (`c1`)
193 PARTITIONS 2
194 DROP TABLE t1;
195 SHOW TABLES;
196 Tables_in_test
197 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
198 SHOW TABLES;
199 Tables_in_test
200 t1
201 SHOW CREATE TABLE t1;
202 Table Create Table
203 t1 CREATE TABLE `t1` (
204 `c1` smallint(6) DEFAULT NULL,
205 `c2` char(5) DEFAULT NULL
206 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
207 PARTITION BY HASH (`c1`)
208 PARTITIONS 2
209 DROP TABLE t1;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
213 SHOW TABLES;
214 Tables_in_test
215 t1
216 SHOW CREATE TABLE t1;
217 Table Create Table
218 t1 CREATE TABLE `t1` (
219 `c1` mediumint(9) DEFAULT NULL,
220 `c2` char(5) DEFAULT NULL
221 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
222 PARTITION BY HASH (`c1`)
223 PARTITIONS 2
224 DROP TABLE t1;
225 SHOW TABLES;
226 Tables_in_test
227 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
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` int(11) DEFAULT NULL,
235 `c2` char(5) DEFAULT NULL
236 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
237 PARTITION BY HASH (`c1`)
238 PARTITIONS 2
239 DROP TABLE t1;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
243 SHOW TABLES;
244 Tables_in_test
245 t1
246 SHOW CREATE TABLE t1;
247 Table Create Table
248 t1 CREATE TABLE `t1` (
249 `c1` int(11) DEFAULT NULL,
250 `c2` char(5) DEFAULT NULL
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
252 PARTITION BY HASH (`c1`)
253 PARTITIONS 2
254 DROP TABLE t1;
255 SHOW TABLES;
256 Tables_in_test
257 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
258 SHOW TABLES;
259 Tables_in_test
260 t1
261 SHOW CREATE TABLE t1;
262 Table Create Table
263 t1 CREATE TABLE `t1` (
264 `c1` bigint(20) DEFAULT NULL,
265 `c2` char(5) DEFAULT NULL
266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
267 PARTITION BY HASH (`c1`)
268 PARTITIONS 2
269 DROP TABLE t1;
270 SHOW TABLES;
271 Tables_in_test
272 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
273 SHOW TABLES;
274 Tables_in_test
275 t1
276 SHOW CREATE TABLE t1;
277 Table Create Table
278 t1 CREATE TABLE `t1` (
279 `c1` tinyint(4) NOT NULL,
280 `c2` char(5) DEFAULT NULL
281 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
282 PARTITION BY HASH (`c1`)
283 PARTITIONS 2
284 DROP TABLE t1;
285 SHOW TABLES;
286 Tables_in_test
287 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
288 SHOW TABLES;
289 Tables_in_test
290 t1
291 SHOW CREATE TABLE t1;
292 Table Create Table
293 t1 CREATE TABLE `t1` (
294 `c1` smallint(6) NOT NULL,
295 `c2` char(5) DEFAULT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
297 PARTITION BY HASH (`c1`)
298 PARTITIONS 2
299 DROP TABLE t1;
300 SHOW TABLES;
301 Tables_in_test
302 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
303 SHOW TABLES;
304 Tables_in_test
305 t1
306 SHOW CREATE TABLE t1;
307 Table Create Table
308 t1 CREATE TABLE `t1` (
309 `c1` mediumint(9) NOT NULL,
310 `c2` char(5) DEFAULT NULL
311 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
312 PARTITION BY HASH (`c1`)
313 PARTITIONS 2
314 DROP TABLE t1;
315 SHOW TABLES;
316 Tables_in_test
317 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
318 SHOW TABLES;
319 Tables_in_test
320 t1
321 SHOW CREATE TABLE t1;
322 Table Create Table
323 t1 CREATE TABLE `t1` (
324 `c1` int(11) NOT NULL,
325 `c2` char(5) DEFAULT NULL
326 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
327 PARTITION BY HASH (`c1`)
328 PARTITIONS 2
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
333 SHOW TABLES;
334 Tables_in_test
335 t1
336 SHOW CREATE TABLE t1;
337 Table Create Table
338 t1 CREATE TABLE `t1` (
339 `c1` int(11) NOT NULL,
340 `c2` char(5) DEFAULT NULL
341 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
342 PARTITION BY HASH (`c1`)
343 PARTITIONS 2
344 DROP TABLE t1;
345 SHOW TABLES;
346 Tables_in_test
347 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
348 SHOW TABLES;
349 Tables_in_test
350 t1
351 SHOW CREATE TABLE t1;
352 Table Create Table
353 t1 CREATE TABLE `t1` (
354 `c1` bigint(20) NOT NULL,
355 `c2` char(5) DEFAULT NULL
356 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
357 PARTITION BY HASH (`c1`)
358 PARTITIONS 2
359 DROP TABLE t1;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
363 SHOW TABLES;
364 Tables_in_test
365 t1
366 SHOW CREATE TABLE t1;
367 Table Create Table
368 t1 CREATE TABLE `t1` (
369 `c1` tinyint(4) DEFAULT NULL,
370 `c2` char(5) DEFAULT NULL
371 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
372 PARTITION BY HASH (`c1`)
373 PARTITIONS 3
374 DROP TABLE t1;
375 SHOW TABLES;
376 Tables_in_test
377 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
378 SHOW TABLES;
379 Tables_in_test
380 t1
381 SHOW CREATE TABLE t1;
382 Table Create Table
383 t1 CREATE TABLE `t1` (
384 `c1` smallint(6) DEFAULT NULL,
385 `c2` char(5) DEFAULT NULL
386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
387 PARTITION BY HASH (`c1`)
388 PARTITIONS 3
389 DROP TABLE t1;
390 SHOW TABLES;
391 Tables_in_test
392 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
393 SHOW TABLES;
394 Tables_in_test
395 t1
396 SHOW CREATE TABLE t1;
397 Table Create Table
398 t1 CREATE TABLE `t1` (
399 `c1` mediumint(9) DEFAULT NULL,
400 `c2` char(5) DEFAULT NULL
401 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
402 PARTITION BY HASH (`c1`)
403 PARTITIONS 3
404 DROP TABLE t1;
405 SHOW TABLES;
406 Tables_in_test
407 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
408 SHOW TABLES;
409 Tables_in_test
410 t1
411 SHOW CREATE TABLE t1;
412 Table Create Table
413 t1 CREATE TABLE `t1` (
414 `c1` int(11) DEFAULT NULL,
415 `c2` char(5) DEFAULT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
417 PARTITION BY HASH (`c1`)
418 PARTITIONS 3
419 DROP TABLE t1;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
423 SHOW TABLES;
424 Tables_in_test
425 t1
426 SHOW CREATE TABLE t1;
427 Table Create Table
428 t1 CREATE TABLE `t1` (
429 `c1` int(11) DEFAULT NULL,
430 `c2` char(5) DEFAULT NULL
431 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
432 PARTITION BY HASH (`c1`)
433 PARTITIONS 3
434 DROP TABLE t1;
435 SHOW TABLES;
436 Tables_in_test
437 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
438 SHOW TABLES;
439 Tables_in_test
440 t1
441 SHOW CREATE TABLE t1;
442 Table Create Table
443 t1 CREATE TABLE `t1` (
444 `c1` bigint(20) DEFAULT NULL,
445 `c2` char(5) DEFAULT NULL
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
447 PARTITION BY HASH (`c1`)
448 PARTITIONS 3
449 DROP TABLE t1;
450 SHOW TABLES;
451 Tables_in_test
452 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
453 SHOW TABLES;
454 Tables_in_test
455 t1
456 SHOW CREATE TABLE t1;
457 Table Create Table
458 t1 CREATE TABLE `t1` (
459 `c1` tinyint(4) NOT NULL,
460 `c2` char(5) DEFAULT NULL
461 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
462 PARTITION BY HASH (`c1`)
463 PARTITIONS 3
464 DROP TABLE t1;
465 SHOW TABLES;
466 Tables_in_test
467 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
468 SHOW TABLES;
469 Tables_in_test
470 t1
471 SHOW CREATE TABLE t1;
472 Table Create Table
473 t1 CREATE TABLE `t1` (
474 `c1` smallint(6) NOT NULL,
475 `c2` char(5) DEFAULT NULL
476 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
477 PARTITION BY HASH (`c1`)
478 PARTITIONS 3
479 DROP TABLE t1;
480 SHOW TABLES;
481 Tables_in_test
482 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
483 SHOW TABLES;
484 Tables_in_test
485 t1
486 SHOW CREATE TABLE t1;
487 Table Create Table
488 t1 CREATE TABLE `t1` (
489 `c1` mediumint(9) NOT NULL,
490 `c2` char(5) DEFAULT NULL
491 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
492 PARTITION BY HASH (`c1`)
493 PARTITIONS 3
494 DROP TABLE t1;
495 SHOW TABLES;
496 Tables_in_test
497 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
498 SHOW TABLES;
499 Tables_in_test
500 t1
501 SHOW CREATE TABLE t1;
502 Table Create Table
503 t1 CREATE TABLE `t1` (
504 `c1` int(11) NOT NULL,
505 `c2` char(5) DEFAULT NULL
506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
507 PARTITION BY HASH (`c1`)
508 PARTITIONS 3
509 DROP TABLE t1;
510 SHOW TABLES;
511 Tables_in_test
512 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
513 SHOW TABLES;
514 Tables_in_test
515 t1
516 SHOW CREATE TABLE t1;
517 Table Create Table
518 t1 CREATE TABLE `t1` (
519 `c1` int(11) NOT NULL,
520 `c2` char(5) DEFAULT NULL
521 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
522 PARTITION BY HASH (`c1`)
523 PARTITIONS 3
524 DROP TABLE t1;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
528 SHOW TABLES;
529 Tables_in_test
530 t1
531 SHOW CREATE TABLE t1;
532 Table Create Table
533 t1 CREATE TABLE `t1` (
534 `c1` bigint(20) NOT NULL,
535 `c2` char(5) DEFAULT NULL
536 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
537 PARTITION BY HASH (`c1`)
538 PARTITIONS 3
539 DROP TABLE t1;
540 SHOW TABLES;
541 Tables_in_test
542 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
543 SHOW TABLES;
544 Tables_in_test
545 t1
546 SHOW CREATE TABLE t1;
547 Table Create Table
548 t1 CREATE TABLE `t1` (
549 `c1` tinyint(4) DEFAULT NULL,
550 `c2` char(5) DEFAULT NULL
551 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
552 PARTITION BY HASH (`c1`)
553 PARTITIONS 4
554 DROP TABLE t1;
555 SHOW TABLES;
556 Tables_in_test
557 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
558 SHOW TABLES;
559 Tables_in_test
560 t1
561 SHOW CREATE TABLE t1;
562 Table Create Table
563 t1 CREATE TABLE `t1` (
564 `c1` smallint(6) DEFAULT NULL,
565 `c2` char(5) DEFAULT NULL
566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
567 PARTITION BY HASH (`c1`)
568 PARTITIONS 4
569 DROP TABLE t1;
570 SHOW TABLES;
571 Tables_in_test
572 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
573 SHOW TABLES;
574 Tables_in_test
575 t1
576 SHOW CREATE TABLE t1;
577 Table Create Table
578 t1 CREATE TABLE `t1` (
579 `c1` mediumint(9) DEFAULT NULL,
580 `c2` char(5) DEFAULT NULL
581 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
582 PARTITION BY HASH (`c1`)
583 PARTITIONS 4
584 DROP TABLE t1;
585 SHOW TABLES;
586 Tables_in_test
587 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
588 SHOW TABLES;
589 Tables_in_test
590 t1
591 SHOW CREATE TABLE t1;
592 Table Create Table
593 t1 CREATE TABLE `t1` (
594 `c1` int(11) DEFAULT NULL,
595 `c2` char(5) DEFAULT NULL
596 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
597 PARTITION BY HASH (`c1`)
598 PARTITIONS 4
599 DROP TABLE t1;
600 SHOW TABLES;
601 Tables_in_test
602 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
603 SHOW TABLES;
604 Tables_in_test
605 t1
606 SHOW CREATE TABLE t1;
607 Table Create Table
608 t1 CREATE TABLE `t1` (
609 `c1` int(11) DEFAULT NULL,
610 `c2` char(5) DEFAULT NULL
611 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
612 PARTITION BY HASH (`c1`)
613 PARTITIONS 4
614 DROP TABLE t1;
615 SHOW TABLES;
616 Tables_in_test
617 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
618 SHOW TABLES;
619 Tables_in_test
620 t1
621 SHOW CREATE TABLE t1;
622 Table Create Table
623 t1 CREATE TABLE `t1` (
624 `c1` bigint(20) DEFAULT NULL,
625 `c2` char(5) DEFAULT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
627 PARTITION BY HASH (`c1`)
628 PARTITIONS 4
629 DROP TABLE t1;
630 SHOW TABLES;
631 Tables_in_test
632 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
633 SHOW TABLES;
634 Tables_in_test
635 t1
636 SHOW CREATE TABLE t1;
637 Table Create Table
638 t1 CREATE TABLE `t1` (
639 `c1` tinyint(4) NOT NULL,
640 `c2` char(5) DEFAULT NULL
641 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
642 PARTITION BY HASH (`c1`)
643 PARTITIONS 4
644 DROP TABLE t1;
645 SHOW TABLES;
646 Tables_in_test
647 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
648 SHOW TABLES;
649 Tables_in_test
650 t1
651 SHOW CREATE TABLE t1;
652 Table Create Table
653 t1 CREATE TABLE `t1` (
654 `c1` smallint(6) NOT NULL,
655 `c2` char(5) DEFAULT NULL
656 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
657 PARTITION BY HASH (`c1`)
658 PARTITIONS 4
659 DROP TABLE t1;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
663 SHOW TABLES;
664 Tables_in_test
665 t1
666 SHOW CREATE TABLE t1;
667 Table Create Table
668 t1 CREATE TABLE `t1` (
669 `c1` mediumint(9) NOT NULL,
670 `c2` char(5) DEFAULT NULL
671 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
672 PARTITION BY HASH (`c1`)
673 PARTITIONS 4
674 DROP TABLE t1;
675 SHOW TABLES;
676 Tables_in_test
677 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
678 SHOW TABLES;
679 Tables_in_test
680 t1
681 SHOW CREATE TABLE t1;
682 Table Create Table
683 t1 CREATE TABLE `t1` (
684 `c1` int(11) NOT NULL,
685 `c2` char(5) DEFAULT NULL
686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
687 PARTITION BY HASH (`c1`)
688 PARTITIONS 4
689 DROP TABLE t1;
690 SHOW TABLES;
691 Tables_in_test
692 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
693 SHOW TABLES;
694 Tables_in_test
695 t1
696 SHOW CREATE TABLE t1;
697 Table Create Table
698 t1 CREATE TABLE `t1` (
699 `c1` int(11) NOT NULL,
700 `c2` char(5) DEFAULT NULL
701 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
702 PARTITION BY HASH (`c1`)
703 PARTITIONS 4
704 DROP TABLE t1;
705 SHOW TABLES;
706 Tables_in_test
707 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
708 SHOW TABLES;
709 Tables_in_test
710 t1
711 SHOW CREATE TABLE t1;
712 Table Create Table
713 t1 CREATE TABLE `t1` (
714 `c1` bigint(20) NOT NULL,
715 `c2` char(5) DEFAULT NULL
716 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
717 PARTITION BY HASH (`c1`)
718 PARTITIONS 4
719 DROP TABLE t1;
720 SHOW TABLES;
721 Tables_in_test
722 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
723 SHOW TABLES;
724 Tables_in_test
725 t1
726 SHOW CREATE TABLE t1;
727 Table Create Table
728 t1 CREATE TABLE `t1` (
729 `c1` tinyint(4) DEFAULT NULL,
730 `c2` char(5) DEFAULT NULL
731 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
732 PARTITION BY HASH (`c1`)
733 PARTITIONS 5
734 DROP TABLE t1;
735 SHOW TABLES;
736 Tables_in_test
737 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
738 SHOW TABLES;
739 Tables_in_test
740 t1
741 SHOW CREATE TABLE t1;
742 Table Create Table
743 t1 CREATE TABLE `t1` (
744 `c1` smallint(6) DEFAULT NULL,
745 `c2` char(5) DEFAULT NULL
746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
747 PARTITION BY HASH (`c1`)
748 PARTITIONS 5
749 DROP TABLE t1;
750 SHOW TABLES;
751 Tables_in_test
752 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
753 SHOW TABLES;
754 Tables_in_test
755 t1
756 SHOW CREATE TABLE t1;
757 Table Create Table
758 t1 CREATE TABLE `t1` (
759 `c1` mediumint(9) DEFAULT NULL,
760 `c2` char(5) DEFAULT NULL
761 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
762 PARTITION BY HASH (`c1`)
763 PARTITIONS 5
764 DROP TABLE t1;
765 SHOW TABLES;
766 Tables_in_test
767 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
768 SHOW TABLES;
769 Tables_in_test
770 t1
771 SHOW CREATE TABLE t1;
772 Table Create Table
773 t1 CREATE TABLE `t1` (
774 `c1` int(11) DEFAULT NULL,
775 `c2` char(5) DEFAULT NULL
776 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
777 PARTITION BY HASH (`c1`)
778 PARTITIONS 5
779 DROP TABLE t1;
780 SHOW TABLES;
781 Tables_in_test
782 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
783 SHOW TABLES;
784 Tables_in_test
785 t1
786 SHOW CREATE TABLE t1;
787 Table Create Table
788 t1 CREATE TABLE `t1` (
789 `c1` int(11) DEFAULT NULL,
790 `c2` char(5) DEFAULT NULL
791 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
792 PARTITION BY HASH (`c1`)
793 PARTITIONS 5
794 DROP TABLE t1;
795 SHOW TABLES;
796 Tables_in_test
797 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
798 SHOW TABLES;
799 Tables_in_test
800 t1
801 SHOW CREATE TABLE t1;
802 Table Create Table
803 t1 CREATE TABLE `t1` (
804 `c1` bigint(20) DEFAULT NULL,
805 `c2` char(5) DEFAULT NULL
806 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
807 PARTITION BY HASH (`c1`)
808 PARTITIONS 5
809 DROP TABLE t1;
810 SHOW TABLES;
811 Tables_in_test
812 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
813 SHOW TABLES;
814 Tables_in_test
815 t1
816 SHOW CREATE TABLE t1;
817 Table Create Table
818 t1 CREATE TABLE `t1` (
819 `c1` tinyint(4) NOT NULL,
820 `c2` char(5) DEFAULT NULL
821 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
822 PARTITION BY HASH (`c1`)
823 PARTITIONS 5
824 DROP TABLE t1;
825 SHOW TABLES;
826 Tables_in_test
827 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
828 SHOW TABLES;
829 Tables_in_test
830 t1
831 SHOW CREATE TABLE t1;
832 Table Create Table
833 t1 CREATE TABLE `t1` (
834 `c1` smallint(6) NOT NULL,
835 `c2` char(5) DEFAULT NULL
836 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
837 PARTITION BY HASH (`c1`)
838 PARTITIONS 5
839 DROP TABLE t1;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
843 SHOW TABLES;
844 Tables_in_test
845 t1
846 SHOW CREATE TABLE t1;
847 Table Create Table
848 t1 CREATE TABLE `t1` (
849 `c1` mediumint(9) NOT NULL,
850 `c2` char(5) DEFAULT NULL
851 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
852 PARTITION BY HASH (`c1`)
853 PARTITIONS 5
854 DROP TABLE t1;
855 SHOW TABLES;
856 Tables_in_test
857 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
858 SHOW TABLES;
859 Tables_in_test
860 t1
861 SHOW CREATE TABLE t1;
862 Table Create Table
863 t1 CREATE TABLE `t1` (
864 `c1` int(11) NOT NULL,
865 `c2` char(5) DEFAULT NULL
866 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
867 PARTITION BY HASH (`c1`)
868 PARTITIONS 5
869 DROP TABLE t1;
870 SHOW TABLES;
871 Tables_in_test
872 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
873 SHOW TABLES;
874 Tables_in_test
875 t1
876 SHOW CREATE TABLE t1;
877 Table Create Table
878 t1 CREATE TABLE `t1` (
879 `c1` int(11) NOT NULL,
880 `c2` char(5) DEFAULT NULL
881 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
882 PARTITION BY HASH (`c1`)
883 PARTITIONS 5
884 DROP TABLE t1;
885 SHOW TABLES;
886 Tables_in_test
887 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
888 SHOW TABLES;
889 Tables_in_test
890 t1
891 SHOW CREATE TABLE t1;
892 Table Create Table
893 t1 CREATE TABLE `t1` (
894 `c1` bigint(20) NOT NULL,
895 `c2` char(5) DEFAULT NULL
896 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
897 PARTITION BY HASH (`c1`)
898 PARTITIONS 5
899 DROP TABLE t1;
900 SHOW TABLES;
901 Tables_in_test
902 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
903 SHOW TABLES;
904 Tables_in_test
905 t1
906 SHOW CREATE TABLE t1;
907 Table Create Table
908 t1 CREATE TABLE `t1` (
909 `c1` tinyint(4) DEFAULT NULL,
910 `c2` char(5) DEFAULT NULL
911 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
912 PARTITION BY HASH (`c1`)
913 PARTITIONS 10
914 DROP TABLE t1;
915 SHOW TABLES;
916 Tables_in_test
917 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
918 SHOW TABLES;
919 Tables_in_test
920 t1
921 SHOW CREATE TABLE t1;
922 Table Create Table
923 t1 CREATE TABLE `t1` (
924 `c1` smallint(6) DEFAULT NULL,
925 `c2` char(5) DEFAULT NULL
926 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
927 PARTITION BY HASH (`c1`)
928 PARTITIONS 10
929 DROP TABLE t1;
930 SHOW TABLES;
931 Tables_in_test
932 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
933 SHOW TABLES;
934 Tables_in_test
935 t1
936 SHOW CREATE TABLE t1;
937 Table Create Table
938 t1 CREATE TABLE `t1` (
939 `c1` mediumint(9) DEFAULT NULL,
940 `c2` char(5) DEFAULT NULL
941 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
942 PARTITION BY HASH (`c1`)
943 PARTITIONS 10
944 DROP TABLE t1;
945 SHOW TABLES;
946 Tables_in_test
947 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
948 SHOW TABLES;
949 Tables_in_test
950 t1
951 SHOW CREATE TABLE t1;
952 Table Create Table
953 t1 CREATE TABLE `t1` (
954 `c1` int(11) DEFAULT NULL,
955 `c2` char(5) DEFAULT NULL
956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
957 PARTITION BY HASH (`c1`)
958 PARTITIONS 10
959 DROP TABLE t1;
960 SHOW TABLES;
961 Tables_in_test
962 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
963 SHOW TABLES;
964 Tables_in_test
965 t1
966 SHOW CREATE TABLE t1;
967 Table Create Table
968 t1 CREATE TABLE `t1` (
969 `c1` int(11) DEFAULT NULL,
970 `c2` char(5) DEFAULT NULL
971 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
972 PARTITION BY HASH (`c1`)
973 PARTITIONS 10
974 DROP TABLE t1;
975 SHOW TABLES;
976 Tables_in_test
977 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
978 SHOW TABLES;
979 Tables_in_test
980 t1
981 SHOW CREATE TABLE t1;
982 Table Create Table
983 t1 CREATE TABLE `t1` (
984 `c1` bigint(20) DEFAULT NULL,
985 `c2` char(5) DEFAULT NULL
986 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
987 PARTITION BY HASH (`c1`)
988 PARTITIONS 10
989 DROP TABLE t1;
990 SHOW TABLES;
991 Tables_in_test
992 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
993 SHOW TABLES;
994 Tables_in_test
995 t1
996 SHOW CREATE TABLE t1;
997 Table Create Table
998 t1 CREATE TABLE `t1` (
999 `c1` tinyint(4) NOT NULL,
1000 `c2` char(5) DEFAULT NULL
1001 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1002 PARTITION BY HASH (`c1`)
1003 PARTITIONS 10
1004 DROP TABLE t1;
1005 SHOW TABLES;
1006 Tables_in_test
1007 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
1008 SHOW TABLES;
1009 Tables_in_test
1010 t1
1011 SHOW CREATE TABLE t1;
1012 Table Create Table
1013 t1 CREATE TABLE `t1` (
1014 `c1` smallint(6) NOT NULL,
1015 `c2` char(5) DEFAULT NULL
1016 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1017 PARTITION BY HASH (`c1`)
1018 PARTITIONS 10
1019 DROP TABLE t1;
1020 SHOW TABLES;
1021 Tables_in_test
1022 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
1023 SHOW TABLES;
1024 Tables_in_test
1025 t1
1026 SHOW CREATE TABLE t1;
1027 Table Create Table
1028 t1 CREATE TABLE `t1` (
1029 `c1` mediumint(9) NOT NULL,
1030 `c2` char(5) DEFAULT NULL
1031 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1032 PARTITION BY HASH (`c1`)
1033 PARTITIONS 10
1034 DROP TABLE t1;
1035 SHOW TABLES;
1036 Tables_in_test
1037 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
1038 SHOW TABLES;
1039 Tables_in_test
1040 t1
1041 SHOW CREATE TABLE t1;
1042 Table Create Table
1043 t1 CREATE TABLE `t1` (
1044 `c1` int(11) NOT NULL,
1045 `c2` char(5) DEFAULT NULL
1046 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1047 PARTITION BY HASH (`c1`)
1048 PARTITIONS 10
1049 DROP TABLE t1;
1050 SHOW TABLES;
1051 Tables_in_test
1052 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
1053 SHOW TABLES;
1054 Tables_in_test
1055 t1
1056 SHOW CREATE TABLE t1;
1057 Table Create Table
1058 t1 CREATE TABLE `t1` (
1059 `c1` int(11) NOT NULL,
1060 `c2` char(5) DEFAULT NULL
1061 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1062 PARTITION BY HASH (`c1`)
1063 PARTITIONS 10
1064 DROP TABLE t1;
1065 SHOW TABLES;
1066 Tables_in_test
1067 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
1068 SHOW TABLES;
1069 Tables_in_test
1070 t1
1071 SHOW CREATE TABLE t1;
1072 Table Create Table
1073 t1 CREATE TABLE `t1` (
1074 `c1` bigint(20) NOT NULL,
1075 `c2` char(5) DEFAULT NULL
1076 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1077 PARTITION BY HASH (`c1`)
1078 PARTITIONS 10
1079 DROP TABLE t1;
1080 SHOW TABLES;
1081 Tables_in_test
1082 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1083 SHOW TABLES;
1084 Tables_in_test
1085 t1
1086 SHOW CREATE TABLE t1;
1087 Table Create Table
1088 t1 CREATE TABLE `t1` (
1089 `c1` tinyint(4) DEFAULT NULL,
1090 `c2` char(5) DEFAULT NULL
1091 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1092 PARTITION BY HASH (`c1`)
1093 PARTITIONS 50
1094 DROP TABLE t1;
1095 SHOW TABLES;
1096 Tables_in_test
1097 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1098 SHOW TABLES;
1099 Tables_in_test
1100 t1
1101 SHOW CREATE TABLE t1;
1102 Table Create Table
1103 t1 CREATE TABLE `t1` (
1104 `c1` smallint(6) DEFAULT NULL,
1105 `c2` char(5) DEFAULT NULL
1106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1107 PARTITION BY HASH (`c1`)
1108 PARTITIONS 50
1109 DROP TABLE t1;
1110 SHOW TABLES;
1111 Tables_in_test
1112 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1113 SHOW TABLES;
1114 Tables_in_test
1115 t1
1116 SHOW CREATE TABLE t1;
1117 Table Create Table
1118 t1 CREATE TABLE `t1` (
1119 `c1` mediumint(9) DEFAULT NULL,
1120 `c2` char(5) DEFAULT NULL
1121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1122 PARTITION BY HASH (`c1`)
1123 PARTITIONS 50
1124 DROP TABLE t1;
1125 SHOW TABLES;
1126 Tables_in_test
1127 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1128 SHOW TABLES;
1129 Tables_in_test
1130 t1
1131 SHOW CREATE TABLE t1;
1132 Table Create Table
1133 t1 CREATE TABLE `t1` (
1134 `c1` int(11) DEFAULT NULL,
1135 `c2` char(5) DEFAULT NULL
1136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1137 PARTITION BY HASH (`c1`)
1138 PARTITIONS 50
1139 DROP TABLE t1;
1140 SHOW TABLES;
1141 Tables_in_test
1142 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1143 SHOW TABLES;
1144 Tables_in_test
1145 t1
1146 SHOW CREATE TABLE t1;
1147 Table Create Table
1148 t1 CREATE TABLE `t1` (
1149 `c1` int(11) DEFAULT NULL,
1150 `c2` char(5) DEFAULT NULL
1151 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1152 PARTITION BY HASH (`c1`)
1153 PARTITIONS 50
1154 DROP TABLE t1;
1155 SHOW TABLES;
1156 Tables_in_test
1157 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1158 SHOW TABLES;
1159 Tables_in_test
1160 t1
1161 SHOW CREATE TABLE t1;
1162 Table Create Table
1163 t1 CREATE TABLE `t1` (
1164 `c1` bigint(20) DEFAULT NULL,
1165 `c2` char(5) DEFAULT NULL
1166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1167 PARTITION BY HASH (`c1`)
1168 PARTITIONS 50
1169 DROP TABLE t1;
1170 SHOW TABLES;
1171 Tables_in_test
1172 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1173 SHOW TABLES;
1174 Tables_in_test
1175 t1
1176 SHOW CREATE TABLE t1;
1177 Table Create Table
1178 t1 CREATE TABLE `t1` (
1179 `c1` tinyint(4) NOT NULL,
1180 `c2` char(5) DEFAULT NULL
1181 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1182 PARTITION BY HASH (`c1`)
1183 PARTITIONS 50
1184 DROP TABLE t1;
1185 SHOW TABLES;
1186 Tables_in_test
1187 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1188 SHOW TABLES;
1189 Tables_in_test
1190 t1
1191 SHOW CREATE TABLE t1;
1192 Table Create Table
1193 t1 CREATE TABLE `t1` (
1194 `c1` smallint(6) NOT NULL,
1195 `c2` char(5) DEFAULT NULL
1196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1197 PARTITION BY HASH (`c1`)
1198 PARTITIONS 50
1199 DROP TABLE t1;
1200 SHOW TABLES;
1201 Tables_in_test
1202 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1203 SHOW TABLES;
1204 Tables_in_test
1205 t1
1206 SHOW CREATE TABLE t1;
1207 Table Create Table
1208 t1 CREATE TABLE `t1` (
1209 `c1` mediumint(9) NOT NULL,
1210 `c2` char(5) DEFAULT NULL
1211 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1212 PARTITION BY HASH (`c1`)
1213 PARTITIONS 50
1214 DROP TABLE t1;
1215 SHOW TABLES;
1216 Tables_in_test
1217 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1218 SHOW TABLES;
1219 Tables_in_test
1220 t1
1221 SHOW CREATE TABLE t1;
1222 Table Create Table
1223 t1 CREATE TABLE `t1` (
1224 `c1` int(11) NOT NULL,
1225 `c2` char(5) DEFAULT NULL
1226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1227 PARTITION BY HASH (`c1`)
1228 PARTITIONS 50
1229 DROP TABLE t1;
1230 SHOW TABLES;
1231 Tables_in_test
1232 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1233 SHOW TABLES;
1234 Tables_in_test
1235 t1
1236 SHOW CREATE TABLE t1;
1237 Table Create Table
1238 t1 CREATE TABLE `t1` (
1239 `c1` int(11) NOT NULL,
1240 `c2` char(5) DEFAULT NULL
1241 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1242 PARTITION BY HASH (`c1`)
1243 PARTITIONS 50
1244 DROP TABLE t1;
1245 SHOW TABLES;
1246 Tables_in_test
1247 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
1248 SHOW TABLES;
1249 Tables_in_test
1250 t1
1251 SHOW CREATE TABLE t1;
1252 Table Create Table
1253 t1 CREATE TABLE `t1` (
1254 `c1` bigint(20) NOT NULL,
1255 `c2` char(5) DEFAULT NULL
1256 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1257 PARTITION BY HASH (`c1`)
1258 PARTITIONS 50
1259 DROP TABLE t1;
1260 SHOW TABLES;
1261 Tables_in_test