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 DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
19 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 DEFAULT NULL
31 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
40 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 DEFAULT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
61 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 DEFAULT NULL
73 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 DEFAULT NULL
115 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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 unsigned DEFAULT NULL
124 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_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_0900_ai_ci
137 ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NULL;
138 Warnings:
139 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
140 SHOW TABLES;
141 Tables_in_test
142 t3
143 SHOW CREATE TABLE t3;
144 Table Create Table
145 t3 CREATE TABLE `t3` (
146 `c1` double unsigned DEFAULT NULL
147 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
148 DROP TABLE t3;
149 SHOW TABLES;
150 Tables_in_test
151 CREATE TABLE t3(c1 DOUBLE NULL);
152 SHOW TABLES;
153 Tables_in_test
154 t3
155 SHOW CREATE TABLE t3;
156 Table Create Table
157 t3 CREATE TABLE `t3` (
158 `c1` double DEFAULT NULL
159 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
160 ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NULL;
161 Warnings:
162 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
163 SHOW TABLES;
164 Tables_in_test
165 t3
166 SHOW CREATE TABLE t3;
167 Table Create Table
168 t3 CREATE TABLE `t3` (
169 `c1` double unsigned DEFAULT NULL
170 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
171 DROP TABLE t3;
172 SHOW TABLES;
173 Tables_in_test
174 CREATE TABLE t3(c1 FLOAT NULL);
175 SHOW TABLES;
176 Tables_in_test
177 t3
178 SHOW CREATE TABLE t3;
179 Table Create Table
180 t3 CREATE TABLE `t3` (
181 `c1` float DEFAULT NULL
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NULL;
184 Warnings:
185 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
186 SHOW TABLES;
187 Tables_in_test
188 t3
189 SHOW CREATE TABLE t3;
190 Table Create Table
191 t3 CREATE TABLE `t3` (
192 `c1` float unsigned DEFAULT NULL
193 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
194 DROP TABLE t3;
195 SHOW TABLES;
196 Tables_in_test
197 CREATE TABLE t3(c1 DECIMAL NULL);
198 SHOW TABLES;
199 Tables_in_test
200 t3
201 SHOW CREATE TABLE t3;
202 Table Create Table
203 t3 CREATE TABLE `t3` (
204 `c1` decimal(10,0) DEFAULT NULL
205 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
206 ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NULL;
207 Warnings:
208 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
209 SHOW TABLES;
210 Tables_in_test
211 t3
212 SHOW CREATE TABLE t3;
213 Table Create Table
214 t3 CREATE TABLE `t3` (
215 `c1` decimal(10,0) unsigned DEFAULT NULL
216 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
217 DROP TABLE t3;
218 SHOW TABLES;
219 Tables_in_test
220 CREATE TABLE t3(c1 NUMERIC NULL);
221 SHOW TABLES;
222 Tables_in_test
223 t3
224 SHOW CREATE TABLE t3;
225 Table Create Table
226 t3 CREATE TABLE `t3` (
227 `c1` decimal(10,0) DEFAULT NULL
228 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
229 ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NULL;
230 Warnings:
231 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
232 SHOW TABLES;
233 Tables_in_test
234 t3
235 SHOW CREATE TABLE t3;
236 Table Create Table
237 t3 CREATE TABLE `t3` (
238 `c1` decimal(10,0) unsigned DEFAULT NULL
239 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
240 DROP TABLE t3;
241 SHOW TABLES;
242 Tables_in_test
243 CREATE TABLE t3(c1 TINYINT NULL);
244 SHOW TABLES;
245 Tables_in_test
246 t3
247 SHOW CREATE TABLE t3;
248 Table Create Table
249 t3 CREATE TABLE `t3` (
250 `c1` tinyint DEFAULT NULL
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NULL;
253 SHOW TABLES;
254 Tables_in_test
255 t3
256 SHOW CREATE TABLE t3;
257 Table Create Table
258 t3 CREATE TABLE `t3` (
259 `c1` tinyint unsigned DEFAULT NULL
260 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
261 DROP TABLE t3;
262 SHOW TABLES;
263 Tables_in_test
264 CREATE TABLE t3(c1 SMALLINT NULL);
265 SHOW TABLES;
266 Tables_in_test
267 t3
268 SHOW CREATE TABLE t3;
269 Table Create Table
270 t3 CREATE TABLE `t3` (
271 `c1` smallint DEFAULT NULL
272 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
273 ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NULL;
274 SHOW TABLES;
275 Tables_in_test
276 t3
277 SHOW CREATE TABLE t3;
278 Table Create Table
279 t3 CREATE TABLE `t3` (
280 `c1` smallint unsigned DEFAULT NULL
281 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
282 DROP TABLE t3;
283 SHOW TABLES;
284 Tables_in_test
285 CREATE TABLE t3(c1 MEDIUMINT NULL);
286 SHOW TABLES;
287 Tables_in_test
288 t3
289 SHOW CREATE TABLE t3;
290 Table Create Table
291 t3 CREATE TABLE `t3` (
292 `c1` mediumint DEFAULT NULL
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NULL;
295 SHOW TABLES;
296 Tables_in_test
297 t3
298 SHOW CREATE TABLE t3;
299 Table Create Table
300 t3 CREATE TABLE `t3` (
301 `c1` mediumint unsigned DEFAULT NULL
302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 DROP TABLE t3;
304 SHOW TABLES;
305 Tables_in_test
306 CREATE TABLE t3(c1 INT NULL);
307 SHOW TABLES;
308 Tables_in_test
309 t3
310 SHOW CREATE TABLE t3;
311 Table Create Table
312 t3 CREATE TABLE `t3` (
313 `c1` int DEFAULT NULL
314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
315 ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NULL;
316 SHOW TABLES;
317 Tables_in_test
318 t3
319 SHOW CREATE TABLE t3;
320 Table Create Table
321 t3 CREATE TABLE `t3` (
322 `c1` int unsigned DEFAULT NULL
323 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
324 DROP TABLE t3;
325 SHOW TABLES;
326 Tables_in_test
327 CREATE TABLE t3(c1 INTEGER NULL);
328 SHOW TABLES;
329 Tables_in_test
330 t3
331 SHOW CREATE TABLE t3;
332 Table Create Table
333 t3 CREATE TABLE `t3` (
334 `c1` int DEFAULT NULL
335 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
336 ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NULL;
337 SHOW TABLES;
338 Tables_in_test
339 t3
340 SHOW CREATE TABLE t3;
341 Table Create Table
342 t3 CREATE TABLE `t3` (
343 `c1` int unsigned DEFAULT NULL
344 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
345 DROP TABLE t3;
346 SHOW TABLES;
347 Tables_in_test
348 CREATE TABLE t3(c1 BIGINT NULL);
349 SHOW TABLES;
350 Tables_in_test
351 t3
352 SHOW CREATE TABLE t3;
353 Table Create Table
354 t3 CREATE TABLE `t3` (
355 `c1` bigint DEFAULT NULL
356 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
357 ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NULL;
358 SHOW TABLES;
359 Tables_in_test
360 t3
361 SHOW CREATE TABLE t3;
362 Table Create Table
363 t3 CREATE TABLE `t3` (
364 `c1` bigint unsigned DEFAULT NULL
365 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
366 DROP TABLE t3;
367 SHOW TABLES;
368 Tables_in_test
369 CREATE TABLE t3(c1 REAL NULL);
370 SHOW TABLES;
371 Tables_in_test
372 t3
373 SHOW CREATE TABLE t3;
374 Table Create Table
375 t3 CREATE TABLE `t3` (
376 `c1` double DEFAULT NULL
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NULL;
379 Warnings:
380 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
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 unsigned DEFAULT NULL
388 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
389 DROP TABLE t3;
390 SHOW TABLES;
391 Tables_in_test
392 CREATE TABLE t3(c1 DOUBLE NULL);
393 SHOW TABLES;
394 Tables_in_test
395 t3
396 SHOW CREATE TABLE t3;
397 Table Create Table
398 t3 CREATE TABLE `t3` (
399 `c1` double DEFAULT NULL
400 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
401 ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NULL;
402 Warnings:
403 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
404 SHOW TABLES;
405 Tables_in_test
406 t3
407 SHOW CREATE TABLE t3;
408 Table Create Table
409 t3 CREATE TABLE `t3` (
410 `c1` double unsigned DEFAULT NULL
411 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
412 DROP TABLE t3;
413 SHOW TABLES;
414 Tables_in_test
415 CREATE TABLE t3(c1 FLOAT NULL);
416 SHOW TABLES;
417 Tables_in_test
418 t3
419 SHOW CREATE TABLE t3;
420 Table Create Table
421 t3 CREATE TABLE `t3` (
422 `c1` float DEFAULT NULL
423 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
424 ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NULL;
425 Warnings:
426 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
427 SHOW TABLES;
428 Tables_in_test
429 t3
430 SHOW CREATE TABLE t3;
431 Table Create Table
432 t3 CREATE TABLE `t3` (
433 `c1` float unsigned DEFAULT NULL
434 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
435 DROP TABLE t3;
436 SHOW TABLES;
437 Tables_in_test
438 CREATE TABLE t3(c1 DECIMAL NULL);
439 SHOW TABLES;
440 Tables_in_test
441 t3
442 SHOW CREATE TABLE t3;
443 Table Create Table
444 t3 CREATE TABLE `t3` (
445 `c1` decimal(10,0) DEFAULT NULL
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NULL;
448 Warnings:
449 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
450 SHOW TABLES;
451 Tables_in_test
452 t3
453 SHOW CREATE TABLE t3;
454 Table Create Table
455 t3 CREATE TABLE `t3` (
456 `c1` decimal(10,0) unsigned DEFAULT NULL
457 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
458 DROP TABLE t3;
459 SHOW TABLES;
460 Tables_in_test
461 CREATE TABLE t3(c1 NUMERIC NULL);
462 SHOW TABLES;
463 Tables_in_test
464 t3
465 SHOW CREATE TABLE t3;
466 Table Create Table
467 t3 CREATE TABLE `t3` (
468 `c1` decimal(10,0) DEFAULT NULL
469 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
470 ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NULL;
471 Warnings:
472 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
473 SHOW TABLES;
474 Tables_in_test
475 t3
476 SHOW CREATE TABLE t3;
477 Table Create Table
478 t3 CREATE TABLE `t3` (
479 `c1` decimal(10,0) unsigned DEFAULT NULL
480 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
481 DROP TABLE t3;
482 SHOW TABLES;
483 Tables_in_test
484 CREATE TABLE t3(c1 TINYINT NOT NULL);
485 SHOW TABLES;
486 Tables_in_test
487 t3
488 SHOW CREATE TABLE t3;
489 Table Create Table
490 t3 CREATE TABLE `t3` (
491 `c1` tinyint NOT NULL
492 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
493 ALTER TABLE t3 MODIFY c1 TINYINT UNSIGNED NOT NULL;
494 SHOW TABLES;
495 Tables_in_test
496 t3
497 SHOW CREATE TABLE t3;
498 Table Create Table
499 t3 CREATE TABLE `t3` (
500 `c1` tinyint unsigned NOT NULL
501 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
502 DROP TABLE t3;
503 SHOW TABLES;
504 Tables_in_test
505 CREATE TABLE t3(c1 SMALLINT NOT NULL);
506 SHOW TABLES;
507 Tables_in_test
508 t3
509 SHOW CREATE TABLE t3;
510 Table Create Table
511 t3 CREATE TABLE `t3` (
512 `c1` smallint NOT NULL
513 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
514 ALTER TABLE t3 MODIFY c1 SMALLINT UNSIGNED NOT NULL;
515 SHOW TABLES;
516 Tables_in_test
517 t3
518 SHOW CREATE TABLE t3;
519 Table Create Table
520 t3 CREATE TABLE `t3` (
521 `c1` smallint unsigned NOT NULL
522 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
523 DROP TABLE t3;
524 SHOW TABLES;
525 Tables_in_test
526 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
527 SHOW TABLES;
528 Tables_in_test
529 t3
530 SHOW CREATE TABLE t3;
531 Table Create Table
532 t3 CREATE TABLE `t3` (
533 `c1` mediumint NOT NULL
534 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
535 ALTER TABLE t3 MODIFY c1 MEDIUMINT UNSIGNED NOT NULL;
536 SHOW TABLES;
537 Tables_in_test
538 t3
539 SHOW CREATE TABLE t3;
540 Table Create Table
541 t3 CREATE TABLE `t3` (
542 `c1` mediumint unsigned NOT NULL
543 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
544 DROP TABLE t3;
545 SHOW TABLES;
546 Tables_in_test
547 CREATE TABLE t3(c1 INT NOT NULL);
548 SHOW TABLES;
549 Tables_in_test
550 t3
551 SHOW CREATE TABLE t3;
552 Table Create Table
553 t3 CREATE TABLE `t3` (
554 `c1` int NOT NULL
555 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
556 ALTER TABLE t3 MODIFY c1 INT UNSIGNED NOT NULL;
557 SHOW TABLES;
558 Tables_in_test
559 t3
560 SHOW CREATE TABLE t3;
561 Table Create Table
562 t3 CREATE TABLE `t3` (
563 `c1` int unsigned NOT NULL
564 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
565 DROP TABLE t3;
566 SHOW TABLES;
567 Tables_in_test
568 CREATE TABLE t3(c1 INTEGER NOT NULL);
569 SHOW TABLES;
570 Tables_in_test
571 t3
572 SHOW CREATE TABLE t3;
573 Table Create Table
574 t3 CREATE TABLE `t3` (
575 `c1` int NOT NULL
576 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
577 ALTER TABLE t3 MODIFY c1 INTEGER UNSIGNED NOT NULL;
578 SHOW TABLES;
579 Tables_in_test
580 t3
581 SHOW CREATE TABLE t3;
582 Table Create Table
583 t3 CREATE TABLE `t3` (
584 `c1` int unsigned NOT NULL
585 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
586 DROP TABLE t3;
587 SHOW TABLES;
588 Tables_in_test
589 CREATE TABLE t3(c1 BIGINT NOT NULL);
590 SHOW TABLES;
591 Tables_in_test
592 t3
593 SHOW CREATE TABLE t3;
594 Table Create Table
595 t3 CREATE TABLE `t3` (
596 `c1` bigint NOT NULL
597 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
598 ALTER TABLE t3 MODIFY c1 BIGINT UNSIGNED NOT NULL;
599 SHOW TABLES;
600 Tables_in_test
601 t3
602 SHOW CREATE TABLE t3;
603 Table Create Table
604 t3 CREATE TABLE `t3` (
605 `c1` bigint unsigned NOT NULL
606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
607 DROP TABLE t3;
608 SHOW TABLES;
609 Tables_in_test
610 CREATE TABLE t3(c1 REAL NOT NULL);
611 SHOW TABLES;
612 Tables_in_test
613 t3
614 SHOW CREATE TABLE t3;
615 Table Create Table
616 t3 CREATE TABLE `t3` (
617 `c1` double NOT NULL
618 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
619 ALTER TABLE t3 MODIFY c1 REAL UNSIGNED NOT NULL;
620 Warnings:
621 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
622 SHOW TABLES;
623 Tables_in_test
624 t3
625 SHOW CREATE TABLE t3;
626 Table Create Table
627 t3 CREATE TABLE `t3` (
628 `c1` double unsigned NOT NULL
629 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
630 DROP TABLE t3;
631 SHOW TABLES;
632 Tables_in_test
633 CREATE TABLE t3(c1 DOUBLE NOT NULL);
634 SHOW TABLES;
635 Tables_in_test
636 t3
637 SHOW CREATE TABLE t3;
638 Table Create Table
639 t3 CREATE TABLE `t3` (
640 `c1` double NOT NULL
641 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
642 ALTER TABLE t3 MODIFY c1 DOUBLE UNSIGNED NOT NULL;
643 Warnings:
644 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
645 SHOW TABLES;
646 Tables_in_test
647 t3
648 SHOW CREATE TABLE t3;
649 Table Create Table
650 t3 CREATE TABLE `t3` (
651 `c1` double unsigned NOT NULL
652 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
653 DROP TABLE t3;
654 SHOW TABLES;
655 Tables_in_test
656 CREATE TABLE t3(c1 FLOAT NOT NULL);
657 SHOW TABLES;
658 Tables_in_test
659 t3
660 SHOW CREATE TABLE t3;
661 Table Create Table
662 t3 CREATE TABLE `t3` (
663 `c1` float NOT NULL
664 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
665 ALTER TABLE t3 MODIFY c1 FLOAT UNSIGNED NOT NULL;
666 Warnings:
667 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
668 SHOW TABLES;
669 Tables_in_test
670 t3
671 SHOW CREATE TABLE t3;
672 Table Create Table
673 t3 CREATE TABLE `t3` (
674 `c1` float unsigned NOT NULL
675 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
676 DROP TABLE t3;
677 SHOW TABLES;
678 Tables_in_test
679 CREATE TABLE t3(c1 DECIMAL NOT NULL);
680 SHOW TABLES;
681 Tables_in_test
682 t3
683 SHOW CREATE TABLE t3;
684 Table Create Table
685 t3 CREATE TABLE `t3` (
686 `c1` decimal(10,0) NOT NULL
687 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
688 ALTER TABLE t3 MODIFY c1 DECIMAL UNSIGNED NOT NULL;
689 Warnings:
690 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
691 SHOW TABLES;
692 Tables_in_test
693 t3
694 SHOW CREATE TABLE t3;
695 Table Create Table
696 t3 CREATE TABLE `t3` (
697 `c1` decimal(10,0) unsigned NOT NULL
698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
699 DROP TABLE t3;
700 SHOW TABLES;
701 Tables_in_test
702 CREATE TABLE t3(c1 NUMERIC NOT NULL);
703 SHOW TABLES;
704 Tables_in_test
705 t3
706 SHOW CREATE TABLE t3;
707 Table Create Table
708 t3 CREATE TABLE `t3` (
709 `c1` decimal(10,0) NOT NULL
710 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
711 ALTER TABLE t3 MODIFY c1 NUMERIC UNSIGNED NOT NULL;
712 Warnings:
713 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
714 SHOW TABLES;
715 Tables_in_test
716 t3
717 SHOW CREATE TABLE t3;
718 Table Create Table
719 t3 CREATE TABLE `t3` (
720 `c1` decimal(10,0) unsigned NOT NULL
721 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
722 DROP TABLE t3;
723 SHOW TABLES;
724 Tables_in_test
725 CREATE TABLE t3(c1 TINYINT 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` tinyint NOT NULL
733 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
734 ALTER TABLE t3 CHANGE c1 c1 TINYINT UNSIGNED NOT NULL;
735 SHOW TABLES;
736 Tables_in_test
737 t3
738 SHOW CREATE TABLE t3;
739 Table Create Table
740 t3 CREATE TABLE `t3` (
741 `c1` tinyint unsigned NOT NULL
742 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
743 DROP TABLE t3;
744 SHOW TABLES;
745 Tables_in_test
746 CREATE TABLE t3(c1 SMALLINT 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` smallint NOT NULL
754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
755 ALTER TABLE t3 CHANGE c1 c1 SMALLINT UNSIGNED NOT NULL;
756 SHOW TABLES;
757 Tables_in_test
758 t3
759 SHOW CREATE TABLE t3;
760 Table Create Table
761 t3 CREATE TABLE `t3` (
762 `c1` smallint unsigned NOT NULL
763 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
764 DROP TABLE t3;
765 SHOW TABLES;
766 Tables_in_test
767 CREATE TABLE t3(c1 MEDIUMINT 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` mediumint NOT NULL
775 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
776 ALTER TABLE t3 CHANGE c1 c1 MEDIUMINT UNSIGNED NOT NULL;
777 SHOW TABLES;
778 Tables_in_test
779 t3
780 SHOW CREATE TABLE t3;
781 Table Create Table
782 t3 CREATE TABLE `t3` (
783 `c1` mediumint unsigned NOT NULL
784 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
785 DROP TABLE t3;
786 SHOW TABLES;
787 Tables_in_test
788 CREATE TABLE t3(c1 INT 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 NOT NULL
796 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
797 ALTER TABLE t3 CHANGE c1 c1 INT UNSIGNED NOT NULL;
798 SHOW TABLES;
799 Tables_in_test
800 t3
801 SHOW CREATE TABLE t3;
802 Table Create Table
803 t3 CREATE TABLE `t3` (
804 `c1` int unsigned NOT NULL
805 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
806 DROP TABLE t3;
807 SHOW TABLES;
808 Tables_in_test
809 CREATE TABLE t3(c1 INTEGER 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` int NOT NULL
817 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
818 ALTER TABLE t3 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;
819 SHOW TABLES;
820 Tables_in_test
821 t3
822 SHOW CREATE TABLE t3;
823 Table Create Table
824 t3 CREATE TABLE `t3` (
825 `c1` int unsigned NOT NULL
826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
827 DROP TABLE t3;
828 SHOW TABLES;
829 Tables_in_test
830 CREATE TABLE t3(c1 BIGINT 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` bigint NOT NULL
838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
839 ALTER TABLE t3 CHANGE c1 c1 BIGINT UNSIGNED NOT NULL;
840 SHOW TABLES;
841 Tables_in_test
842 t3
843 SHOW CREATE TABLE t3;
844 Table Create Table
845 t3 CREATE TABLE `t3` (
846 `c1` bigint unsigned NOT NULL
847 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
848 DROP TABLE t3;
849 SHOW TABLES;
850 Tables_in_test
851 CREATE TABLE t3(c1 REAL 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 NOT NULL
859 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
860 ALTER TABLE t3 CHANGE c1 c1 REAL UNSIGNED NOT NULL;
861 Warnings:
862 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
863 SHOW TABLES;
864 Tables_in_test
865 t3
866 SHOW CREATE TABLE t3;
867 Table Create Table
868 t3 CREATE TABLE `t3` (
869 `c1` double unsigned NOT NULL
870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
871 DROP TABLE t3;
872 SHOW TABLES;
873 Tables_in_test
874 CREATE TABLE t3(c1 DOUBLE NOT NULL);
875 SHOW TABLES;
876 Tables_in_test
877 t3
878 SHOW CREATE TABLE t3;
879 Table Create Table
880 t3 CREATE TABLE `t3` (
881 `c1` double NOT NULL
882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
883 ALTER TABLE t3 CHANGE c1 c1 DOUBLE UNSIGNED NOT NULL;
884 Warnings:
885 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
886 SHOW TABLES;
887 Tables_in_test
888 t3
889 SHOW CREATE TABLE t3;
890 Table Create Table
891 t3 CREATE TABLE `t3` (
892 `c1` double unsigned NOT NULL
893 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
894 DROP TABLE t3;
895 SHOW TABLES;
896 Tables_in_test
897 CREATE TABLE t3(c1 FLOAT NOT NULL);
898 SHOW TABLES;
899 Tables_in_test
900 t3
901 SHOW CREATE TABLE t3;
902 Table Create Table
903 t3 CREATE TABLE `t3` (
904 `c1` float NOT NULL
905 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
906 ALTER TABLE t3 CHANGE c1 c1 FLOAT UNSIGNED NOT NULL;
907 Warnings:
908 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
909 SHOW TABLES;
910 Tables_in_test
911 t3
912 SHOW CREATE TABLE t3;
913 Table Create Table
914 t3 CREATE TABLE `t3` (
915 `c1` float unsigned NOT NULL
916 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
917 DROP TABLE t3;
918 SHOW TABLES;
919 Tables_in_test
920 CREATE TABLE t3(c1 DECIMAL NOT NULL);
921 SHOW TABLES;
922 Tables_in_test
923 t3
924 SHOW CREATE TABLE t3;
925 Table Create Table
926 t3 CREATE TABLE `t3` (
927 `c1` decimal(10,0) NOT NULL
928 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
929 ALTER TABLE t3 CHANGE c1 c1 DECIMAL UNSIGNED NOT NULL;
930 Warnings:
931 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
932 SHOW TABLES;
933 Tables_in_test
934 t3
935 SHOW CREATE TABLE t3;
936 Table Create Table
937 t3 CREATE TABLE `t3` (
938 `c1` decimal(10,0) unsigned NOT NULL
939 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
940 DROP TABLE t3;
941 SHOW TABLES;
942 Tables_in_test
943 CREATE TABLE t3(c1 NUMERIC NOT NULL);
944 SHOW TABLES;
945 Tables_in_test
946 t3
947 SHOW CREATE TABLE t3;
948 Table Create Table
949 t3 CREATE TABLE `t3` (
950 `c1` decimal(10,0) NOT NULL
951 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
952 ALTER TABLE t3 CHANGE c1 c1 NUMERIC UNSIGNED NOT NULL;
953 Warnings:
954 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
955 SHOW TABLES;
956 Tables_in_test
957 t3
958 SHOW CREATE TABLE t3;
959 Table Create Table
960 t3 CREATE TABLE `t3` (
961 `c1` decimal(10,0) unsigned NOT NULL
962 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
963 DROP TABLE t3;
964 SHOW TABLES;
965 Tables_in_test