Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t4;
2 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t4
6 SHOW CREATE TABLE t4;
7 Table Create Table
8 t4 CREATE TABLE `t4` (
9 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
11 DROP TABLE t4;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
15 SHOW TABLES;
16 Tables_in_test
17 t4
18 SHOW CREATE TABLE t4;
19 Table Create Table
20 t4 CREATE TABLE `t4` (
21 `c1` smallint(5) unsigned zerofill DEFAULT NULL
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
23 DROP TABLE t4;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
27 SHOW TABLES;
28 Tables_in_test
29 t4
30 SHOW CREATE TABLE t4;
31 Table Create Table
32 t4 CREATE TABLE `t4` (
33 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
35 DROP TABLE t4;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t4(c1 INT ZEROFILL NULL);
39 SHOW TABLES;
40 Tables_in_test
41 t4
42 SHOW CREATE TABLE t4;
43 Table Create Table
44 t4 CREATE TABLE `t4` (
45 `c1` int(10) unsigned zerofill DEFAULT NULL
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
47 DROP TABLE t4;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
51 SHOW TABLES;
52 Tables_in_test
53 t4
54 SHOW CREATE TABLE t4;
55 Table Create Table
56 t4 CREATE TABLE `t4` (
57 `c1` int(10) unsigned zerofill DEFAULT NULL
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
59 DROP TABLE t4;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
63 SHOW TABLES;
64 Tables_in_test
65 t4
66 SHOW CREATE TABLE t4;
67 Table Create Table
68 t4 CREATE TABLE `t4` (
69 `c1` bigint(20) unsigned zerofill DEFAULT NULL
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
71 DROP TABLE t4;
72 SHOW TABLES;
73 Tables_in_test
74 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
75 SHOW TABLES;
76 Tables_in_test
77 t4
78 SHOW CREATE TABLE t4;
79 Table Create Table
80 t4 CREATE TABLE `t4` (
81 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
83 DROP TABLE t4;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t4(c1 DEC ZEROFILL NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t4
90 SHOW CREATE TABLE t4;
91 Table Create Table
92 t4 CREATE TABLE `t4` (
93 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 DROP TABLE t4;
96 SHOW TABLES;
97 Tables_in_test
98 CREATE TABLE t4(c1 FIXED ZEROFILL NULL);
99 SHOW TABLES;
100 Tables_in_test
101 t4
102 SHOW CREATE TABLE t4;
103 Table Create Table
104 t4 CREATE TABLE `t4` (
105 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
107 DROP TABLE t4;
108 SHOW TABLES;
109 Tables_in_test
110 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
111 SHOW TABLES;
112 Tables_in_test
113 t4
114 SHOW CREATE TABLE t4;
115 Table Create Table
116 t4 CREATE TABLE `t4` (
117 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
119 DROP TABLE t4;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
123 SHOW TABLES;
124 Tables_in_test
125 t4
126 SHOW CREATE TABLE t4;
127 Table Create Table
128 t4 CREATE TABLE `t4` (
129 `c1` double unsigned zerofill DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
131 DROP TABLE t4;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
135 SHOW TABLES;
136 Tables_in_test
137 t4
138 SHOW CREATE TABLE t4;
139 Table Create Table
140 t4 CREATE TABLE `t4` (
141 `c1` double unsigned zerofill DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
143 DROP TABLE t4;
144 SHOW TABLES;
145 Tables_in_test
146 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NULL);
147 SHOW TABLES;
148 Tables_in_test
149 t4
150 SHOW CREATE TABLE t4;
151 Table Create Table
152 t4 CREATE TABLE `t4` (
153 `c1` double unsigned zerofill DEFAULT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
155 DROP TABLE t4;
156 SHOW TABLES;
157 Tables_in_test
158 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
159 SHOW TABLES;
160 Tables_in_test
161 t4
162 SHOW CREATE TABLE t4;
163 Table Create Table
164 t4 CREATE TABLE `t4` (
165 `c1` float unsigned zerofill DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
167 DROP TABLE t4;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
171 SHOW TABLES;
172 Tables_in_test
173 t4
174 SHOW CREATE TABLE t4;
175 Table Create Table
176 t4 CREATE TABLE `t4` (
177 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
179 DROP TABLE t4;
180 SHOW TABLES;
181 Tables_in_test
182 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
183 SHOW TABLES;
184 Tables_in_test
185 t4
186 SHOW CREATE TABLE t4;
187 Table Create Table
188 t4 CREATE TABLE `t4` (
189 `c1` smallint(5) unsigned zerofill DEFAULT NULL
190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
191 DROP TABLE t4;
192 SHOW TABLES;
193 Tables_in_test
194 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
195 SHOW TABLES;
196 Tables_in_test
197 t4
198 SHOW CREATE TABLE t4;
199 Table Create Table
200 t4 CREATE TABLE `t4` (
201 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
203 DROP TABLE t4;
204 SHOW TABLES;
205 Tables_in_test
206 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
207 SHOW TABLES;
208 Tables_in_test
209 t4
210 SHOW CREATE TABLE t4;
211 Table Create Table
212 t4 CREATE TABLE `t4` (
213 `c1` int(10) unsigned zerofill DEFAULT NULL
214 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
215 DROP TABLE t4;
216 SHOW TABLES;
217 Tables_in_test
218 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
219 SHOW TABLES;
220 Tables_in_test
221 t4
222 SHOW CREATE TABLE t4;
223 Table Create Table
224 t4 CREATE TABLE `t4` (
225 `c1` int(10) unsigned zerofill DEFAULT NULL
226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
227 DROP TABLE t4;
228 SHOW TABLES;
229 Tables_in_test
230 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
231 SHOW TABLES;
232 Tables_in_test
233 t4
234 SHOW CREATE TABLE t4;
235 Table Create Table
236 t4 CREATE TABLE `t4` (
237 `c1` bigint(20) unsigned zerofill DEFAULT NULL
238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
239 DROP TABLE t4;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
243 SHOW TABLES;
244 Tables_in_test
245 t4
246 SHOW CREATE TABLE t4;
247 Table Create Table
248 t4 CREATE TABLE `t4` (
249 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
251 DROP TABLE t4;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t4
258 SHOW CREATE TABLE t4;
259 Table Create Table
260 t4 CREATE TABLE `t4` (
261 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
263 DROP TABLE t4;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
267 SHOW TABLES;
268 Tables_in_test
269 t4
270 SHOW CREATE TABLE t4;
271 Table Create Table
272 t4 CREATE TABLE `t4` (
273 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
275 DROP TABLE t4;
276 SHOW TABLES;
277 Tables_in_test
278 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
279 SHOW TABLES;
280 Tables_in_test
281 t4
282 SHOW CREATE TABLE t4;
283 Table Create Table
284 t4 CREATE TABLE `t4` (
285 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
287 DROP TABLE t4;
288 SHOW TABLES;
289 Tables_in_test
290 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
291 SHOW TABLES;
292 Tables_in_test
293 t4
294 SHOW CREATE TABLE t4;
295 Table Create Table
296 t4 CREATE TABLE `t4` (
297 `c1` double unsigned zerofill DEFAULT NULL
298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
299 DROP TABLE t4;
300 SHOW TABLES;
301 Tables_in_test
302 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
303 SHOW TABLES;
304 Tables_in_test
305 t4
306 SHOW CREATE TABLE t4;
307 Table Create Table
308 t4 CREATE TABLE `t4` (
309 `c1` double unsigned zerofill DEFAULT NULL
310 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
311 DROP TABLE t4;
312 SHOW TABLES;
313 Tables_in_test
314 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
315 SHOW TABLES;
316 Tables_in_test
317 t4
318 SHOW CREATE TABLE t4;
319 Table Create Table
320 t4 CREATE TABLE `t4` (
321 `c1` double unsigned zerofill DEFAULT NULL
322 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
323 DROP TABLE t4;
324 SHOW TABLES;
325 Tables_in_test
326 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
327 SHOW TABLES;
328 Tables_in_test
329 t4
330 SHOW CREATE TABLE t4;
331 Table Create Table
332 t4 CREATE TABLE `t4` (
333 `c1` float unsigned zerofill DEFAULT NULL
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
335 DROP TABLE t4;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
339 SHOW TABLES;
340 Tables_in_test
341 t4
342 SHOW CREATE TABLE t4;
343 Table Create Table
344 t4 CREATE TABLE `t4` (
345 `c1` tinyint(3) unsigned zerofill NOT NULL
346 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
347 DROP TABLE t4;
348 SHOW TABLES;
349 Tables_in_test
350 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
351 SHOW TABLES;
352 Tables_in_test
353 t4
354 SHOW CREATE TABLE t4;
355 Table Create Table
356 t4 CREATE TABLE `t4` (
357 `c1` smallint(5) unsigned zerofill NOT NULL
358 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
359 DROP TABLE t4;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
363 SHOW TABLES;
364 Tables_in_test
365 t4
366 SHOW CREATE TABLE t4;
367 Table Create Table
368 t4 CREATE TABLE `t4` (
369 `c1` mediumint(8) unsigned zerofill NOT NULL
370 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
371 DROP TABLE t4;
372 SHOW TABLES;
373 Tables_in_test
374 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
375 SHOW TABLES;
376 Tables_in_test
377 t4
378 SHOW CREATE TABLE t4;
379 Table Create Table
380 t4 CREATE TABLE `t4` (
381 `c1` int(10) unsigned zerofill NOT NULL
382 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
383 DROP TABLE t4;
384 SHOW TABLES;
385 Tables_in_test
386 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
387 SHOW TABLES;
388 Tables_in_test
389 t4
390 SHOW CREATE TABLE t4;
391 Table Create Table
392 t4 CREATE TABLE `t4` (
393 `c1` int(10) unsigned zerofill NOT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
395 DROP TABLE t4;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
399 SHOW TABLES;
400 Tables_in_test
401 t4
402 SHOW CREATE TABLE t4;
403 Table Create Table
404 t4 CREATE TABLE `t4` (
405 `c1` bigint(20) unsigned zerofill NOT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
407 DROP TABLE t4;
408 SHOW TABLES;
409 Tables_in_test
410 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
411 SHOW TABLES;
412 Tables_in_test
413 t4
414 SHOW CREATE TABLE t4;
415 Table Create Table
416 t4 CREATE TABLE `t4` (
417 `c1` decimal(10,0) unsigned zerofill NOT NULL
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
419 DROP TABLE t4;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t4(c1 DEC ZEROFILL NOT NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t4
426 SHOW CREATE TABLE t4;
427 Table Create Table
428 t4 CREATE TABLE `t4` (
429 `c1` decimal(10,0) unsigned zerofill NOT NULL
430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
431 DROP TABLE t4;
432 SHOW TABLES;
433 Tables_in_test
434 CREATE TABLE t4(c1 FIXED ZEROFILL NOT NULL);
435 SHOW TABLES;
436 Tables_in_test
437 t4
438 SHOW CREATE TABLE t4;
439 Table Create Table
440 t4 CREATE TABLE `t4` (
441 `c1` decimal(10,0) unsigned zerofill NOT NULL
442 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
443 DROP TABLE t4;
444 SHOW TABLES;
445 Tables_in_test
446 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
447 SHOW TABLES;
448 Tables_in_test
449 t4
450 SHOW CREATE TABLE t4;
451 Table Create Table
452 t4 CREATE TABLE `t4` (
453 `c1` decimal(10,0) unsigned zerofill NOT NULL
454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
455 DROP TABLE t4;
456 SHOW TABLES;
457 Tables_in_test
458 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
459 SHOW TABLES;
460 Tables_in_test
461 t4
462 SHOW CREATE TABLE t4;
463 Table Create Table
464 t4 CREATE TABLE `t4` (
465 `c1` double unsigned zerofill NOT NULL
466 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
467 DROP TABLE t4;
468 SHOW TABLES;
469 Tables_in_test
470 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
471 SHOW TABLES;
472 Tables_in_test
473 t4
474 SHOW CREATE TABLE t4;
475 Table Create Table
476 t4 CREATE TABLE `t4` (
477 `c1` double unsigned zerofill NOT NULL
478 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
479 DROP TABLE t4;
480 SHOW TABLES;
481 Tables_in_test
482 CREATE TABLE t4(c1 DOUBLE PRECISION ZEROFILL NOT NULL);
483 SHOW TABLES;
484 Tables_in_test
485 t4
486 SHOW CREATE TABLE t4;
487 Table Create Table
488 t4 CREATE TABLE `t4` (
489 `c1` double unsigned zerofill NOT NULL
490 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
491 DROP TABLE t4;
492 SHOW TABLES;
493 Tables_in_test
494 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
495 SHOW TABLES;
496 Tables_in_test
497 t4
498 SHOW CREATE TABLE t4;
499 Table Create Table
500 t4 CREATE TABLE `t4` (
501 `c1` float unsigned zerofill NOT NULL
502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
503 DROP TABLE t4;
504 SHOW TABLES;
505 Tables_in_test
506 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
507 SHOW TABLES;
508 Tables_in_test
509 t4
510 SHOW CREATE TABLE t4;
511 Table Create Table
512 t4 CREATE TABLE `t4` (
513 `c1` tinyint(3) unsigned zerofill NOT NULL
514 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
515 DROP TABLE t4;
516 SHOW TABLES;
517 Tables_in_test
518 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
519 SHOW TABLES;
520 Tables_in_test
521 t4
522 SHOW CREATE TABLE t4;
523 Table Create Table
524 t4 CREATE TABLE `t4` (
525 `c1` smallint(5) unsigned zerofill NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
527 DROP TABLE t4;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
531 SHOW TABLES;
532 Tables_in_test
533 t4
534 SHOW CREATE TABLE t4;
535 Table Create Table
536 t4 CREATE TABLE `t4` (
537 `c1` mediumint(8) unsigned zerofill NOT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
539 DROP TABLE t4;
540 SHOW TABLES;
541 Tables_in_test
542 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
543 SHOW TABLES;
544 Tables_in_test
545 t4
546 SHOW CREATE TABLE t4;
547 Table Create Table
548 t4 CREATE TABLE `t4` (
549 `c1` int(10) unsigned zerofill NOT NULL
550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
551 DROP TABLE t4;
552 SHOW TABLES;
553 Tables_in_test
554 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
555 SHOW TABLES;
556 Tables_in_test
557 t4
558 SHOW CREATE TABLE t4;
559 Table Create Table
560 t4 CREATE TABLE `t4` (
561 `c1` int(10) unsigned zerofill NOT NULL
562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
563 DROP TABLE t4;
564 SHOW TABLES;
565 Tables_in_test
566 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
567 SHOW TABLES;
568 Tables_in_test
569 t4
570 SHOW CREATE TABLE t4;
571 Table Create Table
572 t4 CREATE TABLE `t4` (
573 `c1` bigint(20) unsigned zerofill NOT NULL
574 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
575 DROP TABLE t4;
576 SHOW TABLES;
577 Tables_in_test
578 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
579 SHOW TABLES;
580 Tables_in_test
581 t4
582 SHOW CREATE TABLE t4;
583 Table Create Table
584 t4 CREATE TABLE `t4` (
585 `c1` decimal(10,0) unsigned zerofill NOT NULL
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
587 DROP TABLE t4;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t4
594 SHOW CREATE TABLE t4;
595 Table Create Table
596 t4 CREATE TABLE `t4` (
597 `c1` decimal(10,0) unsigned zerofill NOT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
599 DROP TABLE t4;
600 SHOW TABLES;
601 Tables_in_test
602 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
603 SHOW TABLES;
604 Tables_in_test
605 t4
606 SHOW CREATE TABLE t4;
607 Table Create Table
608 t4 CREATE TABLE `t4` (
609 `c1` decimal(10,0) unsigned zerofill NOT NULL
610 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
611 DROP TABLE t4;
612 SHOW TABLES;
613 Tables_in_test
614 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
615 SHOW TABLES;
616 Tables_in_test
617 t4
618 SHOW CREATE TABLE t4;
619 Table Create Table
620 t4 CREATE TABLE `t4` (
621 `c1` decimal(10,0) unsigned zerofill NOT NULL
622 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
623 DROP TABLE t4;
624 SHOW TABLES;
625 Tables_in_test
626 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
627 SHOW TABLES;
628 Tables_in_test
629 t4
630 SHOW CREATE TABLE t4;
631 Table Create Table
632 t4 CREATE TABLE `t4` (
633 `c1` double unsigned zerofill NOT NULL
634 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
635 DROP TABLE t4;
636 SHOW TABLES;
637 Tables_in_test
638 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
639 SHOW TABLES;
640 Tables_in_test
641 t4
642 SHOW CREATE TABLE t4;
643 Table Create Table
644 t4 CREATE TABLE `t4` (
645 `c1` double unsigned zerofill NOT NULL
646 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
647 DROP TABLE t4;
648 SHOW TABLES;
649 Tables_in_test
650 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
651 SHOW TABLES;
652 Tables_in_test
653 t4
654 SHOW CREATE TABLE t4;
655 Table Create Table
656 t4 CREATE TABLE `t4` (
657 `c1` double unsigned zerofill NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
659 DROP TABLE t4;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
663 SHOW TABLES;
664 Tables_in_test
665 t4
666 SHOW CREATE TABLE t4;
667 Table Create Table
668 t4 CREATE TABLE `t4` (
669 `c1` float unsigned zerofill NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
671 DROP TABLE t4;
672 SHOW TABLES;
673 Tables_in_test