Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t5;
2 CREATE TABLE t5(c1 BIT(1) NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t5
6 SHOW CREATE TABLE t5;
7 Table Create Table
8 t5 CREATE TABLE `t5` (
9 `c1` bit(1) DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 DROP TABLE t5;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t5(c1 TINYINT(1) NULL);
15 Warnings:
16 Warning 1681 Integer display width is deprecated and will be removed in a future release.
17 SHOW TABLES;
18 Tables_in_test
19 t5
20 SHOW CREATE TABLE t5;
21 Table Create Table
22 t5 CREATE TABLE `t5` (
23 `c1` tinyint(1) DEFAULT NULL
24 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 DROP TABLE t5;
26 SHOW TABLES;
27 Tables_in_test
28 CREATE TABLE t5(c1 SMALLINT(1) NULL);
29 Warnings:
30 Warning 1681 Integer display width is deprecated and will be removed in a future release.
31 SHOW TABLES;
32 Tables_in_test
33 t5
34 SHOW CREATE TABLE t5;
35 Table Create Table
36 t5 CREATE TABLE `t5` (
37 `c1` smallint DEFAULT NULL
38 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 DROP TABLE t5;
40 SHOW TABLES;
41 Tables_in_test
42 CREATE TABLE t5(c1 MEDIUMINT(1) NULL);
43 Warnings:
44 Warning 1681 Integer display width is deprecated and will be removed in a future release.
45 SHOW TABLES;
46 Tables_in_test
47 t5
48 SHOW CREATE TABLE t5;
49 Table Create Table
50 t5 CREATE TABLE `t5` (
51 `c1` mediumint DEFAULT NULL
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 DROP TABLE t5;
54 SHOW TABLES;
55 Tables_in_test
56 CREATE TABLE t5(c1 INT(1) NULL);
57 Warnings:
58 Warning 1681 Integer display width is deprecated and will be removed in a future release.
59 SHOW TABLES;
60 Tables_in_test
61 t5
62 SHOW CREATE TABLE t5;
63 Table Create Table
64 t5 CREATE TABLE `t5` (
65 `c1` int DEFAULT NULL
66 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
67 DROP TABLE t5;
68 SHOW TABLES;
69 Tables_in_test
70 CREATE TABLE t5(c1 INTEGER(1) NULL);
71 Warnings:
72 Warning 1681 Integer display width is deprecated and will be removed in a future release.
73 SHOW TABLES;
74 Tables_in_test
75 t5
76 SHOW CREATE TABLE t5;
77 Table Create Table
78 t5 CREATE TABLE `t5` (
79 `c1` int DEFAULT NULL
80 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
81 DROP TABLE t5;
82 SHOW TABLES;
83 Tables_in_test
84 CREATE TABLE t5(c1 BIGINT(1) NULL);
85 Warnings:
86 Warning 1681 Integer display width is deprecated and will be removed in a future release.
87 SHOW TABLES;
88 Tables_in_test
89 t5
90 SHOW CREATE TABLE t5;
91 Table Create Table
92 t5 CREATE TABLE `t5` (
93 `c1` bigint DEFAULT NULL
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 DROP TABLE t5;
96 SHOW TABLES;
97 Tables_in_test
98 CREATE TABLE t5(c1 CHAR(1) NULL);
99 SHOW TABLES;
100 Tables_in_test
101 t5
102 SHOW CREATE TABLE t5;
103 Table Create Table
104 t5 CREATE TABLE `t5` (
105 `c1` char(1) DEFAULT NULL
106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
107 DROP TABLE t5;
108 SHOW TABLES;
109 Tables_in_test
110 CREATE TABLE t5(c1 VARCHAR(1) NULL);
111 SHOW TABLES;
112 Tables_in_test
113 t5
114 SHOW CREATE TABLE t5;
115 Table Create Table
116 t5 CREATE TABLE `t5` (
117 `c1` varchar(1) DEFAULT NULL
118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
119 DROP TABLE t5;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t5(c1 BINARY(1) NULL);
123 SHOW TABLES;
124 Tables_in_test
125 t5
126 SHOW CREATE TABLE t5;
127 Table Create Table
128 t5 CREATE TABLE `t5` (
129 `c1` binary(1) DEFAULT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t5;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t5(c1 VARBINARY(1) NULL);
135 SHOW TABLES;
136 Tables_in_test
137 t5
138 SHOW CREATE TABLE t5;
139 Table Create Table
140 t5 CREATE TABLE `t5` (
141 `c1` varbinary(1) DEFAULT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 DROP TABLE t5;
144 SHOW TABLES;
145 Tables_in_test
146 CREATE TABLE t5(c1 BIT(1) NOT NULL);
147 SHOW TABLES;
148 Tables_in_test
149 t5
150 SHOW CREATE TABLE t5;
151 Table Create Table
152 t5 CREATE TABLE `t5` (
153 `c1` bit(1) NOT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
155 DROP TABLE t5;
156 SHOW TABLES;
157 Tables_in_test
158 CREATE TABLE t5(c1 TINYINT(1) NOT NULL);
159 Warnings:
160 Warning 1681 Integer display width is deprecated and will be removed in a future release.
161 SHOW TABLES;
162 Tables_in_test
163 t5
164 SHOW CREATE TABLE t5;
165 Table Create Table
166 t5 CREATE TABLE `t5` (
167 `c1` tinyint(1) NOT NULL
168 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
169 DROP TABLE t5;
170 SHOW TABLES;
171 Tables_in_test
172 CREATE TABLE t5(c1 SMALLINT(1) NOT NULL);
173 Warnings:
174 Warning 1681 Integer display width is deprecated and will be removed in a future release.
175 SHOW TABLES;
176 Tables_in_test
177 t5
178 SHOW CREATE TABLE t5;
179 Table Create Table
180 t5 CREATE TABLE `t5` (
181 `c1` smallint NOT NULL
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 DROP TABLE t5;
184 SHOW TABLES;
185 Tables_in_test
186 CREATE TABLE t5(c1 MEDIUMINT(1) NOT NULL);
187 Warnings:
188 Warning 1681 Integer display width is deprecated and will be removed in a future release.
189 SHOW TABLES;
190 Tables_in_test
191 t5
192 SHOW CREATE TABLE t5;
193 Table Create Table
194 t5 CREATE TABLE `t5` (
195 `c1` mediumint NOT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t5;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t5(c1 INT(1) NOT NULL);
201 Warnings:
202 Warning 1681 Integer display width is deprecated and will be removed in a future release.
203 SHOW TABLES;
204 Tables_in_test
205 t5
206 SHOW CREATE TABLE t5;
207 Table Create Table
208 t5 CREATE TABLE `t5` (
209 `c1` int NOT NULL
210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
211 DROP TABLE t5;
212 SHOW TABLES;
213 Tables_in_test
214 CREATE TABLE t5(c1 INTEGER(1) NOT NULL);
215 Warnings:
216 Warning 1681 Integer display width is deprecated and will be removed in a future release.
217 SHOW TABLES;
218 Tables_in_test
219 t5
220 SHOW CREATE TABLE t5;
221 Table Create Table
222 t5 CREATE TABLE `t5` (
223 `c1` int NOT NULL
224 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
225 DROP TABLE t5;
226 SHOW TABLES;
227 Tables_in_test
228 CREATE TABLE t5(c1 BIGINT(1) NOT NULL);
229 Warnings:
230 Warning 1681 Integer display width is deprecated and will be removed in a future release.
231 SHOW TABLES;
232 Tables_in_test
233 t5
234 SHOW CREATE TABLE t5;
235 Table Create Table
236 t5 CREATE TABLE `t5` (
237 `c1` bigint NOT NULL
238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
239 DROP TABLE t5;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t5(c1 CHAR(1) NOT NULL);
243 SHOW TABLES;
244 Tables_in_test
245 t5
246 SHOW CREATE TABLE t5;
247 Table Create Table
248 t5 CREATE TABLE `t5` (
249 `c1` char(1) NOT NULL
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t5;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t5(c1 VARCHAR(1) NOT NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t5
258 SHOW CREATE TABLE t5;
259 Table Create Table
260 t5 CREATE TABLE `t5` (
261 `c1` varchar(1) NOT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t5;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t5(c1 BINARY(1) NOT NULL);
267 SHOW TABLES;
268 Tables_in_test
269 t5
270 SHOW CREATE TABLE t5;
271 Table Create Table
272 t5 CREATE TABLE `t5` (
273 `c1` binary(1) NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 DROP TABLE t5;
276 SHOW TABLES;
277 Tables_in_test
278 CREATE TABLE t5(c1 VARBINARY(1) NOT NULL);
279 SHOW TABLES;
280 Tables_in_test
281 t5
282 SHOW CREATE TABLE t5;
283 Table Create Table
284 t5 CREATE TABLE `t5` (
285 `c1` varbinary(1) NOT NULL
286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
287 DROP TABLE t5;
288 SHOW TABLES;
289 Tables_in_test