Debian Codegraph @

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

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