Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
13 PARTITIONS 2
14 DROP TABLE t1;
15 SHOW TABLES;
16 Tables_in_test
17 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
28 PARTITIONS 2
29 DROP TABLE t1;
30 SHOW TABLES;
31 Tables_in_test
32 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
43 PARTITIONS 2
44 DROP TABLE t1;
45 SHOW TABLES;
46 Tables_in_test
47 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
58 PARTITIONS 2
59 DROP TABLE t1;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
73 PARTITIONS 2
74 DROP TABLE t1;
75 SHOW TABLES;
76 Tables_in_test
77 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
88 PARTITIONS 2
89 DROP TABLE t1;
90 SHOW TABLES;
91 Tables_in_test
92 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
103 PARTITIONS 2
104 DROP TABLE t1;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
118 PARTITIONS 2
119 DROP TABLE t1;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
133 PARTITIONS 2
134 DROP TABLE t1;
135 SHOW TABLES;
136 Tables_in_test
137 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
148 PARTITIONS 2
149 DROP TABLE t1;
150 SHOW TABLES;
151 Tables_in_test
152 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
163 PARTITIONS 2
164 DROP TABLE t1;
165 SHOW TABLES;
166 Tables_in_test
167 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
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 LINEAR KEY (`c1`)
178 PARTITIONS 2
179 DROP TABLE t1;
180 SHOW TABLES;
181 Tables_in_test
182 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
193 PARTITIONS 4
194 DROP TABLE t1;
195 SHOW TABLES;
196 Tables_in_test
197 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
208 PARTITIONS 4
209 DROP TABLE t1;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
223 PARTITIONS 4
224 DROP TABLE t1;
225 SHOW TABLES;
226 Tables_in_test
227 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
238 PARTITIONS 4
239 DROP TABLE t1;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
253 PARTITIONS 4
254 DROP TABLE t1;
255 SHOW TABLES;
256 Tables_in_test
257 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
268 PARTITIONS 4
269 DROP TABLE t1;
270 SHOW TABLES;
271 Tables_in_test
272 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
283 PARTITIONS 4
284 DROP TABLE t1;
285 SHOW TABLES;
286 Tables_in_test
287 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
298 PARTITIONS 4
299 DROP TABLE t1;
300 SHOW TABLES;
301 Tables_in_test
302 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
313 PARTITIONS 4
314 DROP TABLE t1;
315 SHOW TABLES;
316 Tables_in_test
317 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
328 PARTITIONS 4
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
343 PARTITIONS 4
344 DROP TABLE t1;
345 SHOW TABLES;
346 Tables_in_test
347 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
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 LINEAR KEY (`c1`)
358 PARTITIONS 4
359 DROP TABLE t1;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
373 PARTITIONS 5
374 DROP TABLE t1;
375 SHOW TABLES;
376 Tables_in_test
377 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
388 PARTITIONS 5
389 DROP TABLE t1;
390 SHOW TABLES;
391 Tables_in_test
392 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
403 PARTITIONS 5
404 DROP TABLE t1;
405 SHOW TABLES;
406 Tables_in_test
407 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
418 PARTITIONS 5
419 DROP TABLE t1;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
433 PARTITIONS 5
434 DROP TABLE t1;
435 SHOW TABLES;
436 Tables_in_test
437 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
448 PARTITIONS 5
449 DROP TABLE t1;
450 SHOW TABLES;
451 Tables_in_test
452 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
463 PARTITIONS 5
464 DROP TABLE t1;
465 SHOW TABLES;
466 Tables_in_test
467 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
478 PARTITIONS 5
479 DROP TABLE t1;
480 SHOW TABLES;
481 Tables_in_test
482 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
493 PARTITIONS 5
494 DROP TABLE t1;
495 SHOW TABLES;
496 Tables_in_test
497 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
508 PARTITIONS 5
509 DROP TABLE t1;
510 SHOW TABLES;
511 Tables_in_test
512 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
523 PARTITIONS 5
524 DROP TABLE t1;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
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 LINEAR KEY (`c1`)
538 PARTITIONS 5
539 DROP TABLE t1;
540 SHOW TABLES;
541 Tables_in_test
542 CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
553 PARTITIONS 99
554 DROP TABLE t1;
555 SHOW TABLES;
556 Tables_in_test
557 CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
568 PARTITIONS 99
569 DROP TABLE t1;
570 SHOW TABLES;
571 Tables_in_test
572 CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
583 PARTITIONS 99
584 DROP TABLE t1;
585 SHOW TABLES;
586 Tables_in_test
587 CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
598 PARTITIONS 99
599 DROP TABLE t1;
600 SHOW TABLES;
601 Tables_in_test
602 CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
613 PARTITIONS 99
614 DROP TABLE t1;
615 SHOW TABLES;
616 Tables_in_test
617 CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
628 PARTITIONS 99
629 DROP TABLE t1;
630 SHOW TABLES;
631 Tables_in_test
632 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
643 PARTITIONS 99
644 DROP TABLE t1;
645 SHOW TABLES;
646 Tables_in_test
647 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
658 PARTITIONS 99
659 DROP TABLE t1;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
673 PARTITIONS 99
674 DROP TABLE t1;
675 SHOW TABLES;
676 Tables_in_test
677 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
688 PARTITIONS 99
689 DROP TABLE t1;
690 SHOW TABLES;
691 Tables_in_test
692 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
703 PARTITIONS 99
704 DROP TABLE t1;
705 SHOW TABLES;
706 Tables_in_test
707 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
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 LINEAR KEY (`c1`)
718 PARTITIONS 99
719 DROP TABLE t1;
720 SHOW TABLES;
721 Tables_in_test