Debian Codegraph @

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

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