Debian Codegraph @

mysql-test/suite/parts/r/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 DEFAULT NULL,
10 `c2` char(5) DEFAULT NULL
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 /*!50100 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 DEFAULT NULL,
25 `c2` char(5) DEFAULT NULL
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 /*!50100 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 DEFAULT NULL,
40 `c2` char(5) DEFAULT NULL
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 /*!50100 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 DEFAULT NULL,
55 `c2` char(5) DEFAULT NULL
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
57 /*!50100 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 DEFAULT NULL,
70 `c2` char(5) DEFAULT NULL
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 /*!50100 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 DEFAULT NULL,
85 `c2` char(5) DEFAULT NULL
86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 /*!50100 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 NOT NULL,
100 `c2` char(5) DEFAULT NULL
101 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
102 /*!50100 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 NOT NULL,
115 `c2` char(5) DEFAULT NULL
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
117 /*!50100 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 NOT NULL,
130 `c2` char(5) DEFAULT NULL
131 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
132 /*!50100 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 NOT NULL,
145 `c2` char(5) DEFAULT NULL
146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
147 /*!50100 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 NOT NULL,
160 `c2` char(5) DEFAULT NULL
161 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
162 /*!50100 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 NOT NULL,
175 `c2` char(5) DEFAULT NULL
176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
177 /*!50100 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 DEFAULT NULL,
190 `c2` char(5) DEFAULT NULL
191 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
192 /*!50100 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 DEFAULT NULL,
205 `c2` char(5) DEFAULT NULL
206 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
207 /*!50100 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 DEFAULT NULL,
220 `c2` char(5) DEFAULT NULL
221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
222 /*!50100 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 DEFAULT NULL,
235 `c2` char(5) DEFAULT NULL
236 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
237 /*!50100 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 DEFAULT NULL,
250 `c2` char(5) DEFAULT NULL
251 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 /*!50100 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 DEFAULT NULL,
265 `c2` char(5) DEFAULT NULL
266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
267 /*!50100 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 NOT NULL,
280 `c2` char(5) DEFAULT NULL
281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
282 /*!50100 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 NOT NULL,
295 `c2` char(5) DEFAULT NULL
296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 /*!50100 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 NOT NULL,
310 `c2` char(5) DEFAULT NULL
311 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
312 /*!50100 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 NOT NULL,
325 `c2` char(5) DEFAULT NULL
326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
327 /*!50100 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 NOT NULL,
340 `c2` char(5) DEFAULT NULL
341 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
342 /*!50100 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 NOT NULL,
355 `c2` char(5) DEFAULT NULL
356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
357 /*!50100 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 DEFAULT NULL,
370 `c2` char(5) DEFAULT NULL
371 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
372 /*!50100 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 DEFAULT NULL,
385 `c2` char(5) DEFAULT NULL
386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
387 /*!50100 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 DEFAULT NULL,
400 `c2` char(5) DEFAULT NULL
401 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
402 /*!50100 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 DEFAULT NULL,
415 `c2` char(5) DEFAULT NULL
416 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 /*!50100 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 DEFAULT NULL,
430 `c2` char(5) DEFAULT NULL
431 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
432 /*!50100 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 DEFAULT NULL,
445 `c2` char(5) DEFAULT NULL
446 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 /*!50100 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 NOT NULL,
460 `c2` char(5) DEFAULT NULL
461 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
462 /*!50100 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 NOT NULL,
475 `c2` char(5) DEFAULT NULL
476 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
477 /*!50100 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 NOT NULL,
490 `c2` char(5) DEFAULT NULL
491 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
492 /*!50100 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 NOT NULL,
505 `c2` char(5) DEFAULT NULL
506 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
507 /*!50100 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 NOT NULL,
520 `c2` char(5) DEFAULT NULL
521 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
522 /*!50100 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 NOT NULL,
535 `c2` char(5) DEFAULT NULL
536 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
537 /*!50100 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 DEFAULT NULL,
550 `c2` char(5) DEFAULT NULL
551 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
552 /*!50100 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 DEFAULT NULL,
565 `c2` char(5) DEFAULT NULL
566 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
567 /*!50100 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 DEFAULT NULL,
580 `c2` char(5) DEFAULT NULL
581 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
582 /*!50100 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 DEFAULT NULL,
595 `c2` char(5) DEFAULT NULL
596 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
597 /*!50100 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 DEFAULT NULL,
610 `c2` char(5) DEFAULT NULL
611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
612 /*!50100 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 DEFAULT NULL,
625 `c2` char(5) DEFAULT NULL
626 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 /*!50100 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 NOT NULL,
640 `c2` char(5) DEFAULT NULL
641 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
642 /*!50100 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 NOT NULL,
655 `c2` char(5) DEFAULT NULL
656 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
657 /*!50100 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 NOT NULL,
670 `c2` char(5) DEFAULT NULL
671 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
672 /*!50100 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 NOT NULL,
685 `c2` char(5) DEFAULT NULL
686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
687 /*!50100 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 NOT NULL,
700 `c2` char(5) DEFAULT NULL
701 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
702 /*!50100 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 NOT NULL,
715 `c2` char(5) DEFAULT NULL
716 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
717 /*!50100 PARTITION BY LINEAR KEY (c1)
718 PARTITIONS 99 */
719 DROP TABLE t1;
720 SHOW TABLES;
721 Tables_in_test