Debian Codegraph @

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

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