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