Debian Codegraph @

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

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