Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t3;
2 CREATE TABLE t3(c1 TINYINT UNSIGNED NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t3
6 SHOW CREATE TABLE t3;
7 Table Create Table
8 t3 CREATE TABLE `t3` (
9 `c1` tinyint unsigned DEFAULT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 DROP TABLE t3;
12 SHOW TABLES;
13 Tables_in_test
14 CREATE TABLE t3(c1 SMALLINT UNSIGNED NULL);
15 SHOW TABLES;
16 Tables_in_test
17 t3
18 SHOW CREATE TABLE t3;
19 Table Create Table
20 t3 CREATE TABLE `t3` (
21 `c1` smallint unsigned DEFAULT NULL
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
23 DROP TABLE t3;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NULL);
27 SHOW TABLES;
28 Tables_in_test
29 t3
30 SHOW CREATE TABLE t3;
31 Table Create Table
32 t3 CREATE TABLE `t3` (
33 `c1` mediumint unsigned DEFAULT NULL
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
35 DROP TABLE t3;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE t3(c1 INT UNSIGNED NULL);
39 SHOW TABLES;
40 Tables_in_test
41 t3
42 SHOW CREATE TABLE t3;
43 Table Create Table
44 t3 CREATE TABLE `t3` (
45 `c1` int unsigned DEFAULT NULL
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 DROP TABLE t3;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t3(c1 INTEGER UNSIGNED NULL);
51 SHOW TABLES;
52 Tables_in_test
53 t3
54 SHOW CREATE TABLE t3;
55 Table Create Table
56 t3 CREATE TABLE `t3` (
57 `c1` int unsigned DEFAULT NULL
58 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
59 DROP TABLE t3;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t3(c1 BIGINT UNSIGNED NULL);
63 SHOW TABLES;
64 Tables_in_test
65 t3
66 SHOW CREATE TABLE t3;
67 Table Create Table
68 t3 CREATE TABLE `t3` (
69 `c1` bigint unsigned DEFAULT NULL
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 DROP TABLE t3;
72 SHOW TABLES;
73 Tables_in_test
74 CREATE TABLE t3(c1 DECIMAL UNSIGNED NULL);
75 Warnings:
76 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
77 SHOW TABLES;
78 Tables_in_test
79 t3
80 SHOW CREATE TABLE t3;
81 Table Create Table
82 t3 CREATE TABLE `t3` (
83 `c1` decimal(10,0) unsigned DEFAULT NULL
84 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
85 DROP TABLE t3;
86 SHOW TABLES;
87 Tables_in_test
88 CREATE TABLE t3(c1 DEC UNSIGNED NULL);
89 Warnings:
90 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
91 SHOW TABLES;
92 Tables_in_test
93 t3
94 SHOW CREATE TABLE t3;
95 Table Create Table
96 t3 CREATE TABLE `t3` (
97 `c1` decimal(10,0) unsigned DEFAULT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 DROP TABLE t3;
100 SHOW TABLES;
101 Tables_in_test
102 CREATE TABLE t3(c1 FIXED UNSIGNED NULL);
103 Warnings:
104 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
105 SHOW TABLES;
106 Tables_in_test
107 t3
108 SHOW CREATE TABLE t3;
109 Table Create Table
110 t3 CREATE TABLE `t3` (
111 `c1` decimal(10,0) unsigned DEFAULT NULL
112 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
113 DROP TABLE t3;
114 SHOW TABLES;
115 Tables_in_test
116 CREATE TABLE t3(c1 NUMERIC UNSIGNED NULL);
117 Warnings:
118 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
119 SHOW TABLES;
120 Tables_in_test
121 t3
122 SHOW CREATE TABLE t3;
123 Table Create Table
124 t3 CREATE TABLE `t3` (
125 `c1` decimal(10,0) unsigned DEFAULT NULL
126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
127 DROP TABLE t3;
128 SHOW TABLES;
129 Tables_in_test
130 CREATE TABLE t3(c1 DOUBLE UNSIGNED NULL);
131 Warnings:
132 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
133 SHOW TABLES;
134 Tables_in_test
135 t3
136 SHOW CREATE TABLE t3;
137 Table Create Table
138 t3 CREATE TABLE `t3` (
139 `c1` double unsigned DEFAULT NULL
140 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
141 DROP TABLE t3;
142 SHOW TABLES;
143 Tables_in_test
144 CREATE TABLE t3(c1 REAL UNSIGNED NULL);
145 Warnings:
146 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
147 SHOW TABLES;
148 Tables_in_test
149 t3
150 SHOW CREATE TABLE t3;
151 Table Create Table
152 t3 CREATE TABLE `t3` (
153 `c1` double unsigned DEFAULT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
155 DROP TABLE t3;
156 SHOW TABLES;
157 Tables_in_test
158 CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NULL);
159 Warnings:
160 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
161 SHOW TABLES;
162 Tables_in_test
163 t3
164 SHOW CREATE TABLE t3;
165 Table Create Table
166 t3 CREATE TABLE `t3` (
167 `c1` double unsigned DEFAULT NULL
168 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
169 DROP TABLE t3;
170 SHOW TABLES;
171 Tables_in_test
172 CREATE TABLE t3(c1 FLOAT UNSIGNED NULL);
173 Warnings:
174 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
175 SHOW TABLES;
176 Tables_in_test
177 t3
178 SHOW CREATE TABLE t3;
179 Table Create Table
180 t3 CREATE TABLE `t3` (
181 `c1` float unsigned DEFAULT NULL
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 DROP TABLE t3;
184 SHOW TABLES;
185 Tables_in_test
186 CREATE TABLE t3(c1 TINYINT UNSIGNED NOT NULL);
187 SHOW TABLES;
188 Tables_in_test
189 t3
190 SHOW CREATE TABLE t3;
191 Table Create Table
192 t3 CREATE TABLE `t3` (
193 `c1` tinyint unsigned NOT NULL
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t3;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t3(c1 SMALLINT UNSIGNED NOT NULL);
199 SHOW TABLES;
200 Tables_in_test
201 t3
202 SHOW CREATE TABLE t3;
203 Table Create Table
204 t3 CREATE TABLE `t3` (
205 `c1` smallint unsigned NOT NULL
206 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
207 DROP TABLE t3;
208 SHOW TABLES;
209 Tables_in_test
210 CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NOT NULL);
211 SHOW TABLES;
212 Tables_in_test
213 t3
214 SHOW CREATE TABLE t3;
215 Table Create Table
216 t3 CREATE TABLE `t3` (
217 `c1` mediumint unsigned NOT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t3;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t3(c1 INT UNSIGNED NOT NULL);
223 SHOW TABLES;
224 Tables_in_test
225 t3
226 SHOW CREATE TABLE t3;
227 Table Create Table
228 t3 CREATE TABLE `t3` (
229 `c1` int unsigned NOT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 DROP TABLE t3;
232 SHOW TABLES;
233 Tables_in_test
234 CREATE TABLE t3(c1 INTEGER UNSIGNED NOT NULL);
235 SHOW TABLES;
236 Tables_in_test
237 t3
238 SHOW CREATE TABLE t3;
239 Table Create Table
240 t3 CREATE TABLE `t3` (
241 `c1` int unsigned NOT NULL
242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
243 DROP TABLE t3;
244 SHOW TABLES;
245 Tables_in_test
246 CREATE TABLE t3(c1 BIGINT UNSIGNED NOT NULL);
247 SHOW TABLES;
248 Tables_in_test
249 t3
250 SHOW CREATE TABLE t3;
251 Table Create Table
252 t3 CREATE TABLE `t3` (
253 `c1` bigint unsigned NOT NULL
254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
255 DROP TABLE t3;
256 SHOW TABLES;
257 Tables_in_test
258 CREATE TABLE t3(c1 DECIMAL UNSIGNED NOT NULL);
259 Warnings:
260 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
261 SHOW TABLES;
262 Tables_in_test
263 t3
264 SHOW CREATE TABLE t3;
265 Table Create Table
266 t3 CREATE TABLE `t3` (
267 `c1` decimal(10,0) unsigned NOT NULL
268 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
269 DROP TABLE t3;
270 SHOW TABLES;
271 Tables_in_test
272 CREATE TABLE t3(c1 DEC UNSIGNED NOT NULL);
273 Warnings:
274 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
275 SHOW TABLES;
276 Tables_in_test
277 t3
278 SHOW CREATE TABLE t3;
279 Table Create Table
280 t3 CREATE TABLE `t3` (
281 `c1` decimal(10,0) unsigned NOT NULL
282 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
283 DROP TABLE t3;
284 SHOW TABLES;
285 Tables_in_test
286 CREATE TABLE t3(c1 FIXED UNSIGNED NOT NULL);
287 Warnings:
288 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
289 SHOW TABLES;
290 Tables_in_test
291 t3
292 SHOW CREATE TABLE t3;
293 Table Create Table
294 t3 CREATE TABLE `t3` (
295 `c1` decimal(10,0) unsigned NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 DROP TABLE t3;
298 SHOW TABLES;
299 Tables_in_test
300 CREATE TABLE t3(c1 NUMERIC UNSIGNED NOT NULL);
301 Warnings:
302 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
303 SHOW TABLES;
304 Tables_in_test
305 t3
306 SHOW CREATE TABLE t3;
307 Table Create Table
308 t3 CREATE TABLE `t3` (
309 `c1` decimal(10,0) unsigned NOT NULL
310 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
311 DROP TABLE t3;
312 SHOW TABLES;
313 Tables_in_test
314 CREATE TABLE t3(c1 DOUBLE UNSIGNED NOT NULL);
315 Warnings:
316 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
317 SHOW TABLES;
318 Tables_in_test
319 t3
320 SHOW CREATE TABLE t3;
321 Table Create Table
322 t3 CREATE TABLE `t3` (
323 `c1` double unsigned NOT NULL
324 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
325 DROP TABLE t3;
326 SHOW TABLES;
327 Tables_in_test
328 CREATE TABLE t3(c1 REAL UNSIGNED NOT NULL);
329 Warnings:
330 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
331 SHOW TABLES;
332 Tables_in_test
333 t3
334 SHOW CREATE TABLE t3;
335 Table Create Table
336 t3 CREATE TABLE `t3` (
337 `c1` double unsigned NOT NULL
338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
339 DROP TABLE t3;
340 SHOW TABLES;
341 Tables_in_test
342 CREATE TABLE t3(c1 DOUBLE PRECISION UNSIGNED NOT NULL);
343 Warnings:
344 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
345 SHOW TABLES;
346 Tables_in_test
347 t3
348 SHOW CREATE TABLE t3;
349 Table Create Table
350 t3 CREATE TABLE `t3` (
351 `c1` double unsigned NOT NULL
352 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
353 DROP TABLE t3;
354 SHOW TABLES;
355 Tables_in_test
356 CREATE TABLE t3(c1 FLOAT UNSIGNED NOT NULL);
357 Warnings:
358 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
359 SHOW TABLES;
360 Tables_in_test
361 t3
362 SHOW CREATE TABLE t3;
363 Table Create Table
364 t3 CREATE TABLE `t3` (
365 `c1` float unsigned NOT NULL
366 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
367 DROP TABLE t3;
368 SHOW TABLES;
369 Tables_in_test