Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` char(30) NOT NULL,
10 `c2` char(20) NOT NULL,
11 `c3` int DEFAULT NULL,
12 `c4` varchar(10) NOT NULL
13 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
14 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` char(30) NOT NULL,
22 `c2` char(20) NOT NULL,
23 `c3` int DEFAULT NULL,
24 `c4` varchar(10) NOT NULL,
25 PRIMARY KEY (`c1`,`c2`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 DROP TABLE t1;
28 SHOW TABLES;
29 Tables_in_test
30 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
31 SHOW TABLES;
32 Tables_in_test
33 t1
34 SHOW CREATE TABLE t1;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `c1` varchar(30) NOT NULL,
38 `c2` char(20) NOT NULL,
39 `c3` int DEFAULT NULL,
40 `c4` varchar(10) NOT NULL
41 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
42 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
43 SHOW TABLES;
44 Tables_in_test
45 t1
46 SHOW CREATE TABLE t1;
47 Table Create Table
48 t1 CREATE TABLE `t1` (
49 `c1` varchar(30) NOT NULL,
50 `c2` char(20) NOT NULL,
51 `c3` int DEFAULT NULL,
52 `c4` varchar(10) NOT NULL,
53 PRIMARY KEY (`c1`,`c2`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 DROP TABLE t1;
56 SHOW TABLES;
57 Tables_in_test
58 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
59 SHOW TABLES;
60 Tables_in_test
61 t1
62 SHOW CREATE TABLE t1;
63 Table Create Table
64 t1 CREATE TABLE `t1` (
65 `c1` binary(30) NOT NULL,
66 `c2` char(20) NOT NULL,
67 `c3` int DEFAULT NULL,
68 `c4` varchar(10) NOT NULL
69 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
71 SHOW TABLES;
72 Tables_in_test
73 t1
74 SHOW CREATE TABLE t1;
75 Table Create Table
76 t1 CREATE TABLE `t1` (
77 `c1` binary(30) NOT NULL,
78 `c2` char(20) NOT NULL,
79 `c3` int DEFAULT NULL,
80 `c4` varchar(10) NOT NULL,
81 PRIMARY KEY (`c1`,`c2`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 DROP TABLE t1;
84 SHOW TABLES;
85 Tables_in_test
86 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
87 SHOW TABLES;
88 Tables_in_test
89 t1
90 SHOW CREATE TABLE t1;
91 Table Create Table
92 t1 CREATE TABLE `t1` (
93 `c1` varbinary(30) NOT NULL,
94 `c2` char(20) NOT NULL,
95 `c3` int DEFAULT NULL,
96 `c4` varchar(10) NOT NULL
97 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
98 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` varbinary(30) NOT NULL,
106 `c2` char(20) NOT NULL,
107 `c3` int DEFAULT NULL,
108 `c4` varchar(10) NOT NULL,
109 PRIMARY KEY (`c1`,`c2`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
111 DROP TABLE t1;
112 SHOW TABLES;
113 Tables_in_test
114 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
115 SHOW TABLES;
116 Tables_in_test
117 t1
118 SHOW CREATE TABLE t1;
119 Table Create Table
120 t1 CREATE TABLE `t1` (
121 `c1` char(30) NOT NULL,
122 `c2` varchar(20) NOT NULL,
123 `c3` int DEFAULT NULL,
124 `c4` varchar(10) NOT NULL
125 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
127 SHOW TABLES;
128 Tables_in_test
129 t1
130 SHOW CREATE TABLE t1;
131 Table Create Table
132 t1 CREATE TABLE `t1` (
133 `c1` char(30) NOT NULL,
134 `c2` varchar(20) NOT NULL,
135 `c3` int DEFAULT NULL,
136 `c4` varchar(10) NOT NULL,
137 PRIMARY KEY (`c1`,`c2`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
139 DROP TABLE t1;
140 SHOW TABLES;
141 Tables_in_test
142 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
143 SHOW TABLES;
144 Tables_in_test
145 t1
146 SHOW CREATE TABLE t1;
147 Table Create Table
148 t1 CREATE TABLE `t1` (
149 `c1` varchar(30) NOT NULL,
150 `c2` varchar(20) NOT NULL,
151 `c3` int DEFAULT NULL,
152 `c4` varchar(10) NOT NULL
153 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
154 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
155 SHOW TABLES;
156 Tables_in_test
157 t1
158 SHOW CREATE TABLE t1;
159 Table Create Table
160 t1 CREATE TABLE `t1` (
161 `c1` varchar(30) NOT NULL,
162 `c2` varchar(20) NOT NULL,
163 `c3` int DEFAULT NULL,
164 `c4` varchar(10) NOT NULL,
165 PRIMARY KEY (`c1`,`c2`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t1;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` binary(30) NOT NULL,
178 `c2` varchar(20) NOT NULL,
179 `c3` int DEFAULT NULL,
180 `c4` varchar(10) NOT NULL
181 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
182 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
183 SHOW TABLES;
184 Tables_in_test
185 t1
186 SHOW CREATE TABLE t1;
187 Table Create Table
188 t1 CREATE TABLE `t1` (
189 `c1` binary(30) NOT NULL,
190 `c2` varchar(20) NOT NULL,
191 `c3` int DEFAULT NULL,
192 `c4` varchar(10) NOT NULL,
193 PRIMARY KEY (`c1`,`c2`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
195 DROP TABLE t1;
196 SHOW TABLES;
197 Tables_in_test
198 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
199 SHOW TABLES;
200 Tables_in_test
201 t1
202 SHOW CREATE TABLE t1;
203 Table Create Table
204 t1 CREATE TABLE `t1` (
205 `c1` varbinary(30) NOT NULL,
206 `c2` varchar(20) NOT NULL,
207 `c3` int DEFAULT NULL,
208 `c4` varchar(10) NOT NULL
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` varbinary(30) NOT NULL,
218 `c2` varchar(20) NOT NULL,
219 `c3` int DEFAULT NULL,
220 `c4` varchar(10) NOT NULL,
221 PRIMARY KEY (`c1`,`c2`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 DROP TABLE t1;
224 SHOW TABLES;
225 Tables_in_test
226 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
227 SHOW TABLES;
228 Tables_in_test
229 t1
230 SHOW CREATE TABLE t1;
231 Table Create Table
232 t1 CREATE TABLE `t1` (
233 `c1` char(30) NOT NULL,
234 `c2` binary(20) NOT NULL,
235 `c3` int DEFAULT NULL,
236 `c4` varchar(10) NOT NULL
237 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
239 SHOW TABLES;
240 Tables_in_test
241 t1
242 SHOW CREATE TABLE t1;
243 Table Create Table
244 t1 CREATE TABLE `t1` (
245 `c1` char(30) NOT NULL,
246 `c2` binary(20) NOT NULL,
247 `c3` int DEFAULT NULL,
248 `c4` varchar(10) NOT NULL,
249 PRIMARY KEY (`c1`,`c2`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
251 DROP TABLE t1;
252 SHOW TABLES;
253 Tables_in_test
254 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
255 SHOW TABLES;
256 Tables_in_test
257 t1
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TABLE `t1` (
261 `c1` varchar(30) NOT NULL,
262 `c2` binary(20) NOT NULL,
263 `c3` int DEFAULT NULL,
264 `c4` varchar(10) NOT NULL
265 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
266 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` varchar(30) NOT NULL,
274 `c2` binary(20) NOT NULL,
275 `c3` int DEFAULT NULL,
276 `c4` varchar(10) NOT NULL,
277 PRIMARY KEY (`c1`,`c2`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
279 DROP TABLE t1;
280 SHOW TABLES;
281 Tables_in_test
282 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
283 SHOW TABLES;
284 Tables_in_test
285 t1
286 SHOW CREATE TABLE t1;
287 Table Create Table
288 t1 CREATE TABLE `t1` (
289 `c1` binary(30) NOT NULL,
290 `c2` binary(20) NOT NULL,
291 `c3` int DEFAULT NULL,
292 `c4` varchar(10) NOT NULL
293 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
294 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
295 SHOW TABLES;
296 Tables_in_test
297 t1
298 SHOW CREATE TABLE t1;
299 Table Create Table
300 t1 CREATE TABLE `t1` (
301 `c1` binary(30) NOT NULL,
302 `c2` binary(20) NOT NULL,
303 `c3` int DEFAULT NULL,
304 `c4` varchar(10) NOT NULL,
305 PRIMARY KEY (`c1`,`c2`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` varbinary(30) NOT NULL,
318 `c2` binary(20) NOT NULL,
319 `c3` int DEFAULT NULL,
320 `c4` varchar(10) NOT NULL
321 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
322 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
323 SHOW TABLES;
324 Tables_in_test
325 t1
326 SHOW CREATE TABLE t1;
327 Table Create Table
328 t1 CREATE TABLE `t1` (
329 `c1` varbinary(30) NOT NULL,
330 `c2` binary(20) NOT NULL,
331 `c3` int DEFAULT NULL,
332 `c4` varchar(10) NOT NULL,
333 PRIMARY KEY (`c1`,`c2`)
334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
335 DROP TABLE t1;
336 SHOW TABLES;
337 Tables_in_test
338 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` char(30) NOT NULL,
346 `c2` varbinary(20) NOT NULL,
347 `c3` int DEFAULT NULL,
348 `c4` varchar(10) NOT NULL
349 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
350 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
351 SHOW TABLES;
352 Tables_in_test
353 t1
354 SHOW CREATE TABLE t1;
355 Table Create Table
356 t1 CREATE TABLE `t1` (
357 `c1` char(30) NOT NULL,
358 `c2` varbinary(20) NOT NULL,
359 `c3` int DEFAULT NULL,
360 `c4` varchar(10) NOT NULL,
361 PRIMARY KEY (`c1`,`c2`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 DROP TABLE t1;
364 SHOW TABLES;
365 Tables_in_test
366 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` varchar(30) NOT NULL,
374 `c2` varbinary(20) NOT NULL,
375 `c3` int DEFAULT NULL,
376 `c4` varchar(10) NOT NULL
377 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
378 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` varchar(30) NOT NULL,
386 `c2` varbinary(20) NOT NULL,
387 `c3` int DEFAULT NULL,
388 `c4` varchar(10) NOT NULL,
389 PRIMARY KEY (`c1`,`c2`)
390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
391 DROP TABLE t1;
392 SHOW TABLES;
393 Tables_in_test
394 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
395 SHOW TABLES;
396 Tables_in_test
397 t1
398 SHOW CREATE TABLE t1;
399 Table Create Table
400 t1 CREATE TABLE `t1` (
401 `c1` binary(30) NOT NULL,
402 `c2` varbinary(20) NOT NULL,
403 `c3` int DEFAULT NULL,
404 `c4` varchar(10) NOT NULL
405 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
406 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
407 SHOW TABLES;
408 Tables_in_test
409 t1
410 SHOW CREATE TABLE t1;
411 Table Create Table
412 t1 CREATE TABLE `t1` (
413 `c1` binary(30) NOT NULL,
414 `c2` varbinary(20) NOT NULL,
415 `c3` int DEFAULT NULL,
416 `c4` varchar(10) NOT NULL,
417 PRIMARY KEY (`c1`,`c2`)
418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 DROP TABLE t1;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
423 SHOW TABLES;
424 Tables_in_test
425 t1
426 SHOW CREATE TABLE t1;
427 Table Create Table
428 t1 CREATE TABLE `t1` (
429 `c1` varbinary(30) NOT NULL,
430 `c2` varbinary(20) NOT NULL,
431 `c3` int DEFAULT NULL,
432 `c4` varchar(10) NOT NULL
433 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
434 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
435 SHOW TABLES;
436 Tables_in_test
437 t1
438 SHOW CREATE TABLE t1;
439 Table Create Table
440 t1 CREATE TABLE `t1` (
441 `c1` varbinary(30) NOT NULL,
442 `c2` varbinary(20) NOT NULL,
443 `c3` int DEFAULT NULL,
444 `c4` varchar(10) NOT NULL,
445 PRIMARY KEY (`c1`,`c2`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
447 DROP TABLE t1;
448 SHOW TABLES;
449 Tables_in_test