Debian Codegraph @

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

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