Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t11;
2 CREATE TABLE t11(c1 TINYINT(5) NULL DEFAULT 1);
3 SHOW TABLES;
4 Tables_in_test
5 t11
6 SHOW CREATE TABLE t11;
7 Table Create Table
8 t11 CREATE TABLE `t11` (
9 `c1` tinyint(5) DEFAULT 1
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
11 DROP TABLE t11;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t11(c1 SMALLINT(5) NULL DEFAULT 1);
15 SHOW TABLES;
16 Tables_in_test
17 t11
18 SHOW CREATE TABLE t11;
19 Table Create Table
20 t11 CREATE TABLE `t11` (
21 `c1` smallint(5) DEFAULT 1
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
23 DROP TABLE t11;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t11(c1 MEDIUMINT(5) NULL DEFAULT 1);
27 SHOW TABLES;
28 Tables_in_test
29 t11
30 SHOW CREATE TABLE t11;
31 Table Create Table
32 t11 CREATE TABLE `t11` (
33 `c1` mediumint(5) DEFAULT 1
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
35 DROP TABLE t11;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t11(c1 INT(5) NULL DEFAULT 1);
39 SHOW TABLES;
40 Tables_in_test
41 t11
42 SHOW CREATE TABLE t11;
43 Table Create Table
44 t11 CREATE TABLE `t11` (
45 `c1` int(5) DEFAULT 1
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
47 DROP TABLE t11;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t11(c1 INTEGER(5) NULL DEFAULT 1);
51 SHOW TABLES;
52 Tables_in_test
53 t11
54 SHOW CREATE TABLE t11;
55 Table Create Table
56 t11 CREATE TABLE `t11` (
57 `c1` int(5) DEFAULT 1
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
59 DROP TABLE t11;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t11(c1 BIGINT(5) NULL DEFAULT 1);
63 SHOW TABLES;
64 Tables_in_test
65 t11
66 SHOW CREATE TABLE t11;
67 Table Create Table
68 t11 CREATE TABLE `t11` (
69 `c1` bigint(5) DEFAULT 1
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
71 DROP TABLE t11;
72 SHOW TABLES;
73 Tables_in_test
74 CREATE TABLE t11(c1 TINYINT(5) NOT NULL DEFAULT 1);
75 SHOW TABLES;
76 Tables_in_test
77 t11
78 SHOW CREATE TABLE t11;
79 Table Create Table
80 t11 CREATE TABLE `t11` (
81 `c1` tinyint(5) NOT NULL DEFAULT 1
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
83 DROP TABLE t11;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t11(c1 SMALLINT(5) NOT NULL DEFAULT 1);
87 SHOW TABLES;
88 Tables_in_test
89 t11
90 SHOW CREATE TABLE t11;
91 Table Create Table
92 t11 CREATE TABLE `t11` (
93 `c1` smallint(5) NOT NULL DEFAULT 1
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
95 DROP TABLE t11;
96 SHOW TABLES;
97 Tables_in_test
98 CREATE TABLE t11(c1 MEDIUMINT(5) NOT NULL DEFAULT 1);
99 SHOW TABLES;
100 Tables_in_test
101 t11
102 SHOW CREATE TABLE t11;
103 Table Create Table
104 t11 CREATE TABLE `t11` (
105 `c1` mediumint(5) NOT NULL DEFAULT 1
106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
107 DROP TABLE t11;
108 SHOW TABLES;
109 Tables_in_test
110 CREATE TABLE t11(c1 INT(5) NOT NULL DEFAULT 1);
111 SHOW TABLES;
112 Tables_in_test
113 t11
114 SHOW CREATE TABLE t11;
115 Table Create Table
116 t11 CREATE TABLE `t11` (
117 `c1` int(5) NOT NULL DEFAULT 1
118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
119 DROP TABLE t11;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t11(c1 INTEGER(5) NOT NULL DEFAULT 1);
123 SHOW TABLES;
124 Tables_in_test
125 t11
126 SHOW CREATE TABLE t11;
127 Table Create Table
128 t11 CREATE TABLE `t11` (
129 `c1` int(5) NOT NULL DEFAULT 1
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
131 DROP TABLE t11;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t11(c1 BIGINT(5) NOT NULL DEFAULT 1);
135 SHOW TABLES;
136 Tables_in_test
137 t11
138 SHOW CREATE TABLE t11;
139 Table Create Table
140 t11 CREATE TABLE `t11` (
141 `c1` bigint(5) NOT NULL DEFAULT 1
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
143 DROP TABLE t11;
144 SHOW TABLES;
145 Tables_in_test