Debian Codegraph @

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

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