Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t3;
2 CREATE TABLE t3(c1 TINYINT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t3
6 SHOW CREATE TABLE t3;
7 Table Create Table
8 t3 CREATE TABLE `t3` (
9 `c1` tinyint(4) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
11 ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NULL;
12 SHOW TABLES;
13 Tables_in_test
14 t3
15 SHOW CREATE TABLE t3;
16 Table Create Table
17 t3 CREATE TABLE `t3` (
18 `c1` tinyint(3) unsigned DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 DROP TABLE t3;
21 SHOW TABLES;
22 Tables_in_test
23 CREATE TABLE t3(c1 SMALLINT NULL);
24 SHOW TABLES;
25 Tables_in_test
26 t3
27 SHOW CREATE TABLE t3;
28 Table Create Table
29 t3 CREATE TABLE `t3` (
30 `c1` smallint(6) DEFAULT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
32 ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NULL;
33 SHOW TABLES;
34 Tables_in_test
35 t3
36 SHOW CREATE TABLE t3;
37 Table Create Table
38 t3 CREATE TABLE `t3` (
39 `c1` smallint(5) unsigned DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
41 DROP TABLE t3;
42 SHOW TABLES;
43 Tables_in_test
44 CREATE TABLE t3(c1 MEDIUMINT NULL);
45 SHOW TABLES;
46 Tables_in_test
47 t3
48 SHOW CREATE TABLE t3;
49 Table Create Table
50 t3 CREATE TABLE `t3` (
51 `c1` mediumint(9) DEFAULT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
53 ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NULL;
54 SHOW TABLES;
55 Tables_in_test
56 t3
57 SHOW CREATE TABLE t3;
58 Table Create Table
59 t3 CREATE TABLE `t3` (
60 `c1` mediumint(8) unsigned DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
62 DROP TABLE t3;
63 SHOW TABLES;
64 Tables_in_test
65 CREATE TABLE t3(c1 INT NULL);
66 SHOW TABLES;
67 Tables_in_test
68 t3
69 SHOW CREATE TABLE t3;
70 Table Create Table
71 t3 CREATE TABLE `t3` (
72 `c1` int(11) DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
74 ALTER TABLE t3 MODIFY c1 INT UNSIGNED NULL;
75 SHOW TABLES;
76 Tables_in_test
77 t3
78 SHOW CREATE TABLE t3;
79 Table Create Table
80 t3 CREATE TABLE `t3` (
81 `c1` int(10) unsigned DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
83 DROP TABLE t3;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t3(c1 INTEGER NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t3
90 SHOW CREATE TABLE t3;
91 Table Create Table
92 t3 CREATE TABLE `t3` (
93 `c1` int(11) DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NULL;
96 SHOW TABLES;
97 Tables_in_test
98 t3
99 SHOW CREATE TABLE t3;
100 Table Create Table
101 t3 CREATE TABLE `t3` (
102 `c1` int(10) unsigned DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
104 DROP TABLE t3;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t3(c1 BIGINT NULL);
108 SHOW TABLES;
109 Tables_in_test
110 t3
111 SHOW CREATE TABLE t3;
112 Table Create Table
113 t3 CREATE TABLE `t3` (
114 `c1` bigint(20) DEFAULT NULL
115 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
116 ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NULL;
117 SHOW TABLES;
118 Tables_in_test
119 t3
120 SHOW CREATE TABLE t3;
121 Table Create Table
122 t3 CREATE TABLE `t3` (
123 `c1` bigint(20) unsigned DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
125 DROP TABLE t3;
126 SHOW TABLES;
127 Tables_in_test
128 CREATE TABLE t3(c1 REAL NULL);
129 SHOW TABLES;
130 Tables_in_test
131 t3
132 SHOW CREATE TABLE t3;
133 Table Create Table
134 t3 CREATE TABLE `t3` (
135 `c1` double DEFAULT NULL
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
137 ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NULL;
138 SHOW TABLES;
139 Tables_in_test
140 t3
141 SHOW CREATE TABLE t3;
142 Table Create Table
143 t3 CREATE TABLE `t3` (
144 `c1` double unsigned DEFAULT NULL
145 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
146 DROP TABLE t3;
147 SHOW TABLES;
148 Tables_in_test
149 CREATE TABLE t3(c1 DOUBLE NULL);
150 SHOW TABLES;
151 Tables_in_test
152 t3
153 SHOW CREATE TABLE t3;
154 Table Create Table
155 t3 CREATE TABLE `t3` (
156 `c1` double DEFAULT NULL
157 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
158 ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NULL;
159 SHOW TABLES;
160 Tables_in_test
161 t3
162 SHOW CREATE TABLE t3;
163 Table Create Table
164 t3 CREATE TABLE `t3` (
165 `c1` double unsigned DEFAULT NULL
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
167 DROP TABLE t3;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t3(c1 FLOAT NULL);
171 SHOW TABLES;
172 Tables_in_test
173 t3
174 SHOW CREATE TABLE t3;
175 Table Create Table
176 t3 CREATE TABLE `t3` (
177 `c1` float DEFAULT NULL
178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
179 ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NULL;
180 SHOW TABLES;
181 Tables_in_test
182 t3
183 SHOW CREATE TABLE t3;
184 Table Create Table
185 t3 CREATE TABLE `t3` (
186 `c1` float unsigned DEFAULT NULL
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
188 DROP TABLE t3;
189 SHOW TABLES;
190 Tables_in_test
191 CREATE TABLE t3(c1 DECIMAL NULL);
192 SHOW TABLES;
193 Tables_in_test
194 t3
195 SHOW CREATE TABLE t3;
196 Table Create Table
197 t3 CREATE TABLE `t3` (
198 `c1` decimal(10,0) DEFAULT NULL
199 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
200 ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NULL;
201 SHOW TABLES;
202 Tables_in_test
203 t3
204 SHOW CREATE TABLE t3;
205 Table Create Table
206 t3 CREATE TABLE `t3` (
207 `c1` decimal(10,0) unsigned DEFAULT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
209 DROP TABLE t3;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t3(c1 NUMERIC NULL);
213 SHOW TABLES;
214 Tables_in_test
215 t3
216 SHOW CREATE TABLE t3;
217 Table Create Table
218 t3 CREATE TABLE `t3` (
219 `c1` decimal(10,0) DEFAULT NULL
220 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
221 ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NULL;
222 SHOW TABLES;
223 Tables_in_test
224 t3
225 SHOW CREATE TABLE t3;
226 Table Create Table
227 t3 CREATE TABLE `t3` (
228 `c1` decimal(10,0) unsigned DEFAULT NULL
229 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
230 DROP TABLE t3;
231 SHOW TABLES;
232 Tables_in_test
233 CREATE TABLE t3(c1 TINYINT NULL);
234 SHOW TABLES;
235 Tables_in_test
236 t3
237 SHOW CREATE TABLE t3;
238 Table Create Table
239 t3 CREATE TABLE `t3` (
240 `c1` tinyint(4) DEFAULT NULL
241 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
242 ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NULL;
243 SHOW TABLES;
244 Tables_in_test
245 t3
246 SHOW CREATE TABLE t3;
247 Table Create Table
248 t3 CREATE TABLE `t3` (
249 `c1` tinyint(3) unsigned DEFAULT NULL
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
251 DROP TABLE t3;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t3(c1 SMALLINT NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t3
258 SHOW CREATE TABLE t3;
259 Table Create Table
260 t3 CREATE TABLE `t3` (
261 `c1` smallint(6) DEFAULT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
263 ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
264 SHOW TABLES;
265 Tables_in_test
266 t3
267 SHOW CREATE TABLE t3;
268 Table Create Table
269 t3 CREATE TABLE `t3` (
270 `c1` smallint(5) unsigned DEFAULT NULL
271 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
272 DROP TABLE t3;
273 SHOW TABLES;
274 Tables_in_test
275 CREATE TABLE t3(c1 MEDIUMINT NULL);
276 SHOW TABLES;
277 Tables_in_test
278 t3
279 SHOW CREATE TABLE t3;
280 Table Create Table
281 t3 CREATE TABLE `t3` (
282 `c1` mediumint(9) DEFAULT NULL
283 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
284 ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
285 SHOW TABLES;
286 Tables_in_test
287 t3
288 SHOW CREATE TABLE t3;
289 Table Create Table
290 t3 CREATE TABLE `t3` (
291 `c1` mediumint(8) unsigned DEFAULT NULL
292 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
293 DROP TABLE t3;
294 SHOW TABLES;
295 Tables_in_test
296 CREATE TABLE t3(c1 INT NULL);
297 SHOW TABLES;
298 Tables_in_test
299 t3
300 SHOW CREATE TABLE t3;
301 Table Create Table
302 t3 CREATE TABLE `t3` (
303 `c1` int(11) DEFAULT NULL
304 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
305 ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NULL;
306 SHOW TABLES;
307 Tables_in_test
308 t3
309 SHOW CREATE TABLE t3;
310 Table Create Table
311 t3 CREATE TABLE `t3` (
312 `c1` int(10) unsigned DEFAULT NULL
313 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
314 DROP TABLE t3;
315 SHOW TABLES;
316 Tables_in_test
317 CREATE TABLE t3(c1 INTEGER NULL);
318 SHOW TABLES;
319 Tables_in_test
320 t3
321 SHOW CREATE TABLE t3;
322 Table Create Table
323 t3 CREATE TABLE `t3` (
324 `c1` int(11) DEFAULT NULL
325 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
326 ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NULL;
327 SHOW TABLES;
328 Tables_in_test
329 t3
330 SHOW CREATE TABLE t3;
331 Table Create Table
332 t3 CREATE TABLE `t3` (
333 `c1` int(10) unsigned DEFAULT NULL
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
335 DROP TABLE t3;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t3(c1 BIGINT NULL);
339 SHOW TABLES;
340 Tables_in_test
341 t3
342 SHOW CREATE TABLE t3;
343 Table Create Table
344 t3 CREATE TABLE `t3` (
345 `c1` bigint(20) DEFAULT NULL
346 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
347 ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NULL;
348 SHOW TABLES;
349 Tables_in_test
350 t3
351 SHOW CREATE TABLE t3;
352 Table Create Table
353 t3 CREATE TABLE `t3` (
354 `c1` bigint(20) unsigned DEFAULT NULL
355 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
356 DROP TABLE t3;
357 SHOW TABLES;
358 Tables_in_test
359 CREATE TABLE t3(c1 REAL NULL);
360 SHOW TABLES;
361 Tables_in_test
362 t3
363 SHOW CREATE TABLE t3;
364 Table Create Table
365 t3 CREATE TABLE `t3` (
366 `c1` double DEFAULT NULL
367 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
368 ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NULL;
369 SHOW TABLES;
370 Tables_in_test
371 t3
372 SHOW CREATE TABLE t3;
373 Table Create Table
374 t3 CREATE TABLE `t3` (
375 `c1` double unsigned DEFAULT NULL
376 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
377 DROP TABLE t3;
378 SHOW TABLES;
379 Tables_in_test
380 CREATE TABLE t3(c1 DOUBLE NULL);
381 SHOW TABLES;
382 Tables_in_test
383 t3
384 SHOW CREATE TABLE t3;
385 Table Create Table
386 t3 CREATE TABLE `t3` (
387 `c1` double DEFAULT NULL
388 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
389 ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
390 SHOW TABLES;
391 Tables_in_test
392 t3
393 SHOW CREATE TABLE t3;
394 Table Create Table
395 t3 CREATE TABLE `t3` (
396 `c1` double unsigned DEFAULT NULL
397 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
398 DROP TABLE t3;
399 SHOW TABLES;
400 Tables_in_test
401 CREATE TABLE t3(c1 FLOAT NULL);
402 SHOW TABLES;
403 Tables_in_test
404 t3
405 SHOW CREATE TABLE t3;
406 Table Create Table
407 t3 CREATE TABLE `t3` (
408 `c1` float DEFAULT NULL
409 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
410 ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NULL;
411 SHOW TABLES;
412 Tables_in_test
413 t3
414 SHOW CREATE TABLE t3;
415 Table Create Table
416 t3 CREATE TABLE `t3` (
417 `c1` float unsigned DEFAULT NULL
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
419 DROP TABLE t3;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t3(c1 DECIMAL NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t3
426 SHOW CREATE TABLE t3;
427 Table Create Table
428 t3 CREATE TABLE `t3` (
429 `c1` decimal(10,0) DEFAULT NULL
430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
431 ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
432 SHOW TABLES;
433 Tables_in_test
434 t3
435 SHOW CREATE TABLE t3;
436 Table Create Table
437 t3 CREATE TABLE `t3` (
438 `c1` decimal(10,0) unsigned DEFAULT NULL
439 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
440 DROP TABLE t3;
441 SHOW TABLES;
442 Tables_in_test
443 CREATE TABLE t3(c1 NUMERIC NULL);
444 SHOW TABLES;
445 Tables_in_test
446 t3
447 SHOW CREATE TABLE t3;
448 Table Create Table
449 t3 CREATE TABLE `t3` (
450 `c1` decimal(10,0) DEFAULT NULL
451 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
452 ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
453 SHOW TABLES;
454 Tables_in_test
455 t3
456 SHOW CREATE TABLE t3;
457 Table Create Table
458 t3 CREATE TABLE `t3` (
459 `c1` decimal(10,0) unsigned DEFAULT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
461 DROP TABLE t3;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t3(c1 TINYINT NOT NULL);
465 SHOW TABLES;
466 Tables_in_test
467 t3
468 SHOW CREATE TABLE t3;
469 Table Create Table
470 t3 CREATE TABLE `t3` (
471 `c1` tinyint(4) NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
473 ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NOT NULL;
474 SHOW TABLES;
475 Tables_in_test
476 t3
477 SHOW CREATE TABLE t3;
478 Table Create Table
479 t3 CREATE TABLE `t3` (
480 `c1` tinyint(3) unsigned NOT NULL
481 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
482 DROP TABLE t3;
483 SHOW TABLES;
484 Tables_in_test
485 CREATE TABLE t3(c1 SMALLINT NOT NULL);
486 SHOW TABLES;
487 Tables_in_test
488 t3
489 SHOW CREATE TABLE t3;
490 Table Create Table
491 t3 CREATE TABLE `t3` (
492 `c1` smallint(6) NOT NULL
493 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
494 ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
495 SHOW TABLES;
496 Tables_in_test
497 t3
498 SHOW CREATE TABLE t3;
499 Table Create Table
500 t3 CREATE TABLE `t3` (
501 `c1` smallint(5) unsigned NOT NULL
502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
503 DROP TABLE t3;
504 SHOW TABLES;
505 Tables_in_test
506 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
507 SHOW TABLES;
508 Tables_in_test
509 t3
510 SHOW CREATE TABLE t3;
511 Table Create Table
512 t3 CREATE TABLE `t3` (
513 `c1` mediumint(9) NOT NULL
514 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
515 ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
516 SHOW TABLES;
517 Tables_in_test
518 t3
519 SHOW CREATE TABLE t3;
520 Table Create Table
521 t3 CREATE TABLE `t3` (
522 `c1` mediumint(8) unsigned NOT NULL
523 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
524 DROP TABLE t3;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t3(c1 INT NOT NULL);
528 SHOW TABLES;
529 Tables_in_test
530 t3
531 SHOW CREATE TABLE t3;
532 Table Create Table
533 t3 CREATE TABLE `t3` (
534 `c1` int(11) NOT NULL
535 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
536 ALTER TABLE t3 MODIFY c1 INT UNSIGNED NOT NULL;
537 SHOW TABLES;
538 Tables_in_test
539 t3
540 SHOW CREATE TABLE t3;
541 Table Create Table
542 t3 CREATE TABLE `t3` (
543 `c1` int(10) unsigned NOT NULL
544 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
545 DROP TABLE t3;
546 SHOW TABLES;
547 Tables_in_test
548 CREATE TABLE t3(c1 INTEGER NOT NULL);
549 SHOW TABLES;
550 Tables_in_test
551 t3
552 SHOW CREATE TABLE t3;
553 Table Create Table
554 t3 CREATE TABLE `t3` (
555 `c1` int(11) NOT NULL
556 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
557 ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NOT NULL;
558 SHOW TABLES;
559 Tables_in_test
560 t3
561 SHOW CREATE TABLE t3;
562 Table Create Table
563 t3 CREATE TABLE `t3` (
564 `c1` int(10) unsigned NOT NULL
565 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
566 DROP TABLE t3;
567 SHOW TABLES;
568 Tables_in_test
569 CREATE TABLE t3(c1 BIGINT NOT NULL);
570 SHOW TABLES;
571 Tables_in_test
572 t3
573 SHOW CREATE TABLE t3;
574 Table Create Table
575 t3 CREATE TABLE `t3` (
576 `c1` bigint(20) NOT NULL
577 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
578 ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NOT NULL;
579 SHOW TABLES;
580 Tables_in_test
581 t3
582 SHOW CREATE TABLE t3;
583 Table Create Table
584 t3 CREATE TABLE `t3` (
585 `c1` bigint(20) unsigned NOT NULL
586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
587 DROP TABLE t3;
588 SHOW TABLES;
589 Tables_in_test
590 CREATE TABLE t3(c1 REAL NOT NULL);
591 SHOW TABLES;
592 Tables_in_test
593 t3
594 SHOW CREATE TABLE t3;
595 Table Create Table
596 t3 CREATE TABLE `t3` (
597 `c1` double NOT NULL
598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
599 ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NOT NULL;
600 SHOW TABLES;
601 Tables_in_test
602 t3
603 SHOW CREATE TABLE t3;
604 Table Create Table
605 t3 CREATE TABLE `t3` (
606 `c1` double unsigned NOT NULL
607 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
608 DROP TABLE t3;
609 SHOW TABLES;
610 Tables_in_test
611 CREATE TABLE t3(c1 DOUBLE NOT NULL);
612 SHOW TABLES;
613 Tables_in_test
614 t3
615 SHOW CREATE TABLE t3;
616 Table Create Table
617 t3 CREATE TABLE `t3` (
618 `c1` double NOT NULL
619 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
620 ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
621 SHOW TABLES;
622 Tables_in_test
623 t3
624 SHOW CREATE TABLE t3;
625 Table Create Table
626 t3 CREATE TABLE `t3` (
627 `c1` double unsigned NOT NULL
628 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
629 DROP TABLE t3;
630 SHOW TABLES;
631 Tables_in_test
632 CREATE TABLE t3(c1 FLOAT NOT NULL);
633 SHOW TABLES;
634 Tables_in_test
635 t3
636 SHOW CREATE TABLE t3;
637 Table Create Table
638 t3 CREATE TABLE `t3` (
639 `c1` float NOT NULL
640 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
641 ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NOT NULL;
642 SHOW TABLES;
643 Tables_in_test
644 t3
645 SHOW CREATE TABLE t3;
646 Table Create Table
647 t3 CREATE TABLE `t3` (
648 `c1` float unsigned NOT NULL
649 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
650 DROP TABLE t3;
651 SHOW TABLES;
652 Tables_in_test
653 CREATE TABLE t3(c1 DECIMAL NOT NULL);
654 SHOW TABLES;
655 Tables_in_test
656 t3
657 SHOW CREATE TABLE t3;
658 Table Create Table
659 t3 CREATE TABLE `t3` (
660 `c1` decimal(10,0) NOT NULL
661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
662 ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
663 SHOW TABLES;
664 Tables_in_test
665 t3
666 SHOW CREATE TABLE t3;
667 Table Create Table
668 t3 CREATE TABLE `t3` (
669 `c1` decimal(10,0) unsigned NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
671 DROP TABLE t3;
672 SHOW TABLES;
673 Tables_in_test
674 CREATE TABLE t3(c1 NUMERIC NOT NULL);
675 SHOW TABLES;
676 Tables_in_test
677 t3
678 SHOW CREATE TABLE t3;
679 Table Create Table
680 t3 CREATE TABLE `t3` (
681 `c1` decimal(10,0) NOT NULL
682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
683 ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
684 SHOW TABLES;
685 Tables_in_test
686 t3
687 SHOW CREATE TABLE t3;
688 Table Create Table
689 t3 CREATE TABLE `t3` (
690 `c1` decimal(10,0) unsigned NOT NULL
691 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
692 DROP TABLE t3;
693 SHOW TABLES;
694 Tables_in_test
695 CREATE TABLE t3(c1 TINYINT NOT NULL);
696 SHOW TABLES;
697 Tables_in_test
698 t3
699 SHOW CREATE TABLE t3;
700 Table Create Table
701 t3 CREATE TABLE `t3` (
702 `c1` tinyint(4) NOT NULL
703 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
704 ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
705 SHOW TABLES;
706 Tables_in_test
707 t3
708 SHOW CREATE TABLE t3;
709 Table Create Table
710 t3 CREATE TABLE `t3` (
711 `c1` tinyint(3) unsigned NOT NULL
712 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
713 DROP TABLE t3;
714 SHOW TABLES;
715 Tables_in_test
716 CREATE TABLE t3(c1 SMALLINT NOT NULL);
717 SHOW TABLES;
718 Tables_in_test
719 t3
720 SHOW CREATE TABLE t3;
721 Table Create Table
722 t3 CREATE TABLE `t3` (
723 `c1` smallint(6) NOT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
725 ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
726 SHOW TABLES;
727 Tables_in_test
728 t3
729 SHOW CREATE TABLE t3;
730 Table Create Table
731 t3 CREATE TABLE `t3` (
732 `c1` smallint(5) unsigned NOT NULL
733 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
734 DROP TABLE t3;
735 SHOW TABLES;
736 Tables_in_test
737 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
738 SHOW TABLES;
739 Tables_in_test
740 t3
741 SHOW CREATE TABLE t3;
742 Table Create Table
743 t3 CREATE TABLE `t3` (
744 `c1` mediumint(9) NOT NULL
745 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
746 ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
747 SHOW TABLES;
748 Tables_in_test
749 t3
750 SHOW CREATE TABLE t3;
751 Table Create Table
752 t3 CREATE TABLE `t3` (
753 `c1` mediumint(8) unsigned NOT NULL
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
755 DROP TABLE t3;
756 SHOW TABLES;
757 Tables_in_test
758 CREATE TABLE t3(c1 INT NOT NULL);
759 SHOW TABLES;
760 Tables_in_test
761 t3
762 SHOW CREATE TABLE t3;
763 Table Create Table
764 t3 CREATE TABLE `t3` (
765 `c1` int(11) NOT NULL
766 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
767 ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NOT NULL;
768 SHOW TABLES;
769 Tables_in_test
770 t3
771 SHOW CREATE TABLE t3;
772 Table Create Table
773 t3 CREATE TABLE `t3` (
774 `c1` int(10) unsigned NOT NULL
775 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
776 DROP TABLE t3;
777 SHOW TABLES;
778 Tables_in_test
779 CREATE TABLE t3(c1 INTEGER NOT NULL);
780 SHOW TABLES;
781 Tables_in_test
782 t3
783 SHOW CREATE TABLE t3;
784 Table Create Table
785 t3 CREATE TABLE `t3` (
786 `c1` int(11) NOT NULL
787 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
788 ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
789 SHOW TABLES;
790 Tables_in_test
791 t3
792 SHOW CREATE TABLE t3;
793 Table Create Table
794 t3 CREATE TABLE `t3` (
795 `c1` int(10) unsigned NOT NULL
796 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
797 DROP TABLE t3;
798 SHOW TABLES;
799 Tables_in_test
800 CREATE TABLE t3(c1 BIGINT NOT NULL);
801 SHOW TABLES;
802 Tables_in_test
803 t3
804 SHOW CREATE TABLE t3;
805 Table Create Table
806 t3 CREATE TABLE `t3` (
807 `c1` bigint(20) NOT NULL
808 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
809 ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
810 SHOW TABLES;
811 Tables_in_test
812 t3
813 SHOW CREATE TABLE t3;
814 Table Create Table
815 t3 CREATE TABLE `t3` (
816 `c1` bigint(20) unsigned NOT NULL
817 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
818 DROP TABLE t3;
819 SHOW TABLES;
820 Tables_in_test
821 CREATE TABLE t3(c1 REAL NOT NULL);
822 SHOW TABLES;
823 Tables_in_test
824 t3
825 SHOW CREATE TABLE t3;
826 Table Create Table
827 t3 CREATE TABLE `t3` (
828 `c1` double NOT NULL
829 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
830 ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
831 SHOW TABLES;
832 Tables_in_test
833 t3
834 SHOW CREATE TABLE t3;
835 Table Create Table
836 t3 CREATE TABLE `t3` (
837 `c1` double unsigned NOT NULL
838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
839 DROP TABLE t3;
840 SHOW TABLES;
841 Tables_in_test
842 CREATE TABLE t3(c1 DOUBLE NOT NULL);
843 SHOW TABLES;
844 Tables_in_test
845 t3
846 SHOW CREATE TABLE t3;
847 Table Create Table
848 t3 CREATE TABLE `t3` (
849 `c1` double NOT NULL
850 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
851 ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
852 SHOW TABLES;
853 Tables_in_test
854 t3
855 SHOW CREATE TABLE t3;
856 Table Create Table
857 t3 CREATE TABLE `t3` (
858 `c1` double unsigned NOT NULL
859 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
860 DROP TABLE t3;
861 SHOW TABLES;
862 Tables_in_test
863 CREATE TABLE t3(c1 FLOAT NOT NULL);
864 SHOW TABLES;
865 Tables_in_test
866 t3
867 SHOW CREATE TABLE t3;
868 Table Create Table
869 t3 CREATE TABLE `t3` (
870 `c1` float NOT NULL
871 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
872 ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
873 SHOW TABLES;
874 Tables_in_test
875 t3
876 SHOW CREATE TABLE t3;
877 Table Create Table
878 t3 CREATE TABLE `t3` (
879 `c1` float unsigned NOT NULL
880 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
881 DROP TABLE t3;
882 SHOW TABLES;
883 Tables_in_test
884 CREATE TABLE t3(c1 DECIMAL NOT NULL);
885 SHOW TABLES;
886 Tables_in_test
887 t3
888 SHOW CREATE TABLE t3;
889 Table Create Table
890 t3 CREATE TABLE `t3` (
891 `c1` decimal(10,0) NOT NULL
892 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
893 ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
894 SHOW TABLES;
895 Tables_in_test
896 t3
897 SHOW CREATE TABLE t3;
898 Table Create Table
899 t3 CREATE TABLE `t3` (
900 `c1` decimal(10,0) unsigned NOT NULL
901 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
902 DROP TABLE t3;
903 SHOW TABLES;
904 Tables_in_test
905 CREATE TABLE t3(c1 NUMERIC NOT NULL);
906 SHOW TABLES;
907 Tables_in_test
908 t3
909 SHOW CREATE TABLE t3;
910 Table Create Table
911 t3 CREATE TABLE `t3` (
912 `c1` decimal(10,0) NOT NULL
913 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
914 ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
915 SHOW TABLES;
916 Tables_in_test
917 t3
918 SHOW CREATE TABLE t3;
919 Table Create Table
920 t3 CREATE TABLE `t3` (
921 `c1` decimal(10,0) unsigned NOT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
923 DROP TABLE t3;
924 SHOW TABLES;
925 Tables_in_test