Debian Codegraph @

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

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