Debian Codegraph @

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

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