Debian Codegraph @

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

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