Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_column_from_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 ALTER TABLE t4 MODIFY c1 TINYINT NULL;
12 SHOW TABLES;
13 Tables_in_test
14 t4
15 SHOW CREATE TABLE t4;
16 Table Create Table
17 t4 CREATE TABLE `t4` (
18 `c1` tinyint(4) DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 DROP TABLE t4;
21 SHOW TABLES;
22 Tables_in_test
23 CREATE TABLE t4(c1 SMALLINT ZEROFILL NULL);
24 SHOW TABLES;
25 Tables_in_test
26 t4
27 SHOW CREATE TABLE t4;
28 Table Create Table
29 t4 CREATE TABLE `t4` (
30 `c1` smallint(5) unsigned zerofill DEFAULT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
32 ALTER TABLE t4 MODIFY c1 SMALLINT NULL;
33 SHOW TABLES;
34 Tables_in_test
35 t4
36 SHOW CREATE TABLE t4;
37 Table Create Table
38 t4 CREATE TABLE `t4` (
39 `c1` smallint(6) DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
41 DROP TABLE t4;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
45 SHOW TABLES;
46 Tables_in_test
47 t4
48 SHOW CREATE TABLE t4;
49 Table Create Table
50 t4 CREATE TABLE `t4` (
51 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
53 ALTER TABLE t4 MODIFY c1 MEDIUMINT NULL;
54 SHOW TABLES;
55 Tables_in_test
56 t4
57 SHOW CREATE TABLE t4;
58 Table Create Table
59 t4 CREATE TABLE `t4` (
60 `c1` mediumint(9) DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
62 DROP TABLE t4;
63 SHOW TABLES;
64 Tables_in_test
65 CREATE TABLE t4(c1 INT ZEROFILL NULL);
66 SHOW TABLES;
67 Tables_in_test
68 t4
69 SHOW CREATE TABLE t4;
70 Table Create Table
71 t4 CREATE TABLE `t4` (
72 `c1` int(10) unsigned zerofill DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
74 ALTER TABLE t4 MODIFY c1 INT 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` int(11) 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 INTEGER 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` int(10) unsigned zerofill DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 ALTER TABLE t4 MODIFY c1 INTEGER NULL;
96 SHOW TABLES;
97 Tables_in_test
98 t4
99 SHOW CREATE TABLE t4;
100 Table Create Table
101 t4 CREATE TABLE `t4` (
102 `c1` int(11) DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
104 DROP TABLE t4;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t4(c1 BIGINT ZEROFILL NULL);
108 SHOW TABLES;
109 Tables_in_test
110 t4
111 SHOW CREATE TABLE t4;
112 Table Create Table
113 t4 CREATE TABLE `t4` (
114 `c1` bigint(20) unsigned zerofill DEFAULT NULL
115 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
116 ALTER TABLE t4 MODIFY c1 BIGINT NULL;
117 SHOW TABLES;
118 Tables_in_test
119 t4
120 SHOW CREATE TABLE t4;
121 Table Create Table
122 t4 CREATE TABLE `t4` (
123 `c1` bigint(20) DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
125 DROP TABLE t4;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
129 SHOW TABLES;
130 Tables_in_test
131 t4
132 SHOW CREATE TABLE t4;
133 Table Create Table
134 t4 CREATE TABLE `t4` (
135 `c1` double unsigned zerofill DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
137 ALTER TABLE t4 MODIFY c1 REAL NULL;
138 SHOW TABLES;
139 Tables_in_test
140 t4
141 SHOW CREATE TABLE t4;
142 Table Create Table
143 t4 CREATE TABLE `t4` (
144 `c1` double DEFAULT NULL
145 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
146 DROP TABLE t4;
147 SHOW TABLES;
148 Tables_in_test
149 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
150 SHOW TABLES;
151 Tables_in_test
152 t4
153 SHOW CREATE TABLE t4;
154 Table Create Table
155 t4 CREATE TABLE `t4` (
156 `c1` double unsigned zerofill DEFAULT NULL
157 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
158 ALTER TABLE t4 MODIFY c1 DOUBLE 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` double 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 FLOAT 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` float unsigned zerofill DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
179 ALTER TABLE t4 MODIFY c1 FLOAT NULL;
180 SHOW TABLES;
181 Tables_in_test
182 t4
183 SHOW CREATE TABLE t4;
184 Table Create Table
185 t4 CREATE TABLE `t4` (
186 `c1` float DEFAULT NULL
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
188 DROP TABLE t4;
189 SHOW TABLES;
190 Tables_in_test
191 CREATE TABLE t4(c1 DECIMAL ZEROFILL NULL);
192 SHOW TABLES;
193 Tables_in_test
194 t4
195 SHOW CREATE TABLE t4;
196 Table Create Table
197 t4 CREATE TABLE `t4` (
198 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
199 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
200 ALTER TABLE t4 MODIFY c1 DECIMAL NULL;
201 SHOW TABLES;
202 Tables_in_test
203 t4
204 SHOW CREATE TABLE t4;
205 Table Create Table
206 t4 CREATE TABLE `t4` (
207 `c1` decimal(10,0) DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
209 DROP TABLE t4;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
213 SHOW TABLES;
214 Tables_in_test
215 t4
216 SHOW CREATE TABLE t4;
217 Table Create Table
218 t4 CREATE TABLE `t4` (
219 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
220 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
221 ALTER TABLE t4 MODIFY c1 NUMERIC NULL;
222 SHOW TABLES;
223 Tables_in_test
224 t4
225 SHOW CREATE TABLE t4;
226 Table Create Table
227 t4 CREATE TABLE `t4` (
228 `c1` decimal(10,0) DEFAULT NULL
229 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
230 DROP TABLE t4;
231 SHOW TABLES;
232 Tables_in_test
233 CREATE TABLE t4(c1 TINYINT ZEROFILL NULL);
234 SHOW TABLES;
235 Tables_in_test
236 t4
237 SHOW CREATE TABLE t4;
238 Table Create Table
239 t4 CREATE TABLE `t4` (
240 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
241 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
242 ALTER TABLE t4 CHANGE c1 c1 TINYINT 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` tinyint(4) 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 SMALLINT 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` smallint(5) unsigned zerofill DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
263 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NULL;
264 SHOW TABLES;
265 Tables_in_test
266 t4
267 SHOW CREATE TABLE t4;
268 Table Create Table
269 t4 CREATE TABLE `t4` (
270 `c1` smallint(6) DEFAULT NULL
271 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
272 DROP TABLE t4;
273 SHOW TABLES;
274 Tables_in_test
275 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NULL);
276 SHOW TABLES;
277 Tables_in_test
278 t4
279 SHOW CREATE TABLE t4;
280 Table Create Table
281 t4 CREATE TABLE `t4` (
282 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
283 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
284 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NULL;
285 SHOW TABLES;
286 Tables_in_test
287 t4
288 SHOW CREATE TABLE t4;
289 Table Create Table
290 t4 CREATE TABLE `t4` (
291 `c1` mediumint(9) DEFAULT NULL
292 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
293 DROP TABLE t4;
294 SHOW TABLES;
295 Tables_in_test
296 CREATE TABLE t4(c1 INT ZEROFILL NULL);
297 SHOW TABLES;
298 Tables_in_test
299 t4
300 SHOW CREATE TABLE t4;
301 Table Create Table
302 t4 CREATE TABLE `t4` (
303 `c1` int(10) unsigned zerofill DEFAULT NULL
304 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
305 ALTER TABLE t4 CHANGE c1 c1 INT NULL;
306 SHOW TABLES;
307 Tables_in_test
308 t4
309 SHOW CREATE TABLE t4;
310 Table Create Table
311 t4 CREATE TABLE `t4` (
312 `c1` int(11) DEFAULT NULL
313 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
314 DROP TABLE t4;
315 SHOW TABLES;
316 Tables_in_test
317 CREATE TABLE t4(c1 INTEGER ZEROFILL NULL);
318 SHOW TABLES;
319 Tables_in_test
320 t4
321 SHOW CREATE TABLE t4;
322 Table Create Table
323 t4 CREATE TABLE `t4` (
324 `c1` int(10) unsigned zerofill DEFAULT NULL
325 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
326 ALTER TABLE t4 CHANGE c1 c1 INTEGER 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` int(11) 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 BIGINT ZEROFILL 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` bigint(20) unsigned zerofill DEFAULT NULL
346 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
347 ALTER TABLE t4 CHANGE c1 c1 BIGINT NULL;
348 SHOW TABLES;
349 Tables_in_test
350 t4
351 SHOW CREATE TABLE t4;
352 Table Create Table
353 t4 CREATE TABLE `t4` (
354 `c1` bigint(20) DEFAULT NULL
355 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
356 DROP TABLE t4;
357 SHOW TABLES;
358 Tables_in_test
359 CREATE TABLE t4(c1 REAL ZEROFILL NULL);
360 SHOW TABLES;
361 Tables_in_test
362 t4
363 SHOW CREATE TABLE t4;
364 Table Create Table
365 t4 CREATE TABLE `t4` (
366 `c1` double unsigned zerofill DEFAULT NULL
367 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
368 ALTER TABLE t4 CHANGE c1 c1 REAL NULL;
369 SHOW TABLES;
370 Tables_in_test
371 t4
372 SHOW CREATE TABLE t4;
373 Table Create Table
374 t4 CREATE TABLE `t4` (
375 `c1` double DEFAULT NULL
376 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
377 DROP TABLE t4;
378 SHOW TABLES;
379 Tables_in_test
380 CREATE TABLE t4(c1 DOUBLE ZEROFILL NULL);
381 SHOW TABLES;
382 Tables_in_test
383 t4
384 SHOW CREATE TABLE t4;
385 Table Create Table
386 t4 CREATE TABLE `t4` (
387 `c1` double unsigned zerofill DEFAULT NULL
388 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
389 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NULL;
390 SHOW TABLES;
391 Tables_in_test
392 t4
393 SHOW CREATE TABLE t4;
394 Table Create Table
395 t4 CREATE TABLE `t4` (
396 `c1` double DEFAULT NULL
397 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
398 DROP TABLE t4;
399 SHOW TABLES;
400 Tables_in_test
401 CREATE TABLE t4(c1 FLOAT ZEROFILL NULL);
402 SHOW TABLES;
403 Tables_in_test
404 t4
405 SHOW CREATE TABLE t4;
406 Table Create Table
407 t4 CREATE TABLE `t4` (
408 `c1` float unsigned zerofill DEFAULT NULL
409 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
410 ALTER TABLE t4 CHANGE c1 c1 FLOAT 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` float DEFAULT 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 DECIMAL ZEROFILL 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 DEFAULT NULL
430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
431 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NULL;
432 SHOW TABLES;
433 Tables_in_test
434 t4
435 SHOW CREATE TABLE t4;
436 Table Create Table
437 t4 CREATE TABLE `t4` (
438 `c1` decimal(10,0) DEFAULT NULL
439 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
440 DROP TABLE t4;
441 SHOW TABLES;
442 Tables_in_test
443 CREATE TABLE t4(c1 NUMERIC ZEROFILL NULL);
444 SHOW TABLES;
445 Tables_in_test
446 t4
447 SHOW CREATE TABLE t4;
448 Table Create Table
449 t4 CREATE TABLE `t4` (
450 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
451 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
452 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NULL;
453 SHOW TABLES;
454 Tables_in_test
455 t4
456 SHOW CREATE TABLE t4;
457 Table Create Table
458 t4 CREATE TABLE `t4` (
459 `c1` decimal(10,0) DEFAULT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
461 DROP TABLE t4;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
465 SHOW TABLES;
466 Tables_in_test
467 t4
468 SHOW CREATE TABLE t4;
469 Table Create Table
470 t4 CREATE TABLE `t4` (
471 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
473 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NULL;
474 SHOW TABLES;
475 Tables_in_test
476 t4
477 SHOW CREATE TABLE t4;
478 Table Create Table
479 t4 CREATE TABLE `t4` (
480 `c1` tinyint(3) unsigned DEFAULT NULL
481 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
482 DROP TABLE t4;
483 SHOW TABLES;
484 Tables_in_test
485 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
486 SHOW TABLES;
487 Tables_in_test
488 t4
489 SHOW CREATE TABLE t4;
490 Table Create Table
491 t4 CREATE TABLE `t4` (
492 `c1` smallint(5) unsigned zerofill DEFAULT NULL
493 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
494 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED 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` smallint(5) unsigned DEFAULT 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 MEDIUMINT UNSIGNED ZEROFILL 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` mediumint(8) unsigned zerofill DEFAULT NULL
514 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
515 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NULL;
516 SHOW TABLES;
517 Tables_in_test
518 t4
519 SHOW CREATE TABLE t4;
520 Table Create Table
521 t4 CREATE TABLE `t4` (
522 `c1` mediumint(8) unsigned DEFAULT NULL
523 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
524 DROP TABLE t4;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
528 SHOW TABLES;
529 Tables_in_test
530 t4
531 SHOW CREATE TABLE t4;
532 Table Create Table
533 t4 CREATE TABLE `t4` (
534 `c1` int(10) unsigned zerofill DEFAULT NULL
535 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
536 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NULL;
537 SHOW TABLES;
538 Tables_in_test
539 t4
540 SHOW CREATE TABLE t4;
541 Table Create Table
542 t4 CREATE TABLE `t4` (
543 `c1` int(10) unsigned DEFAULT NULL
544 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
545 DROP TABLE t4;
546 SHOW TABLES;
547 Tables_in_test
548 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
549 SHOW TABLES;
550 Tables_in_test
551 t4
552 SHOW CREATE TABLE t4;
553 Table Create Table
554 t4 CREATE TABLE `t4` (
555 `c1` int(10) unsigned zerofill DEFAULT NULL
556 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
557 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NULL;
558 SHOW TABLES;
559 Tables_in_test
560 t4
561 SHOW CREATE TABLE t4;
562 Table Create Table
563 t4 CREATE TABLE `t4` (
564 `c1` int(10) unsigned DEFAULT NULL
565 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
566 DROP TABLE t4;
567 SHOW TABLES;
568 Tables_in_test
569 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
570 SHOW TABLES;
571 Tables_in_test
572 t4
573 SHOW CREATE TABLE t4;
574 Table Create Table
575 t4 CREATE TABLE `t4` (
576 `c1` bigint(20) unsigned zerofill DEFAULT NULL
577 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
578 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED 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` bigint(20) unsigned DEFAULT 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 REAL UNSIGNED ZEROFILL 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` double unsigned zerofill DEFAULT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
599 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NULL;
600 SHOW TABLES;
601 Tables_in_test
602 t4
603 SHOW CREATE TABLE t4;
604 Table Create Table
605 t4 CREATE TABLE `t4` (
606 `c1` double unsigned DEFAULT NULL
607 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
608 DROP TABLE t4;
609 SHOW TABLES;
610 Tables_in_test
611 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
612 SHOW TABLES;
613 Tables_in_test
614 t4
615 SHOW CREATE TABLE t4;
616 Table Create Table
617 t4 CREATE TABLE `t4` (
618 `c1` double unsigned zerofill DEFAULT NULL
619 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
620 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NULL;
621 SHOW TABLES;
622 Tables_in_test
623 t4
624 SHOW CREATE TABLE t4;
625 Table Create Table
626 t4 CREATE TABLE `t4` (
627 `c1` double unsigned DEFAULT NULL
628 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
629 DROP TABLE t4;
630 SHOW TABLES;
631 Tables_in_test
632 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
633 SHOW TABLES;
634 Tables_in_test
635 t4
636 SHOW CREATE TABLE t4;
637 Table Create Table
638 t4 CREATE TABLE `t4` (
639 `c1` float unsigned zerofill DEFAULT NULL
640 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
641 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NULL;
642 SHOW TABLES;
643 Tables_in_test
644 t4
645 SHOW CREATE TABLE t4;
646 Table Create Table
647 t4 CREATE TABLE `t4` (
648 `c1` float unsigned DEFAULT NULL
649 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
650 DROP TABLE t4;
651 SHOW TABLES;
652 Tables_in_test
653 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
654 SHOW TABLES;
655 Tables_in_test
656 t4
657 SHOW CREATE TABLE t4;
658 Table Create Table
659 t4 CREATE TABLE `t4` (
660 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
662 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED 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` decimal(10,0) unsigned DEFAULT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
671 DROP TABLE t4;
672 SHOW TABLES;
673 Tables_in_test
674 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
675 SHOW TABLES;
676 Tables_in_test
677 t4
678 SHOW CREATE TABLE t4;
679 Table Create Table
680 t4 CREATE TABLE `t4` (
681 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
683 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NULL;
684 SHOW TABLES;
685 Tables_in_test
686 t4
687 SHOW CREATE TABLE t4;
688 Table Create Table
689 t4 CREATE TABLE `t4` (
690 `c1` decimal(10,0) unsigned DEFAULT NULL
691 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
692 DROP TABLE t4;
693 SHOW TABLES;
694 Tables_in_test
695 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
696 SHOW TABLES;
697 Tables_in_test
698 t4
699 SHOW CREATE TABLE t4;
700 Table Create Table
701 t4 CREATE TABLE `t4` (
702 `c1` tinyint(3) unsigned zerofill DEFAULT NULL
703 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
704 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NULL;
705 SHOW TABLES;
706 Tables_in_test
707 t4
708 SHOW CREATE TABLE t4;
709 Table Create Table
710 t4 CREATE TABLE `t4` (
711 `c1` tinyint(3) unsigned DEFAULT NULL
712 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
713 DROP TABLE t4;
714 SHOW TABLES;
715 Tables_in_test
716 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
717 SHOW TABLES;
718 Tables_in_test
719 t4
720 SHOW CREATE TABLE t4;
721 Table Create Table
722 t4 CREATE TABLE `t4` (
723 `c1` smallint(5) unsigned zerofill DEFAULT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
725 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
726 SHOW TABLES;
727 Tables_in_test
728 t4
729 SHOW CREATE TABLE t4;
730 Table Create Table
731 t4 CREATE TABLE `t4` (
732 `c1` smallint(5) unsigned DEFAULT NULL
733 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
734 DROP TABLE t4;
735 SHOW TABLES;
736 Tables_in_test
737 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
738 SHOW TABLES;
739 Tables_in_test
740 t4
741 SHOW CREATE TABLE t4;
742 Table Create Table
743 t4 CREATE TABLE `t4` (
744 `c1` mediumint(8) unsigned zerofill DEFAULT NULL
745 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
746 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
747 SHOW TABLES;
748 Tables_in_test
749 t4
750 SHOW CREATE TABLE t4;
751 Table Create Table
752 t4 CREATE TABLE `t4` (
753 `c1` mediumint(8) unsigned DEFAULT NULL
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
755 DROP TABLE t4;
756 SHOW TABLES;
757 Tables_in_test
758 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
759 SHOW TABLES;
760 Tables_in_test
761 t4
762 SHOW CREATE TABLE t4;
763 Table Create Table
764 t4 CREATE TABLE `t4` (
765 `c1` int(10) unsigned zerofill DEFAULT NULL
766 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
767 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NULL;
768 SHOW TABLES;
769 Tables_in_test
770 t4
771 SHOW CREATE TABLE t4;
772 Table Create Table
773 t4 CREATE TABLE `t4` (
774 `c1` int(10) unsigned DEFAULT NULL
775 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
776 DROP TABLE t4;
777 SHOW TABLES;
778 Tables_in_test
779 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
780 SHOW TABLES;
781 Tables_in_test
782 t4
783 SHOW CREATE TABLE t4;
784 Table Create Table
785 t4 CREATE TABLE `t4` (
786 `c1` int(10) unsigned zerofill DEFAULT NULL
787 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
788 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NULL;
789 SHOW TABLES;
790 Tables_in_test
791 t4
792 SHOW CREATE TABLE t4;
793 Table Create Table
794 t4 CREATE TABLE `t4` (
795 `c1` int(10) unsigned DEFAULT NULL
796 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
797 DROP TABLE t4;
798 SHOW TABLES;
799 Tables_in_test
800 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
801 SHOW TABLES;
802 Tables_in_test
803 t4
804 SHOW CREATE TABLE t4;
805 Table Create Table
806 t4 CREATE TABLE `t4` (
807 `c1` bigint(20) unsigned zerofill DEFAULT NULL
808 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
809 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NULL;
810 SHOW TABLES;
811 Tables_in_test
812 t4
813 SHOW CREATE TABLE t4;
814 Table Create Table
815 t4 CREATE TABLE `t4` (
816 `c1` bigint(20) unsigned DEFAULT NULL
817 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
818 DROP TABLE t4;
819 SHOW TABLES;
820 Tables_in_test
821 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
822 SHOW TABLES;
823 Tables_in_test
824 t4
825 SHOW CREATE TABLE t4;
826 Table Create Table
827 t4 CREATE TABLE `t4` (
828 `c1` double unsigned zerofill DEFAULT NULL
829 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
830 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NULL;
831 SHOW TABLES;
832 Tables_in_test
833 t4
834 SHOW CREATE TABLE t4;
835 Table Create Table
836 t4 CREATE TABLE `t4` (
837 `c1` double unsigned DEFAULT NULL
838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
839 DROP TABLE t4;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
843 SHOW TABLES;
844 Tables_in_test
845 t4
846 SHOW CREATE TABLE t4;
847 Table Create Table
848 t4 CREATE TABLE `t4` (
849 `c1` double unsigned zerofill DEFAULT NULL
850 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
851 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
852 SHOW TABLES;
853 Tables_in_test
854 t4
855 SHOW CREATE TABLE t4;
856 Table Create Table
857 t4 CREATE TABLE `t4` (
858 `c1` double unsigned DEFAULT NULL
859 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
860 DROP TABLE t4;
861 SHOW TABLES;
862 Tables_in_test
863 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
864 SHOW TABLES;
865 Tables_in_test
866 t4
867 SHOW CREATE TABLE t4;
868 Table Create Table
869 t4 CREATE TABLE `t4` (
870 `c1` float unsigned zerofill DEFAULT NULL
871 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
872 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NULL;
873 SHOW TABLES;
874 Tables_in_test
875 t4
876 SHOW CREATE TABLE t4;
877 Table Create Table
878 t4 CREATE TABLE `t4` (
879 `c1` float unsigned DEFAULT NULL
880 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
881 DROP TABLE t4;
882 SHOW TABLES;
883 Tables_in_test
884 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
885 SHOW TABLES;
886 Tables_in_test
887 t4
888 SHOW CREATE TABLE t4;
889 Table Create Table
890 t4 CREATE TABLE `t4` (
891 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
892 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
893 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
894 SHOW TABLES;
895 Tables_in_test
896 t4
897 SHOW CREATE TABLE t4;
898 Table Create Table
899 t4 CREATE TABLE `t4` (
900 `c1` decimal(10,0) unsigned DEFAULT NULL
901 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
902 DROP TABLE t4;
903 SHOW TABLES;
904 Tables_in_test
905 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
906 SHOW TABLES;
907 Tables_in_test
908 t4
909 SHOW CREATE TABLE t4;
910 Table Create Table
911 t4 CREATE TABLE `t4` (
912 `c1` decimal(10,0) unsigned zerofill DEFAULT NULL
913 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
914 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
915 SHOW TABLES;
916 Tables_in_test
917 t4
918 SHOW CREATE TABLE t4;
919 Table Create Table
920 t4 CREATE TABLE `t4` (
921 `c1` decimal(10,0) unsigned DEFAULT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
923 DROP TABLE t4;
924 SHOW TABLES;
925 Tables_in_test
926 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
927 SHOW TABLES;
928 Tables_in_test
929 t4
930 SHOW CREATE TABLE t4;
931 Table Create Table
932 t4 CREATE TABLE `t4` (
933 `c1` tinyint(3) unsigned zerofill NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
935 ALTER TABLE t4 MODIFY c1 TINYINT NOT NULL;
936 SHOW TABLES;
937 Tables_in_test
938 t4
939 SHOW CREATE TABLE t4;
940 Table Create Table
941 t4 CREATE TABLE `t4` (
942 `c1` tinyint(4) NOT NULL
943 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
944 DROP TABLE t4;
945 SHOW TABLES;
946 Tables_in_test
947 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
948 SHOW TABLES;
949 Tables_in_test
950 t4
951 SHOW CREATE TABLE t4;
952 Table Create Table
953 t4 CREATE TABLE `t4` (
954 `c1` smallint(5) unsigned zerofill NOT NULL
955 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
956 ALTER TABLE t4 MODIFY c1 SMALLINT NOT NULL;
957 SHOW TABLES;
958 Tables_in_test
959 t4
960 SHOW CREATE TABLE t4;
961 Table Create Table
962 t4 CREATE TABLE `t4` (
963 `c1` smallint(6) NOT NULL
964 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
965 DROP TABLE t4;
966 SHOW TABLES;
967 Tables_in_test
968 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
969 SHOW TABLES;
970 Tables_in_test
971 t4
972 SHOW CREATE TABLE t4;
973 Table Create Table
974 t4 CREATE TABLE `t4` (
975 `c1` mediumint(8) unsigned zerofill NOT NULL
976 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
977 ALTER TABLE t4 MODIFY c1 MEDIUMINT NOT NULL;
978 SHOW TABLES;
979 Tables_in_test
980 t4
981 SHOW CREATE TABLE t4;
982 Table Create Table
983 t4 CREATE TABLE `t4` (
984 `c1` mediumint(9) NOT NULL
985 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
986 DROP TABLE t4;
987 SHOW TABLES;
988 Tables_in_test
989 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
990 SHOW TABLES;
991 Tables_in_test
992 t4
993 SHOW CREATE TABLE t4;
994 Table Create Table
995 t4 CREATE TABLE `t4` (
996 `c1` int(10) unsigned zerofill NOT NULL
997 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
998 ALTER TABLE t4 MODIFY c1 INT NOT NULL;
999 SHOW TABLES;
1000 Tables_in_test
1001 t4
1002 SHOW CREATE TABLE t4;
1003 Table Create Table
1004 t4 CREATE TABLE `t4` (
1005 `c1` int(11) NOT NULL
1006 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1007 DROP TABLE t4;
1008 SHOW TABLES;
1009 Tables_in_test
1010 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1011 SHOW TABLES;
1012 Tables_in_test
1013 t4
1014 SHOW CREATE TABLE t4;
1015 Table Create Table
1016 t4 CREATE TABLE `t4` (
1017 `c1` int(10) unsigned zerofill NOT NULL
1018 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1019 ALTER TABLE t4 MODIFY c1 INTEGER NOT NULL;
1020 SHOW TABLES;
1021 Tables_in_test
1022 t4
1023 SHOW CREATE TABLE t4;
1024 Table Create Table
1025 t4 CREATE TABLE `t4` (
1026 `c1` int(11) NOT NULL
1027 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1028 DROP TABLE t4;
1029 SHOW TABLES;
1030 Tables_in_test
1031 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1032 SHOW TABLES;
1033 Tables_in_test
1034 t4
1035 SHOW CREATE TABLE t4;
1036 Table Create Table
1037 t4 CREATE TABLE `t4` (
1038 `c1` bigint(20) unsigned zerofill NOT NULL
1039 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1040 ALTER TABLE t4 MODIFY c1 BIGINT NOT NULL;
1041 SHOW TABLES;
1042 Tables_in_test
1043 t4
1044 SHOW CREATE TABLE t4;
1045 Table Create Table
1046 t4 CREATE TABLE `t4` (
1047 `c1` bigint(20) NOT NULL
1048 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1049 DROP TABLE t4;
1050 SHOW TABLES;
1051 Tables_in_test
1052 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1053 SHOW TABLES;
1054 Tables_in_test
1055 t4
1056 SHOW CREATE TABLE t4;
1057 Table Create Table
1058 t4 CREATE TABLE `t4` (
1059 `c1` double unsigned zerofill NOT NULL
1060 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1061 ALTER TABLE t4 MODIFY c1 REAL NOT NULL;
1062 SHOW TABLES;
1063 Tables_in_test
1064 t4
1065 SHOW CREATE TABLE t4;
1066 Table Create Table
1067 t4 CREATE TABLE `t4` (
1068 `c1` double NOT NULL
1069 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1070 DROP TABLE t4;
1071 SHOW TABLES;
1072 Tables_in_test
1073 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1074 SHOW TABLES;
1075 Tables_in_test
1076 t4
1077 SHOW CREATE TABLE t4;
1078 Table Create Table
1079 t4 CREATE TABLE `t4` (
1080 `c1` double unsigned zerofill NOT NULL
1081 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1082 ALTER TABLE t4 MODIFY c1 DOUBLE NOT NULL;
1083 SHOW TABLES;
1084 Tables_in_test
1085 t4
1086 SHOW CREATE TABLE t4;
1087 Table Create Table
1088 t4 CREATE TABLE `t4` (
1089 `c1` double NOT NULL
1090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1091 DROP TABLE t4;
1092 SHOW TABLES;
1093 Tables_in_test
1094 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1095 SHOW TABLES;
1096 Tables_in_test
1097 t4
1098 SHOW CREATE TABLE t4;
1099 Table Create Table
1100 t4 CREATE TABLE `t4` (
1101 `c1` float unsigned zerofill NOT NULL
1102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1103 ALTER TABLE t4 MODIFY c1 FLOAT NOT NULL;
1104 SHOW TABLES;
1105 Tables_in_test
1106 t4
1107 SHOW CREATE TABLE t4;
1108 Table Create Table
1109 t4 CREATE TABLE `t4` (
1110 `c1` float NOT NULL
1111 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1112 DROP TABLE t4;
1113 SHOW TABLES;
1114 Tables_in_test
1115 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1116 SHOW TABLES;
1117 Tables_in_test
1118 t4
1119 SHOW CREATE TABLE t4;
1120 Table Create Table
1121 t4 CREATE TABLE `t4` (
1122 `c1` decimal(10,0) unsigned zerofill NOT NULL
1123 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1124 ALTER TABLE t4 MODIFY c1 DECIMAL NOT NULL;
1125 SHOW TABLES;
1126 Tables_in_test
1127 t4
1128 SHOW CREATE TABLE t4;
1129 Table Create Table
1130 t4 CREATE TABLE `t4` (
1131 `c1` decimal(10,0) NOT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1133 DROP TABLE t4;
1134 SHOW TABLES;
1135 Tables_in_test
1136 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1137 SHOW TABLES;
1138 Tables_in_test
1139 t4
1140 SHOW CREATE TABLE t4;
1141 Table Create Table
1142 t4 CREATE TABLE `t4` (
1143 `c1` decimal(10,0) unsigned zerofill NOT NULL
1144 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1145 ALTER TABLE t4 MODIFY c1 NUMERIC NOT NULL;
1146 SHOW TABLES;
1147 Tables_in_test
1148 t4
1149 SHOW CREATE TABLE t4;
1150 Table Create Table
1151 t4 CREATE TABLE `t4` (
1152 `c1` decimal(10,0) NOT NULL
1153 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1154 DROP TABLE t4;
1155 SHOW TABLES;
1156 Tables_in_test
1157 CREATE TABLE t4(c1 TINYINT ZEROFILL NOT NULL);
1158 SHOW TABLES;
1159 Tables_in_test
1160 t4
1161 SHOW CREATE TABLE t4;
1162 Table Create Table
1163 t4 CREATE TABLE `t4` (
1164 `c1` tinyint(3) unsigned zerofill NOT NULL
1165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1166 ALTER TABLE t4 CHANGE c1 c1 TINYINT NOT NULL;
1167 SHOW TABLES;
1168 Tables_in_test
1169 t4
1170 SHOW CREATE TABLE t4;
1171 Table Create Table
1172 t4 CREATE TABLE `t4` (
1173 `c1` tinyint(4) NOT NULL
1174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1175 DROP TABLE t4;
1176 SHOW TABLES;
1177 Tables_in_test
1178 CREATE TABLE t4(c1 SMALLINT ZEROFILL NOT NULL);
1179 SHOW TABLES;
1180 Tables_in_test
1181 t4
1182 SHOW CREATE TABLE t4;
1183 Table Create Table
1184 t4 CREATE TABLE `t4` (
1185 `c1` smallint(5) unsigned zerofill NOT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1187 ALTER TABLE t4 CHANGE c1 c1 SMALLINT NOT NULL;
1188 SHOW TABLES;
1189 Tables_in_test
1190 t4
1191 SHOW CREATE TABLE t4;
1192 Table Create Table
1193 t4 CREATE TABLE `t4` (
1194 `c1` smallint(6) NOT NULL
1195 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1196 DROP TABLE t4;
1197 SHOW TABLES;
1198 Tables_in_test
1199 CREATE TABLE t4(c1 MEDIUMINT ZEROFILL NOT NULL);
1200 SHOW TABLES;
1201 Tables_in_test
1202 t4
1203 SHOW CREATE TABLE t4;
1204 Table Create Table
1205 t4 CREATE TABLE `t4` (
1206 `c1` mediumint(8) unsigned zerofill NOT NULL
1207 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1208 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT NOT NULL;
1209 SHOW TABLES;
1210 Tables_in_test
1211 t4
1212 SHOW CREATE TABLE t4;
1213 Table Create Table
1214 t4 CREATE TABLE `t4` (
1215 `c1` mediumint(9) NOT NULL
1216 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1217 DROP TABLE t4;
1218 SHOW TABLES;
1219 Tables_in_test
1220 CREATE TABLE t4(c1 INT ZEROFILL NOT NULL);
1221 SHOW TABLES;
1222 Tables_in_test
1223 t4
1224 SHOW CREATE TABLE t4;
1225 Table Create Table
1226 t4 CREATE TABLE `t4` (
1227 `c1` int(10) unsigned zerofill NOT NULL
1228 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1229 ALTER TABLE t4 CHANGE c1 c1 INT NOT NULL;
1230 SHOW TABLES;
1231 Tables_in_test
1232 t4
1233 SHOW CREATE TABLE t4;
1234 Table Create Table
1235 t4 CREATE TABLE `t4` (
1236 `c1` int(11) NOT NULL
1237 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1238 DROP TABLE t4;
1239 SHOW TABLES;
1240 Tables_in_test
1241 CREATE TABLE t4(c1 INTEGER ZEROFILL NOT NULL);
1242 SHOW TABLES;
1243 Tables_in_test
1244 t4
1245 SHOW CREATE TABLE t4;
1246 Table Create Table
1247 t4 CREATE TABLE `t4` (
1248 `c1` int(10) unsigned zerofill NOT NULL
1249 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1250 ALTER TABLE t4 CHANGE c1 c1 INTEGER NOT NULL;
1251 SHOW TABLES;
1252 Tables_in_test
1253 t4
1254 SHOW CREATE TABLE t4;
1255 Table Create Table
1256 t4 CREATE TABLE `t4` (
1257 `c1` int(11) NOT NULL
1258 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1259 DROP TABLE t4;
1260 SHOW TABLES;
1261 Tables_in_test
1262 CREATE TABLE t4(c1 BIGINT ZEROFILL NOT NULL);
1263 SHOW TABLES;
1264 Tables_in_test
1265 t4
1266 SHOW CREATE TABLE t4;
1267 Table Create Table
1268 t4 CREATE TABLE `t4` (
1269 `c1` bigint(20) unsigned zerofill NOT NULL
1270 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1271 ALTER TABLE t4 CHANGE c1 c1 BIGINT NOT NULL;
1272 SHOW TABLES;
1273 Tables_in_test
1274 t4
1275 SHOW CREATE TABLE t4;
1276 Table Create Table
1277 t4 CREATE TABLE `t4` (
1278 `c1` bigint(20) NOT NULL
1279 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1280 DROP TABLE t4;
1281 SHOW TABLES;
1282 Tables_in_test
1283 CREATE TABLE t4(c1 REAL ZEROFILL NOT NULL);
1284 SHOW TABLES;
1285 Tables_in_test
1286 t4
1287 SHOW CREATE TABLE t4;
1288 Table Create Table
1289 t4 CREATE TABLE `t4` (
1290 `c1` double unsigned zerofill NOT NULL
1291 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1292 ALTER TABLE t4 CHANGE c1 c1 REAL NOT NULL;
1293 SHOW TABLES;
1294 Tables_in_test
1295 t4
1296 SHOW CREATE TABLE t4;
1297 Table Create Table
1298 t4 CREATE TABLE `t4` (
1299 `c1` double NOT NULL
1300 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1301 DROP TABLE t4;
1302 SHOW TABLES;
1303 Tables_in_test
1304 CREATE TABLE t4(c1 DOUBLE ZEROFILL NOT NULL);
1305 SHOW TABLES;
1306 Tables_in_test
1307 t4
1308 SHOW CREATE TABLE t4;
1309 Table Create Table
1310 t4 CREATE TABLE `t4` (
1311 `c1` double unsigned zerofill NOT NULL
1312 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1313 ALTER TABLE t4 CHANGE c1 c1 DOUBLE NOT NULL;
1314 SHOW TABLES;
1315 Tables_in_test
1316 t4
1317 SHOW CREATE TABLE t4;
1318 Table Create Table
1319 t4 CREATE TABLE `t4` (
1320 `c1` double NOT NULL
1321 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1322 DROP TABLE t4;
1323 SHOW TABLES;
1324 Tables_in_test
1325 CREATE TABLE t4(c1 FLOAT ZEROFILL NOT NULL);
1326 SHOW TABLES;
1327 Tables_in_test
1328 t4
1329 SHOW CREATE TABLE t4;
1330 Table Create Table
1331 t4 CREATE TABLE `t4` (
1332 `c1` float unsigned zerofill NOT NULL
1333 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1334 ALTER TABLE t4 CHANGE c1 c1 FLOAT NOT NULL;
1335 SHOW TABLES;
1336 Tables_in_test
1337 t4
1338 SHOW CREATE TABLE t4;
1339 Table Create Table
1340 t4 CREATE TABLE `t4` (
1341 `c1` float NOT NULL
1342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1343 DROP TABLE t4;
1344 SHOW TABLES;
1345 Tables_in_test
1346 CREATE TABLE t4(c1 DECIMAL ZEROFILL NOT NULL);
1347 SHOW TABLES;
1348 Tables_in_test
1349 t4
1350 SHOW CREATE TABLE t4;
1351 Table Create Table
1352 t4 CREATE TABLE `t4` (
1353 `c1` decimal(10,0) unsigned zerofill NOT NULL
1354 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1355 ALTER TABLE t4 CHANGE c1 c1 DECIMAL NOT NULL;
1356 SHOW TABLES;
1357 Tables_in_test
1358 t4
1359 SHOW CREATE TABLE t4;
1360 Table Create Table
1361 t4 CREATE TABLE `t4` (
1362 `c1` decimal(10,0) NOT NULL
1363 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1364 DROP TABLE t4;
1365 SHOW TABLES;
1366 Tables_in_test
1367 CREATE TABLE t4(c1 NUMERIC ZEROFILL NOT NULL);
1368 SHOW TABLES;
1369 Tables_in_test
1370 t4
1371 SHOW CREATE TABLE t4;
1372 Table Create Table
1373 t4 CREATE TABLE `t4` (
1374 `c1` decimal(10,0) unsigned zerofill NOT NULL
1375 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1376 ALTER TABLE t4 CHANGE c1 c1 NUMERIC NOT NULL;
1377 SHOW TABLES;
1378 Tables_in_test
1379 t4
1380 SHOW CREATE TABLE t4;
1381 Table Create Table
1382 t4 CREATE TABLE `t4` (
1383 `c1` decimal(10,0) NOT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1385 DROP TABLE t4;
1386 SHOW TABLES;
1387 Tables_in_test
1388 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1389 SHOW TABLES;
1390 Tables_in_test
1391 t4
1392 SHOW CREATE TABLE t4;
1393 Table Create Table
1394 t4 CREATE TABLE `t4` (
1395 `c1` tinyint(3) unsigned zerofill NOT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1397 ALTER TABLE t4 MODIFY c1 TINYINT UNSIGNED NOT NULL;
1398 SHOW TABLES;
1399 Tables_in_test
1400 t4
1401 SHOW CREATE TABLE t4;
1402 Table Create Table
1403 t4 CREATE TABLE `t4` (
1404 `c1` tinyint(3) unsigned NOT NULL
1405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1406 DROP TABLE t4;
1407 SHOW TABLES;
1408 Tables_in_test
1409 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1410 SHOW TABLES;
1411 Tables_in_test
1412 t4
1413 SHOW CREATE TABLE t4;
1414 Table Create Table
1415 t4 CREATE TABLE `t4` (
1416 `c1` smallint(5) unsigned zerofill NOT NULL
1417 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1418 ALTER TABLE t4 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
1419 SHOW TABLES;
1420 Tables_in_test
1421 t4
1422 SHOW CREATE TABLE t4;
1423 Table Create Table
1424 t4 CREATE TABLE `t4` (
1425 `c1` smallint(5) unsigned NOT NULL
1426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1427 DROP TABLE t4;
1428 SHOW TABLES;
1429 Tables_in_test
1430 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1431 SHOW TABLES;
1432 Tables_in_test
1433 t4
1434 SHOW CREATE TABLE t4;
1435 Table Create Table
1436 t4 CREATE TABLE `t4` (
1437 `c1` mediumint(8) unsigned zerofill NOT NULL
1438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1439 ALTER TABLE t4 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
1440 SHOW TABLES;
1441 Tables_in_test
1442 t4
1443 SHOW CREATE TABLE t4;
1444 Table Create Table
1445 t4 CREATE TABLE `t4` (
1446 `c1` mediumint(8) unsigned NOT NULL
1447 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1448 DROP TABLE t4;
1449 SHOW TABLES;
1450 Tables_in_test
1451 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1452 SHOW TABLES;
1453 Tables_in_test
1454 t4
1455 SHOW CREATE TABLE t4;
1456 Table Create Table
1457 t4 CREATE TABLE `t4` (
1458 `c1` int(10) unsigned zerofill NOT NULL
1459 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1460 ALTER TABLE t4 MODIFY c1 INT UNSIGNED NOT NULL;
1461 SHOW TABLES;
1462 Tables_in_test
1463 t4
1464 SHOW CREATE TABLE t4;
1465 Table Create Table
1466 t4 CREATE TABLE `t4` (
1467 `c1` int(10) unsigned NOT NULL
1468 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1469 DROP TABLE t4;
1470 SHOW TABLES;
1471 Tables_in_test
1472 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1473 SHOW TABLES;
1474 Tables_in_test
1475 t4
1476 SHOW CREATE TABLE t4;
1477 Table Create Table
1478 t4 CREATE TABLE `t4` (
1479 `c1` int(10) unsigned zerofill NOT NULL
1480 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1481 ALTER TABLE t4 MODIFY c1 INTEGER UNSIGNED NOT NULL;
1482 SHOW TABLES;
1483 Tables_in_test
1484 t4
1485 SHOW CREATE TABLE t4;
1486 Table Create Table
1487 t4 CREATE TABLE `t4` (
1488 `c1` int(10) unsigned NOT NULL
1489 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1490 DROP TABLE t4;
1491 SHOW TABLES;
1492 Tables_in_test
1493 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1494 SHOW TABLES;
1495 Tables_in_test
1496 t4
1497 SHOW CREATE TABLE t4;
1498 Table Create Table
1499 t4 CREATE TABLE `t4` (
1500 `c1` bigint(20) unsigned zerofill NOT NULL
1501 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1502 ALTER TABLE t4 MODIFY c1 BIGINT UNSIGNED NOT NULL;
1503 SHOW TABLES;
1504 Tables_in_test
1505 t4
1506 SHOW CREATE TABLE t4;
1507 Table Create Table
1508 t4 CREATE TABLE `t4` (
1509 `c1` bigint(20) unsigned NOT NULL
1510 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1511 DROP TABLE t4;
1512 SHOW TABLES;
1513 Tables_in_test
1514 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1515 SHOW TABLES;
1516 Tables_in_test
1517 t4
1518 SHOW CREATE TABLE t4;
1519 Table Create Table
1520 t4 CREATE TABLE `t4` (
1521 `c1` double unsigned zerofill NOT NULL
1522 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1523 ALTER TABLE t4 MODIFY c1 REAL UNSIGNED NOT NULL;
1524 SHOW TABLES;
1525 Tables_in_test
1526 t4
1527 SHOW CREATE TABLE t4;
1528 Table Create Table
1529 t4 CREATE TABLE `t4` (
1530 `c1` double unsigned NOT NULL
1531 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1532 DROP TABLE t4;
1533 SHOW TABLES;
1534 Tables_in_test
1535 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1536 SHOW TABLES;
1537 Tables_in_test
1538 t4
1539 SHOW CREATE TABLE t4;
1540 Table Create Table
1541 t4 CREATE TABLE `t4` (
1542 `c1` double unsigned zerofill NOT NULL
1543 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1544 ALTER TABLE t4 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
1545 SHOW TABLES;
1546 Tables_in_test
1547 t4
1548 SHOW CREATE TABLE t4;
1549 Table Create Table
1550 t4 CREATE TABLE `t4` (
1551 `c1` double unsigned NOT NULL
1552 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1553 DROP TABLE t4;
1554 SHOW TABLES;
1555 Tables_in_test
1556 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
1557 SHOW TABLES;
1558 Tables_in_test
1559 t4
1560 SHOW CREATE TABLE t4;
1561 Table Create Table
1562 t4 CREATE TABLE `t4` (
1563 `c1` float unsigned zerofill NOT NULL
1564 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1565 ALTER TABLE t4 MODIFY c1 FLOAT UNSIGNED NOT NULL;
1566 SHOW TABLES;
1567 Tables_in_test
1568 t4
1569 SHOW CREATE TABLE t4;
1570 Table Create Table
1571 t4 CREATE TABLE `t4` (
1572 `c1` float unsigned NOT NULL
1573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1574 DROP TABLE t4;
1575 SHOW TABLES;
1576 Tables_in_test
1577 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
1578 SHOW TABLES;
1579 Tables_in_test
1580 t4
1581 SHOW CREATE TABLE t4;
1582 Table Create Table
1583 t4 CREATE TABLE `t4` (
1584 `c1` decimal(10,0) unsigned zerofill NOT NULL
1585 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1586 ALTER TABLE t4 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
1587 SHOW TABLES;
1588 Tables_in_test
1589 t4
1590 SHOW CREATE TABLE t4;
1591 Table Create Table
1592 t4 CREATE TABLE `t4` (
1593 `c1` decimal(10,0) unsigned NOT NULL
1594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1595 DROP TABLE t4;
1596 SHOW TABLES;
1597 Tables_in_test
1598 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
1599 SHOW TABLES;
1600 Tables_in_test
1601 t4
1602 SHOW CREATE TABLE t4;
1603 Table Create Table
1604 t4 CREATE TABLE `t4` (
1605 `c1` decimal(10,0) unsigned zerofill NOT NULL
1606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1607 ALTER TABLE t4 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
1608 SHOW TABLES;
1609 Tables_in_test
1610 t4
1611 SHOW CREATE TABLE t4;
1612 Table Create Table
1613 t4 CREATE TABLE `t4` (
1614 `c1` decimal(10,0) unsigned NOT NULL
1615 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1616 DROP TABLE t4;
1617 SHOW TABLES;
1618 Tables_in_test
1619 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
1620 SHOW TABLES;
1621 Tables_in_test
1622 t4
1623 SHOW CREATE TABLE t4;
1624 Table Create Table
1625 t4 CREATE TABLE `t4` (
1626 `c1` tinyint(3) unsigned zerofill NOT NULL
1627 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1628 ALTER TABLE t4 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
1629 SHOW TABLES;
1630 Tables_in_test
1631 t4
1632 SHOW CREATE TABLE t4;
1633 Table Create Table
1634 t4 CREATE TABLE `t4` (
1635 `c1` tinyint(3) unsigned NOT NULL
1636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1637 DROP TABLE t4;
1638 SHOW TABLES;
1639 Tables_in_test
1640 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
1641 SHOW TABLES;
1642 Tables_in_test
1643 t4
1644 SHOW CREATE TABLE t4;
1645 Table Create Table
1646 t4 CREATE TABLE `t4` (
1647 `c1` smallint(5) unsigned zerofill NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1649 ALTER TABLE t4 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
1650 SHOW TABLES;
1651 Tables_in_test
1652 t4
1653 SHOW CREATE TABLE t4;
1654 Table Create Table
1655 t4 CREATE TABLE `t4` (
1656 `c1` smallint(5) unsigned NOT NULL
1657 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1658 DROP TABLE t4;
1659 SHOW TABLES;
1660 Tables_in_test
1661 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
1662 SHOW TABLES;
1663 Tables_in_test
1664 t4
1665 SHOW CREATE TABLE t4;
1666 Table Create Table
1667 t4 CREATE TABLE `t4` (
1668 `c1` mediumint(8) unsigned zerofill NOT NULL
1669 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1670 ALTER TABLE t4 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
1671 SHOW TABLES;
1672 Tables_in_test
1673 t4
1674 SHOW CREATE TABLE t4;
1675 Table Create Table
1676 t4 CREATE TABLE `t4` (
1677 `c1` mediumint(8) unsigned NOT NULL
1678 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1679 DROP TABLE t4;
1680 SHOW TABLES;
1681 Tables_in_test
1682 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
1683 SHOW TABLES;
1684 Tables_in_test
1685 t4
1686 SHOW CREATE TABLE t4;
1687 Table Create Table
1688 t4 CREATE TABLE `t4` (
1689 `c1` int(10) unsigned zerofill NOT NULL
1690 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1691 ALTER TABLE t4 CHANGE c1 c1 INT UNSIGNED NOT NULL;
1692 SHOW TABLES;
1693 Tables_in_test
1694 t4
1695 SHOW CREATE TABLE t4;
1696 Table Create Table
1697 t4 CREATE TABLE `t4` (
1698 `c1` int(10) unsigned NOT NULL
1699 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1700 DROP TABLE t4;
1701 SHOW TABLES;
1702 Tables_in_test
1703 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
1704 SHOW TABLES;
1705 Tables_in_test
1706 t4
1707 SHOW CREATE TABLE t4;
1708 Table Create Table
1709 t4 CREATE TABLE `t4` (
1710 `c1` int(10) unsigned zerofill NOT NULL
1711 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1712 ALTER TABLE t4 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
1713 SHOW TABLES;
1714 Tables_in_test
1715 t4
1716 SHOW CREATE TABLE t4;
1717 Table Create Table
1718 t4 CREATE TABLE `t4` (
1719 `c1` int(10) unsigned NOT NULL
1720 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1721 DROP TABLE t4;
1722 SHOW TABLES;
1723 Tables_in_test
1724 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
1725 SHOW TABLES;
1726 Tables_in_test
1727 t4
1728 SHOW CREATE TABLE t4;
1729 Table Create Table
1730 t4 CREATE TABLE `t4` (
1731 `c1` bigint(20) unsigned zerofill NOT NULL
1732 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1733 ALTER TABLE t4 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
1734 SHOW TABLES;
1735 Tables_in_test
1736 t4
1737 SHOW CREATE TABLE t4;
1738 Table Create Table
1739 t4 CREATE TABLE `t4` (
1740 `c1` bigint(20) unsigned NOT NULL
1741 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1742 DROP TABLE t4;
1743 SHOW TABLES;
1744 Tables_in_test
1745 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
1746 SHOW TABLES;
1747 Tables_in_test
1748 t4
1749 SHOW CREATE TABLE t4;
1750 Table Create Table
1751 t4 CREATE TABLE `t4` (
1752 `c1` double unsigned zerofill NOT NULL
1753 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1754 ALTER TABLE t4 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
1755 SHOW TABLES;
1756 Tables_in_test
1757 t4
1758 SHOW CREATE TABLE t4;
1759 Table Create Table
1760 t4 CREATE TABLE `t4` (
1761 `c1` double unsigned NOT NULL
1762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1763 DROP TABLE t4;
1764 SHOW TABLES;
1765 Tables_in_test
1766 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
1767 SHOW TABLES;
1768 Tables_in_test
1769 t4
1770 SHOW CREATE TABLE t4;
1771 Table Create Table
1772 t4 CREATE TABLE `t4` (
1773 `c1` double unsigned zerofill NOT NULL
1774 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1775 ALTER TABLE t4 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
1776 SHOW TABLES;
1777 Tables_in_test
1778 t4
1779 SHOW CREATE TABLE t4;
1780 Table Create Table
1781 t4 CREATE TABLE `t4` (
1782 `c1` double unsigned NOT NULL
1783 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1784 DROP TABLE t4;
1785 SHOW TABLES;
1786 Tables_in_test
1787 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
1788 SHOW TABLES;
1789 Tables_in_test
1790 t4
1791 SHOW CREATE TABLE t4;
1792 Table Create Table
1793 t4 CREATE TABLE `t4` (
1794 `c1` float unsigned zerofill NOT NULL
1795 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1796 ALTER TABLE t4 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
1797 SHOW TABLES;
1798 Tables_in_test
1799 t4
1800 SHOW CREATE TABLE t4;
1801 Table Create Table
1802 t4 CREATE TABLE `t4` (
1803 `c1` float unsigned NOT NULL
1804 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1805 DROP TABLE t4;
1806 SHOW TABLES;
1807 Tables_in_test
1808 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
1809 SHOW TABLES;
1810 Tables_in_test
1811 t4
1812 SHOW CREATE TABLE t4;
1813 Table Create Table
1814 t4 CREATE TABLE `t4` (
1815 `c1` decimal(10,0) unsigned zerofill NOT NULL
1816 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1817 ALTER TABLE t4 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
1818 SHOW TABLES;
1819 Tables_in_test
1820 t4
1821 SHOW CREATE TABLE t4;
1822 Table Create Table
1823 t4 CREATE TABLE `t4` (
1824 `c1` decimal(10,0) unsigned NOT NULL
1825 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1826 DROP TABLE t4;
1827 SHOW TABLES;
1828 Tables_in_test
1829 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
1830 SHOW TABLES;
1831 Tables_in_test
1832 t4
1833 SHOW CREATE TABLE t4;
1834 Table Create Table
1835 t4 CREATE TABLE `t4` (
1836 `c1` decimal(10,0) unsigned zerofill NOT NULL
1837 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1838 ALTER TABLE t4 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
1839 SHOW TABLES;
1840 Tables_in_test
1841 t4
1842 SHOW CREATE TABLE t4;
1843 Table Create Table
1844 t4 CREATE TABLE `t4` (
1845 `c1` decimal(10,0) unsigned NOT NULL
1846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
1847 DROP TABLE t4;
1848 SHOW TABLES;
1849 Tables_in_test