Debian Codegraph @

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

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