Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_2part_diff_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 INT NULL, c4 VARCHAR(10) 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` int DEFAULT NULL,
13 `c4` varchar(10) NOT NULL
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
16 SHOW TABLES;
17 Tables_in_test
18 t1
19 SHOW CREATE TABLE t1;
20 Table Create Table
21 t1 CREATE TABLE `t1` (
22 `c1` bit(1) NOT NULL,
23 `c2` bit(1) NOT NULL,
24 `c3` int DEFAULT NULL,
25 `c4` varchar(10) NOT NULL,
26 PRIMARY KEY (`c1`,`c2`)
27 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 DROP TABLE t1;
29 SHOW TABLES;
30 Tables_in_test
31 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
32 SHOW TABLES;
33 Tables_in_test
34 t1
35 SHOW CREATE TABLE t1;
36 Table Create Table
37 t1 CREATE TABLE `t1` (
38 `c1` tinyint NOT NULL,
39 `c2` bit(1) NOT NULL,
40 `c3` int DEFAULT NULL,
41 `c4` varchar(10) NOT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
44 SHOW TABLES;
45 Tables_in_test
46 t1
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `c1` tinyint NOT NULL,
51 `c2` bit(1) NOT NULL,
52 `c3` int DEFAULT NULL,
53 `c4` varchar(10) NOT NULL,
54 PRIMARY KEY (`c1`,`c2`)
55 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 DROP TABLE t1;
57 SHOW TABLES;
58 Tables_in_test
59 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
60 SHOW TABLES;
61 Tables_in_test
62 t1
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `c1` smallint NOT NULL,
67 `c2` bit(1) NOT NULL,
68 `c3` int DEFAULT NULL,
69 `c4` varchar(10) NOT NULL
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
72 SHOW TABLES;
73 Tables_in_test
74 t1
75 SHOW CREATE TABLE t1;
76 Table Create Table
77 t1 CREATE TABLE `t1` (
78 `c1` smallint NOT NULL,
79 `c2` bit(1) NOT NULL,
80 `c3` int DEFAULT NULL,
81 `c4` varchar(10) NOT NULL,
82 PRIMARY KEY (`c1`,`c2`)
83 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
84 DROP TABLE t1;
85 SHOW TABLES;
86 Tables_in_test
87 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
88 SHOW TABLES;
89 Tables_in_test
90 t1
91 SHOW CREATE TABLE t1;
92 Table Create Table
93 t1 CREATE TABLE `t1` (
94 `c1` mediumint NOT NULL,
95 `c2` bit(1) NOT NULL,
96 `c3` int DEFAULT NULL,
97 `c4` varchar(10) NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` mediumint NOT NULL,
107 `c2` bit(1) NOT NULL,
108 `c3` int DEFAULT NULL,
109 `c4` varchar(10) NOT NULL,
110 PRIMARY KEY (`c1`,`c2`)
111 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
112 DROP TABLE t1;
113 SHOW TABLES;
114 Tables_in_test
115 CREATE TABLE t1(c1 INT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
116 SHOW TABLES;
117 Tables_in_test
118 t1
119 SHOW CREATE TABLE t1;
120 Table Create Table
121 t1 CREATE TABLE `t1` (
122 `c1` int NOT NULL,
123 `c2` bit(1) NOT NULL,
124 `c3` int DEFAULT NULL,
125 `c4` varchar(10) NOT NULL
126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
127 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
128 SHOW TABLES;
129 Tables_in_test
130 t1
131 SHOW CREATE TABLE t1;
132 Table Create Table
133 t1 CREATE TABLE `t1` (
134 `c1` int NOT NULL,
135 `c2` bit(1) NOT NULL,
136 `c3` int DEFAULT NULL,
137 `c4` varchar(10) NOT NULL,
138 PRIMARY KEY (`c1`,`c2`)
139 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
140 DROP TABLE t1;
141 SHOW TABLES;
142 Tables_in_test
143 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
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 NOT NULL,
151 `c2` bit(1) NOT NULL,
152 `c3` int DEFAULT NULL,
153 `c4` varchar(10) NOT NULL
154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
155 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
156 SHOW TABLES;
157 Tables_in_test
158 t1
159 SHOW CREATE TABLE t1;
160 Table Create Table
161 t1 CREATE TABLE `t1` (
162 `c1` int NOT NULL,
163 `c2` bit(1) NOT NULL,
164 `c3` int DEFAULT NULL,
165 `c4` varchar(10) 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 BIGINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` bigint NOT NULL,
179 `c2` bit(1) NOT NULL,
180 `c3` int DEFAULT NULL,
181 `c4` varchar(10) NOT NULL
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
184 SHOW TABLES;
185 Tables_in_test
186 t1
187 SHOW CREATE TABLE t1;
188 Table Create Table
189 t1 CREATE TABLE `t1` (
190 `c1` bigint NOT NULL,
191 `c2` bit(1) NOT NULL,
192 `c3` int DEFAULT NULL,
193 `c4` varchar(10) NOT NULL,
194 PRIMARY KEY (`c1`,`c2`)
195 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
196 DROP TABLE t1;
197 SHOW TABLES;
198 Tables_in_test
199 CREATE TABLE t1(c1 REAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
200 SHOW TABLES;
201 Tables_in_test
202 t1
203 SHOW CREATE TABLE t1;
204 Table Create Table
205 t1 CREATE TABLE `t1` (
206 `c1` double NOT NULL,
207 `c2` bit(1) NOT NULL,
208 `c3` int DEFAULT NULL,
209 `c4` varchar(10) NOT NULL
210 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
211 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` bit(1) NOT NULL,
220 `c3` int DEFAULT NULL,
221 `c4` varchar(10) NOT NULL,
222 PRIMARY KEY (`c1`,`c2`)
223 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
224 DROP TABLE t1;
225 SHOW TABLES;
226 Tables_in_test
227 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
228 SHOW TABLES;
229 Tables_in_test
230 t1
231 SHOW CREATE TABLE t1;
232 Table Create Table
233 t1 CREATE TABLE `t1` (
234 `c1` double NOT NULL,
235 `c2` bit(1) NOT NULL,
236 `c3` int DEFAULT NULL,
237 `c4` varchar(10) NOT NULL
238 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
239 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
240 SHOW TABLES;
241 Tables_in_test
242 t1
243 SHOW CREATE TABLE t1;
244 Table Create Table
245 t1 CREATE TABLE `t1` (
246 `c1` double NOT NULL,
247 `c2` bit(1) NOT NULL,
248 `c3` int DEFAULT NULL,
249 `c4` varchar(10) NOT NULL,
250 PRIMARY KEY (`c1`,`c2`)
251 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
252 DROP TABLE t1;
253 SHOW TABLES;
254 Tables_in_test
255 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
256 SHOW TABLES;
257 Tables_in_test
258 t1
259 SHOW CREATE TABLE t1;
260 Table Create Table
261 t1 CREATE TABLE `t1` (
262 `c1` float NOT NULL,
263 `c2` bit(1) NOT NULL,
264 `c3` int DEFAULT NULL,
265 `c4` varchar(10) NOT NULL
266 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
267 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` float NOT NULL,
275 `c2` bit(1) NOT NULL,
276 `c3` int DEFAULT NULL,
277 `c4` varchar(10) NOT NULL,
278 PRIMARY KEY (`c1`,`c2`)
279 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
280 DROP TABLE t1;
281 SHOW TABLES;
282 Tables_in_test
283 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
284 SHOW TABLES;
285 Tables_in_test
286 t1
287 SHOW CREATE TABLE t1;
288 Table Create Table
289 t1 CREATE TABLE `t1` (
290 `c1` decimal(10,0) NOT NULL,
291 `c2` bit(1) NOT NULL,
292 `c3` int DEFAULT NULL,
293 `c4` varchar(10) NOT NULL
294 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
295 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
296 SHOW TABLES;
297 Tables_in_test
298 t1
299 SHOW CREATE TABLE t1;
300 Table Create Table
301 t1 CREATE TABLE `t1` (
302 `c1` decimal(10,0) NOT NULL,
303 `c2` bit(1) NOT NULL,
304 `c3` int DEFAULT NULL,
305 `c4` varchar(10) NOT NULL,
306 PRIMARY KEY (`c1`,`c2`)
307 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
308 DROP TABLE t1;
309 SHOW TABLES;
310 Tables_in_test
311 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
312 SHOW TABLES;
313 Tables_in_test
314 t1
315 SHOW CREATE TABLE t1;
316 Table Create Table
317 t1 CREATE TABLE `t1` (
318 `c1` decimal(10,0) NOT NULL,
319 `c2` bit(1) NOT NULL,
320 `c3` int DEFAULT NULL,
321 `c4` varchar(10) NOT NULL
322 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
323 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
324 SHOW TABLES;
325 Tables_in_test
326 t1
327 SHOW CREATE TABLE t1;
328 Table Create Table
329 t1 CREATE TABLE `t1` (
330 `c1` decimal(10,0) NOT NULL,
331 `c2` bit(1) NOT NULL,
332 `c3` int DEFAULT NULL,
333 `c4` varchar(10) 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 DATE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` date NOT NULL,
347 `c2` bit(1) NOT NULL,
348 `c3` int DEFAULT NULL,
349 `c4` varchar(10) NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
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` date NOT NULL,
359 `c2` bit(1) NOT NULL,
360 `c3` int DEFAULT NULL,
361 `c4` varchar(10) NOT NULL,
362 PRIMARY KEY (`c1`,`c2`)
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 TIME NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) 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` time NOT NULL,
375 `c2` bit(1) NOT NULL,
376 `c3` int DEFAULT NULL,
377 `c4` varchar(10) NOT NULL
378 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
379 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
380 SHOW TABLES;
381 Tables_in_test
382 t1
383 SHOW CREATE TABLE t1;
384 Table Create Table
385 t1 CREATE TABLE `t1` (
386 `c1` time NOT NULL,
387 `c2` bit(1) NOT NULL,
388 `c3` int DEFAULT NULL,
389 `c4` varchar(10) NOT NULL,
390 PRIMARY KEY (`c1`,`c2`)
391 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
392 DROP TABLE t1;
393 SHOW TABLES;
394 Tables_in_test
395 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
396 SHOW TABLES;
397 Tables_in_test
398 t1
399 SHOW CREATE TABLE t1;
400 Table Create Table
401 t1 CREATE TABLE `t1` (
402 `c1` timestamp NOT NULL,
403 `c2` bit(1) NOT NULL,
404 `c3` int DEFAULT NULL,
405 `c4` varchar(10) NOT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
408 SHOW TABLES;
409 Tables_in_test
410 t1
411 SHOW CREATE TABLE t1;
412 Table Create Table
413 t1 CREATE TABLE `t1` (
414 `c1` timestamp NOT NULL,
415 `c2` bit(1) NOT NULL,
416 `c3` int DEFAULT NULL,
417 `c4` varchar(10) NOT NULL,
418 PRIMARY KEY (`c1`,`c2`)
419 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
420 DROP TABLE t1;
421 SHOW TABLES;
422 Tables_in_test
423 CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
424 SHOW TABLES;
425 Tables_in_test
426 t1
427 SHOW CREATE TABLE t1;
428 Table Create Table
429 t1 CREATE TABLE `t1` (
430 `c1` year NOT NULL,
431 `c2` bit(1) NOT NULL,
432 `c3` int DEFAULT NULL,
433 `c4` varchar(10) NOT NULL
434 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
435 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
436 SHOW TABLES;
437 Tables_in_test
438 t1
439 SHOW CREATE TABLE t1;
440 Table Create Table
441 t1 CREATE TABLE `t1` (
442 `c1` year NOT NULL,
443 `c2` bit(1) NOT NULL,
444 `c3` int DEFAULT NULL,
445 `c4` varchar(10) NOT NULL,
446 PRIMARY KEY (`c1`,`c2`)
447 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
448 DROP TABLE t1;
449 SHOW TABLES;
450 Tables_in_test
451 CREATE TABLE t1(c1 BIT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
452 SHOW TABLES;
453 Tables_in_test
454 t1
455 SHOW CREATE TABLE t1;
456 Table Create Table
457 t1 CREATE TABLE `t1` (
458 `c1` bit(1) NOT NULL,
459 `c2` tinyint NOT NULL,
460 `c3` int DEFAULT NULL,
461 `c4` varchar(10) NOT NULL
462 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
463 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
464 SHOW TABLES;
465 Tables_in_test
466 t1
467 SHOW CREATE TABLE t1;
468 Table Create Table
469 t1 CREATE TABLE `t1` (
470 `c1` bit(1) NOT NULL,
471 `c2` tinyint NOT NULL,
472 `c3` int DEFAULT NULL,
473 `c4` varchar(10) NOT NULL,
474 PRIMARY KEY (`c1`,`c2`)
475 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
476 DROP TABLE t1;
477 SHOW TABLES;
478 Tables_in_test
479 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
480 SHOW TABLES;
481 Tables_in_test
482 t1
483 SHOW CREATE TABLE t1;
484 Table Create Table
485 t1 CREATE TABLE `t1` (
486 `c1` tinyint NOT NULL,
487 `c2` tinyint NOT NULL,
488 `c3` int DEFAULT NULL,
489 `c4` varchar(10) NOT NULL
490 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
491 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
492 SHOW TABLES;
493 Tables_in_test
494 t1
495 SHOW CREATE TABLE t1;
496 Table Create Table
497 t1 CREATE TABLE `t1` (
498 `c1` tinyint NOT NULL,
499 `c2` tinyint NOT NULL,
500 `c3` int DEFAULT NULL,
501 `c4` varchar(10) NOT NULL,
502 PRIMARY KEY (`c1`,`c2`)
503 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
504 DROP TABLE t1;
505 SHOW TABLES;
506 Tables_in_test
507 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
508 SHOW TABLES;
509 Tables_in_test
510 t1
511 SHOW CREATE TABLE t1;
512 Table Create Table
513 t1 CREATE TABLE `t1` (
514 `c1` smallint NOT NULL,
515 `c2` tinyint NOT NULL,
516 `c3` int DEFAULT NULL,
517 `c4` varchar(10) NOT NULL
518 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
519 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
520 SHOW TABLES;
521 Tables_in_test
522 t1
523 SHOW CREATE TABLE t1;
524 Table Create Table
525 t1 CREATE TABLE `t1` (
526 `c1` smallint NOT NULL,
527 `c2` tinyint NOT NULL,
528 `c3` int DEFAULT NULL,
529 `c4` varchar(10) NOT NULL,
530 PRIMARY KEY (`c1`,`c2`)
531 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
532 DROP TABLE t1;
533 SHOW TABLES;
534 Tables_in_test
535 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
536 SHOW TABLES;
537 Tables_in_test
538 t1
539 SHOW CREATE TABLE t1;
540 Table Create Table
541 t1 CREATE TABLE `t1` (
542 `c1` mediumint NOT NULL,
543 `c2` tinyint NOT NULL,
544 `c3` int DEFAULT NULL,
545 `c4` varchar(10) NOT NULL
546 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
547 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
548 SHOW TABLES;
549 Tables_in_test
550 t1
551 SHOW CREATE TABLE t1;
552 Table Create Table
553 t1 CREATE TABLE `t1` (
554 `c1` mediumint NOT NULL,
555 `c2` tinyint NOT NULL,
556 `c3` int DEFAULT NULL,
557 `c4` varchar(10) NOT NULL,
558 PRIMARY KEY (`c1`,`c2`)
559 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
560 DROP TABLE t1;
561 SHOW TABLES;
562 Tables_in_test
563 CREATE TABLE t1(c1 INT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
564 SHOW TABLES;
565 Tables_in_test
566 t1
567 SHOW CREATE TABLE t1;
568 Table Create Table
569 t1 CREATE TABLE `t1` (
570 `c1` int NOT NULL,
571 `c2` tinyint NOT NULL,
572 `c3` int DEFAULT NULL,
573 `c4` varchar(10) NOT NULL
574 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
575 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
576 SHOW TABLES;
577 Tables_in_test
578 t1
579 SHOW CREATE TABLE t1;
580 Table Create Table
581 t1 CREATE TABLE `t1` (
582 `c1` int NOT NULL,
583 `c2` tinyint NOT NULL,
584 `c3` int DEFAULT NULL,
585 `c4` varchar(10) NOT NULL,
586 PRIMARY KEY (`c1`,`c2`)
587 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
588 DROP TABLE t1;
589 SHOW TABLES;
590 Tables_in_test
591 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
592 SHOW TABLES;
593 Tables_in_test
594 t1
595 SHOW CREATE TABLE t1;
596 Table Create Table
597 t1 CREATE TABLE `t1` (
598 `c1` int NOT NULL,
599 `c2` tinyint NOT NULL,
600 `c3` int DEFAULT NULL,
601 `c4` varchar(10) NOT NULL
602 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
603 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
604 SHOW TABLES;
605 Tables_in_test
606 t1
607 SHOW CREATE TABLE t1;
608 Table Create Table
609 t1 CREATE TABLE `t1` (
610 `c1` int NOT NULL,
611 `c2` tinyint NOT NULL,
612 `c3` int DEFAULT NULL,
613 `c4` varchar(10) NOT NULL,
614 PRIMARY KEY (`c1`,`c2`)
615 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
616 DROP TABLE t1;
617 SHOW TABLES;
618 Tables_in_test
619 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
620 SHOW TABLES;
621 Tables_in_test
622 t1
623 SHOW CREATE TABLE t1;
624 Table Create Table
625 t1 CREATE TABLE `t1` (
626 `c1` bigint NOT NULL,
627 `c2` tinyint NOT NULL,
628 `c3` int DEFAULT NULL,
629 `c4` varchar(10) NOT NULL
630 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
631 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
632 SHOW TABLES;
633 Tables_in_test
634 t1
635 SHOW CREATE TABLE t1;
636 Table Create Table
637 t1 CREATE TABLE `t1` (
638 `c1` bigint NOT NULL,
639 `c2` tinyint NOT NULL,
640 `c3` int DEFAULT NULL,
641 `c4` varchar(10) NOT NULL,
642 PRIMARY KEY (`c1`,`c2`)
643 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
644 DROP TABLE t1;
645 SHOW TABLES;
646 Tables_in_test
647 CREATE TABLE t1(c1 REAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
648 SHOW TABLES;
649 Tables_in_test
650 t1
651 SHOW CREATE TABLE t1;
652 Table Create Table
653 t1 CREATE TABLE `t1` (
654 `c1` double NOT NULL,
655 `c2` tinyint NOT NULL,
656 `c3` int DEFAULT NULL,
657 `c4` varchar(10) NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
660 SHOW TABLES;
661 Tables_in_test
662 t1
663 SHOW CREATE TABLE t1;
664 Table Create Table
665 t1 CREATE TABLE `t1` (
666 `c1` double NOT NULL,
667 `c2` tinyint NOT NULL,
668 `c3` int DEFAULT NULL,
669 `c4` varchar(10) NOT NULL,
670 PRIMARY KEY (`c1`,`c2`)
671 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
672 DROP TABLE t1;
673 SHOW TABLES;
674 Tables_in_test
675 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
676 SHOW TABLES;
677 Tables_in_test
678 t1
679 SHOW CREATE TABLE t1;
680 Table Create Table
681 t1 CREATE TABLE `t1` (
682 `c1` double NOT NULL,
683 `c2` tinyint NOT NULL,
684 `c3` int DEFAULT NULL,
685 `c4` varchar(10) NOT NULL
686 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
687 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
688 SHOW TABLES;
689 Tables_in_test
690 t1
691 SHOW CREATE TABLE t1;
692 Table Create Table
693 t1 CREATE TABLE `t1` (
694 `c1` double NOT NULL,
695 `c2` tinyint NOT NULL,
696 `c3` int DEFAULT NULL,
697 `c4` varchar(10) NOT NULL,
698 PRIMARY KEY (`c1`,`c2`)
699 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
700 DROP TABLE t1;
701 SHOW TABLES;
702 Tables_in_test
703 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
704 SHOW TABLES;
705 Tables_in_test
706 t1
707 SHOW CREATE TABLE t1;
708 Table Create Table
709 t1 CREATE TABLE `t1` (
710 `c1` float NOT NULL,
711 `c2` tinyint NOT NULL,
712 `c3` int DEFAULT NULL,
713 `c4` varchar(10) NOT NULL
714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
715 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
716 SHOW TABLES;
717 Tables_in_test
718 t1
719 SHOW CREATE TABLE t1;
720 Table Create Table
721 t1 CREATE TABLE `t1` (
722 `c1` float NOT NULL,
723 `c2` tinyint NOT NULL,
724 `c3` int DEFAULT NULL,
725 `c4` varchar(10) NOT NULL,
726 PRIMARY KEY (`c1`,`c2`)
727 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
728 DROP TABLE t1;
729 SHOW TABLES;
730 Tables_in_test
731 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
732 SHOW TABLES;
733 Tables_in_test
734 t1
735 SHOW CREATE TABLE t1;
736 Table Create Table
737 t1 CREATE TABLE `t1` (
738 `c1` decimal(10,0) NOT NULL,
739 `c2` tinyint NOT NULL,
740 `c3` int DEFAULT NULL,
741 `c4` varchar(10) NOT NULL
742 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
743 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
744 SHOW TABLES;
745 Tables_in_test
746 t1
747 SHOW CREATE TABLE t1;
748 Table Create Table
749 t1 CREATE TABLE `t1` (
750 `c1` decimal(10,0) NOT NULL,
751 `c2` tinyint NOT NULL,
752 `c3` int DEFAULT NULL,
753 `c4` varchar(10) NOT NULL,
754 PRIMARY KEY (`c1`,`c2`)
755 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
756 DROP TABLE t1;
757 SHOW TABLES;
758 Tables_in_test
759 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
760 SHOW TABLES;
761 Tables_in_test
762 t1
763 SHOW CREATE TABLE t1;
764 Table Create Table
765 t1 CREATE TABLE `t1` (
766 `c1` decimal(10,0) NOT NULL,
767 `c2` tinyint NOT NULL,
768 `c3` int DEFAULT NULL,
769 `c4` varchar(10) NOT NULL
770 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
771 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
772 SHOW TABLES;
773 Tables_in_test
774 t1
775 SHOW CREATE TABLE t1;
776 Table Create Table
777 t1 CREATE TABLE `t1` (
778 `c1` decimal(10,0) NOT NULL,
779 `c2` tinyint NOT NULL,
780 `c3` int DEFAULT NULL,
781 `c4` varchar(10) NOT NULL,
782 PRIMARY KEY (`c1`,`c2`)
783 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
784 DROP TABLE t1;
785 SHOW TABLES;
786 Tables_in_test
787 CREATE TABLE t1(c1 DATE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
788 SHOW TABLES;
789 Tables_in_test
790 t1
791 SHOW CREATE TABLE t1;
792 Table Create Table
793 t1 CREATE TABLE `t1` (
794 `c1` date NOT NULL,
795 `c2` tinyint NOT NULL,
796 `c3` int DEFAULT NULL,
797 `c4` varchar(10) NOT NULL
798 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
799 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
800 SHOW TABLES;
801 Tables_in_test
802 t1
803 SHOW CREATE TABLE t1;
804 Table Create Table
805 t1 CREATE TABLE `t1` (
806 `c1` date NOT NULL,
807 `c2` tinyint NOT NULL,
808 `c3` int DEFAULT NULL,
809 `c4` varchar(10) NOT NULL,
810 PRIMARY KEY (`c1`,`c2`)
811 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
812 DROP TABLE t1;
813 SHOW TABLES;
814 Tables_in_test
815 CREATE TABLE t1(c1 TIME NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
816 SHOW TABLES;
817 Tables_in_test
818 t1
819 SHOW CREATE TABLE t1;
820 Table Create Table
821 t1 CREATE TABLE `t1` (
822 `c1` time NOT NULL,
823 `c2` tinyint NOT NULL,
824 `c3` int DEFAULT NULL,
825 `c4` varchar(10) NOT NULL
826 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
827 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
828 SHOW TABLES;
829 Tables_in_test
830 t1
831 SHOW CREATE TABLE t1;
832 Table Create Table
833 t1 CREATE TABLE `t1` (
834 `c1` time NOT NULL,
835 `c2` tinyint NOT NULL,
836 `c3` int DEFAULT NULL,
837 `c4` varchar(10) NOT NULL,
838 PRIMARY KEY (`c1`,`c2`)
839 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
840 DROP TABLE t1;
841 SHOW TABLES;
842 Tables_in_test
843 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
844 SHOW TABLES;
845 Tables_in_test
846 t1
847 SHOW CREATE TABLE t1;
848 Table Create Table
849 t1 CREATE TABLE `t1` (
850 `c1` timestamp NOT NULL,
851 `c2` tinyint NOT NULL,
852 `c3` int DEFAULT NULL,
853 `c4` varchar(10) NOT NULL
854 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
855 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
856 SHOW TABLES;
857 Tables_in_test
858 t1
859 SHOW CREATE TABLE t1;
860 Table Create Table
861 t1 CREATE TABLE `t1` (
862 `c1` timestamp NOT NULL,
863 `c2` tinyint NOT NULL,
864 `c3` int DEFAULT NULL,
865 `c4` varchar(10) NOT NULL,
866 PRIMARY KEY (`c1`,`c2`)
867 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
868 DROP TABLE t1;
869 SHOW TABLES;
870 Tables_in_test
871 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
872 SHOW TABLES;
873 Tables_in_test
874 t1
875 SHOW CREATE TABLE t1;
876 Table Create Table
877 t1 CREATE TABLE `t1` (
878 `c1` year NOT NULL,
879 `c2` tinyint NOT NULL,
880 `c3` int DEFAULT NULL,
881 `c4` varchar(10) NOT NULL
882 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
883 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
884 SHOW TABLES;
885 Tables_in_test
886 t1
887 SHOW CREATE TABLE t1;
888 Table Create Table
889 t1 CREATE TABLE `t1` (
890 `c1` year NOT NULL,
891 `c2` tinyint NOT NULL,
892 `c3` int DEFAULT NULL,
893 `c4` varchar(10) NOT NULL,
894 PRIMARY KEY (`c1`,`c2`)
895 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
896 DROP TABLE t1;
897 SHOW TABLES;
898 Tables_in_test
899 CREATE TABLE t1(c1 BIT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
900 SHOW TABLES;
901 Tables_in_test
902 t1
903 SHOW CREATE TABLE t1;
904 Table Create Table
905 t1 CREATE TABLE `t1` (
906 `c1` bit(1) NOT NULL,
907 `c2` smallint NOT NULL,
908 `c3` int DEFAULT NULL,
909 `c4` varchar(10) NOT NULL
910 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
911 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
912 SHOW TABLES;
913 Tables_in_test
914 t1
915 SHOW CREATE TABLE t1;
916 Table Create Table
917 t1 CREATE TABLE `t1` (
918 `c1` bit(1) NOT NULL,
919 `c2` smallint NOT NULL,
920 `c3` int DEFAULT NULL,
921 `c4` varchar(10) NOT NULL,
922 PRIMARY KEY (`c1`,`c2`)
923 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
924 DROP TABLE t1;
925 SHOW TABLES;
926 Tables_in_test
927 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
928 SHOW TABLES;
929 Tables_in_test
930 t1
931 SHOW CREATE TABLE t1;
932 Table Create Table
933 t1 CREATE TABLE `t1` (
934 `c1` tinyint NOT NULL,
935 `c2` smallint NOT NULL,
936 `c3` int DEFAULT NULL,
937 `c4` varchar(10) NOT NULL
938 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
939 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
940 SHOW TABLES;
941 Tables_in_test
942 t1
943 SHOW CREATE TABLE t1;
944 Table Create Table
945 t1 CREATE TABLE `t1` (
946 `c1` tinyint NOT NULL,
947 `c2` smallint NOT NULL,
948 `c3` int DEFAULT NULL,
949 `c4` varchar(10) NOT NULL,
950 PRIMARY KEY (`c1`,`c2`)
951 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
952 DROP TABLE t1;
953 SHOW TABLES;
954 Tables_in_test
955 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
956 SHOW TABLES;
957 Tables_in_test
958 t1
959 SHOW CREATE TABLE t1;
960 Table Create Table
961 t1 CREATE TABLE `t1` (
962 `c1` smallint NOT NULL,
963 `c2` smallint NOT NULL,
964 `c3` int DEFAULT NULL,
965 `c4` varchar(10) NOT NULL
966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
967 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
968 SHOW TABLES;
969 Tables_in_test
970 t1
971 SHOW CREATE TABLE t1;
972 Table Create Table
973 t1 CREATE TABLE `t1` (
974 `c1` smallint NOT NULL,
975 `c2` smallint NOT NULL,
976 `c3` int DEFAULT NULL,
977 `c4` varchar(10) NOT NULL,
978 PRIMARY KEY (`c1`,`c2`)
979 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
980 DROP TABLE t1;
981 SHOW TABLES;
982 Tables_in_test
983 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
984 SHOW TABLES;
985 Tables_in_test
986 t1
987 SHOW CREATE TABLE t1;
988 Table Create Table
989 t1 CREATE TABLE `t1` (
990 `c1` mediumint NOT NULL,
991 `c2` smallint NOT NULL,
992 `c3` int DEFAULT NULL,
993 `c4` varchar(10) NOT NULL
994 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
995 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
996 SHOW TABLES;
997 Tables_in_test
998 t1
999 SHOW CREATE TABLE t1;
1000 Table Create Table
1001 t1 CREATE TABLE `t1` (
1002 `c1` mediumint NOT NULL,
1003 `c2` smallint NOT NULL,
1004 `c3` int DEFAULT NULL,
1005 `c4` varchar(10) NOT NULL,
1006 PRIMARY KEY (`c1`,`c2`)
1007 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1008 DROP TABLE t1;
1009 SHOW TABLES;
1010 Tables_in_test
1011 CREATE TABLE t1(c1 INT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1012 SHOW TABLES;
1013 Tables_in_test
1014 t1
1015 SHOW CREATE TABLE t1;
1016 Table Create Table
1017 t1 CREATE TABLE `t1` (
1018 `c1` int NOT NULL,
1019 `c2` smallint NOT NULL,
1020 `c3` int DEFAULT NULL,
1021 `c4` varchar(10) NOT NULL
1022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1023 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1024 SHOW TABLES;
1025 Tables_in_test
1026 t1
1027 SHOW CREATE TABLE t1;
1028 Table Create Table
1029 t1 CREATE TABLE `t1` (
1030 `c1` int NOT NULL,
1031 `c2` smallint NOT NULL,
1032 `c3` int DEFAULT NULL,
1033 `c4` varchar(10) NOT NULL,
1034 PRIMARY KEY (`c1`,`c2`)
1035 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1036 DROP TABLE t1;
1037 SHOW TABLES;
1038 Tables_in_test
1039 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1040 SHOW TABLES;
1041 Tables_in_test
1042 t1
1043 SHOW CREATE TABLE t1;
1044 Table Create Table
1045 t1 CREATE TABLE `t1` (
1046 `c1` int NOT NULL,
1047 `c2` smallint NOT NULL,
1048 `c3` int DEFAULT NULL,
1049 `c4` varchar(10) NOT NULL
1050 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1051 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1052 SHOW TABLES;
1053 Tables_in_test
1054 t1
1055 SHOW CREATE TABLE t1;
1056 Table Create Table
1057 t1 CREATE TABLE `t1` (
1058 `c1` int NOT NULL,
1059 `c2` smallint NOT NULL,
1060 `c3` int DEFAULT NULL,
1061 `c4` varchar(10) NOT NULL,
1062 PRIMARY KEY (`c1`,`c2`)
1063 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1064 DROP TABLE t1;
1065 SHOW TABLES;
1066 Tables_in_test
1067 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1068 SHOW TABLES;
1069 Tables_in_test
1070 t1
1071 SHOW CREATE TABLE t1;
1072 Table Create Table
1073 t1 CREATE TABLE `t1` (
1074 `c1` bigint NOT NULL,
1075 `c2` smallint NOT NULL,
1076 `c3` int DEFAULT NULL,
1077 `c4` varchar(10) NOT NULL
1078 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1079 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1080 SHOW TABLES;
1081 Tables_in_test
1082 t1
1083 SHOW CREATE TABLE t1;
1084 Table Create Table
1085 t1 CREATE TABLE `t1` (
1086 `c1` bigint NOT NULL,
1087 `c2` smallint NOT NULL,
1088 `c3` int DEFAULT NULL,
1089 `c4` varchar(10) NOT NULL,
1090 PRIMARY KEY (`c1`,`c2`)
1091 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1092 DROP TABLE t1;
1093 SHOW TABLES;
1094 Tables_in_test
1095 CREATE TABLE t1(c1 REAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1096 SHOW TABLES;
1097 Tables_in_test
1098 t1
1099 SHOW CREATE TABLE t1;
1100 Table Create Table
1101 t1 CREATE TABLE `t1` (
1102 `c1` double NOT NULL,
1103 `c2` smallint NOT NULL,
1104 `c3` int DEFAULT NULL,
1105 `c4` varchar(10) NOT NULL
1106 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1107 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1108 SHOW TABLES;
1109 Tables_in_test
1110 t1
1111 SHOW CREATE TABLE t1;
1112 Table Create Table
1113 t1 CREATE TABLE `t1` (
1114 `c1` double NOT NULL,
1115 `c2` smallint NOT NULL,
1116 `c3` int DEFAULT NULL,
1117 `c4` varchar(10) NOT NULL,
1118 PRIMARY KEY (`c1`,`c2`)
1119 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1120 DROP TABLE t1;
1121 SHOW TABLES;
1122 Tables_in_test
1123 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1124 SHOW TABLES;
1125 Tables_in_test
1126 t1
1127 SHOW CREATE TABLE t1;
1128 Table Create Table
1129 t1 CREATE TABLE `t1` (
1130 `c1` double NOT NULL,
1131 `c2` smallint NOT NULL,
1132 `c3` int DEFAULT NULL,
1133 `c4` varchar(10) NOT NULL
1134 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1135 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1136 SHOW TABLES;
1137 Tables_in_test
1138 t1
1139 SHOW CREATE TABLE t1;
1140 Table Create Table
1141 t1 CREATE TABLE `t1` (
1142 `c1` double NOT NULL,
1143 `c2` smallint NOT NULL,
1144 `c3` int DEFAULT NULL,
1145 `c4` varchar(10) NOT NULL,
1146 PRIMARY KEY (`c1`,`c2`)
1147 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1148 DROP TABLE t1;
1149 SHOW TABLES;
1150 Tables_in_test
1151 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1152 SHOW TABLES;
1153 Tables_in_test
1154 t1
1155 SHOW CREATE TABLE t1;
1156 Table Create Table
1157 t1 CREATE TABLE `t1` (
1158 `c1` float NOT NULL,
1159 `c2` smallint NOT NULL,
1160 `c3` int DEFAULT NULL,
1161 `c4` varchar(10) NOT NULL
1162 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1163 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1164 SHOW TABLES;
1165 Tables_in_test
1166 t1
1167 SHOW CREATE TABLE t1;
1168 Table Create Table
1169 t1 CREATE TABLE `t1` (
1170 `c1` float NOT NULL,
1171 `c2` smallint NOT NULL,
1172 `c3` int DEFAULT NULL,
1173 `c4` varchar(10) NOT NULL,
1174 PRIMARY KEY (`c1`,`c2`)
1175 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1176 DROP TABLE t1;
1177 SHOW TABLES;
1178 Tables_in_test
1179 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1180 SHOW TABLES;
1181 Tables_in_test
1182 t1
1183 SHOW CREATE TABLE t1;
1184 Table Create Table
1185 t1 CREATE TABLE `t1` (
1186 `c1` decimal(10,0) NOT NULL,
1187 `c2` smallint NOT NULL,
1188 `c3` int DEFAULT NULL,
1189 `c4` varchar(10) NOT NULL
1190 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1191 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1192 SHOW TABLES;
1193 Tables_in_test
1194 t1
1195 SHOW CREATE TABLE t1;
1196 Table Create Table
1197 t1 CREATE TABLE `t1` (
1198 `c1` decimal(10,0) NOT NULL,
1199 `c2` smallint NOT NULL,
1200 `c3` int DEFAULT NULL,
1201 `c4` varchar(10) NOT NULL,
1202 PRIMARY KEY (`c1`,`c2`)
1203 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1204 DROP TABLE t1;
1205 SHOW TABLES;
1206 Tables_in_test
1207 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1208 SHOW TABLES;
1209 Tables_in_test
1210 t1
1211 SHOW CREATE TABLE t1;
1212 Table Create Table
1213 t1 CREATE TABLE `t1` (
1214 `c1` decimal(10,0) NOT NULL,
1215 `c2` smallint NOT NULL,
1216 `c3` int DEFAULT NULL,
1217 `c4` varchar(10) NOT NULL
1218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1219 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1220 SHOW TABLES;
1221 Tables_in_test
1222 t1
1223 SHOW CREATE TABLE t1;
1224 Table Create Table
1225 t1 CREATE TABLE `t1` (
1226 `c1` decimal(10,0) NOT NULL,
1227 `c2` smallint NOT NULL,
1228 `c3` int DEFAULT NULL,
1229 `c4` varchar(10) NOT NULL,
1230 PRIMARY KEY (`c1`,`c2`)
1231 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1232 DROP TABLE t1;
1233 SHOW TABLES;
1234 Tables_in_test
1235 CREATE TABLE t1(c1 DATE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1236 SHOW TABLES;
1237 Tables_in_test
1238 t1
1239 SHOW CREATE TABLE t1;
1240 Table Create Table
1241 t1 CREATE TABLE `t1` (
1242 `c1` date NOT NULL,
1243 `c2` smallint NOT NULL,
1244 `c3` int DEFAULT NULL,
1245 `c4` varchar(10) NOT NULL
1246 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1247 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1248 SHOW TABLES;
1249 Tables_in_test
1250 t1
1251 SHOW CREATE TABLE t1;
1252 Table Create Table
1253 t1 CREATE TABLE `t1` (
1254 `c1` date NOT NULL,
1255 `c2` smallint NOT NULL,
1256 `c3` int DEFAULT NULL,
1257 `c4` varchar(10) NOT NULL,
1258 PRIMARY KEY (`c1`,`c2`)
1259 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1260 DROP TABLE t1;
1261 SHOW TABLES;
1262 Tables_in_test
1263 CREATE TABLE t1(c1 TIME NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1264 SHOW TABLES;
1265 Tables_in_test
1266 t1
1267 SHOW CREATE TABLE t1;
1268 Table Create Table
1269 t1 CREATE TABLE `t1` (
1270 `c1` time NOT NULL,
1271 `c2` smallint NOT NULL,
1272 `c3` int DEFAULT NULL,
1273 `c4` varchar(10) NOT NULL
1274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1275 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1276 SHOW TABLES;
1277 Tables_in_test
1278 t1
1279 SHOW CREATE TABLE t1;
1280 Table Create Table
1281 t1 CREATE TABLE `t1` (
1282 `c1` time NOT NULL,
1283 `c2` smallint NOT NULL,
1284 `c3` int DEFAULT NULL,
1285 `c4` varchar(10) NOT NULL,
1286 PRIMARY KEY (`c1`,`c2`)
1287 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1288 DROP TABLE t1;
1289 SHOW TABLES;
1290 Tables_in_test
1291 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1292 SHOW TABLES;
1293 Tables_in_test
1294 t1
1295 SHOW CREATE TABLE t1;
1296 Table Create Table
1297 t1 CREATE TABLE `t1` (
1298 `c1` timestamp NOT NULL,
1299 `c2` smallint NOT NULL,
1300 `c3` int DEFAULT NULL,
1301 `c4` varchar(10) NOT NULL
1302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1303 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1304 SHOW TABLES;
1305 Tables_in_test
1306 t1
1307 SHOW CREATE TABLE t1;
1308 Table Create Table
1309 t1 CREATE TABLE `t1` (
1310 `c1` timestamp NOT NULL,
1311 `c2` smallint NOT NULL,
1312 `c3` int DEFAULT NULL,
1313 `c4` varchar(10) NOT NULL,
1314 PRIMARY KEY (`c1`,`c2`)
1315 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1316 DROP TABLE t1;
1317 SHOW TABLES;
1318 Tables_in_test
1319 CREATE TABLE t1(c1 YEAR NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1320 SHOW TABLES;
1321 Tables_in_test
1322 t1
1323 SHOW CREATE TABLE t1;
1324 Table Create Table
1325 t1 CREATE TABLE `t1` (
1326 `c1` year NOT NULL,
1327 `c2` smallint NOT NULL,
1328 `c3` int DEFAULT NULL,
1329 `c4` varchar(10) NOT NULL
1330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1331 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1332 SHOW TABLES;
1333 Tables_in_test
1334 t1
1335 SHOW CREATE TABLE t1;
1336 Table Create Table
1337 t1 CREATE TABLE `t1` (
1338 `c1` year NOT NULL,
1339 `c2` smallint NOT NULL,
1340 `c3` int DEFAULT NULL,
1341 `c4` varchar(10) NOT NULL,
1342 PRIMARY KEY (`c1`,`c2`)
1343 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1344 DROP TABLE t1;
1345 SHOW TABLES;
1346 Tables_in_test
1347 CREATE TABLE t1(c1 BIT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1348 SHOW TABLES;
1349 Tables_in_test
1350 t1
1351 SHOW CREATE TABLE t1;
1352 Table Create Table
1353 t1 CREATE TABLE `t1` (
1354 `c1` bit(1) NOT NULL,
1355 `c2` mediumint NOT NULL,
1356 `c3` int DEFAULT NULL,
1357 `c4` varchar(10) NOT NULL
1358 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1359 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1360 SHOW TABLES;
1361 Tables_in_test
1362 t1
1363 SHOW CREATE TABLE t1;
1364 Table Create Table
1365 t1 CREATE TABLE `t1` (
1366 `c1` bit(1) NOT NULL,
1367 `c2` mediumint NOT NULL,
1368 `c3` int DEFAULT NULL,
1369 `c4` varchar(10) NOT NULL,
1370 PRIMARY KEY (`c1`,`c2`)
1371 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1372 DROP TABLE t1;
1373 SHOW TABLES;
1374 Tables_in_test
1375 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1376 SHOW TABLES;
1377 Tables_in_test
1378 t1
1379 SHOW CREATE TABLE t1;
1380 Table Create Table
1381 t1 CREATE TABLE `t1` (
1382 `c1` tinyint NOT NULL,
1383 `c2` mediumint NOT NULL,
1384 `c3` int DEFAULT NULL,
1385 `c4` varchar(10) NOT NULL
1386 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1387 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1388 SHOW TABLES;
1389 Tables_in_test
1390 t1
1391 SHOW CREATE TABLE t1;
1392 Table Create Table
1393 t1 CREATE TABLE `t1` (
1394 `c1` tinyint NOT NULL,
1395 `c2` mediumint NOT NULL,
1396 `c3` int DEFAULT NULL,
1397 `c4` varchar(10) NOT NULL,
1398 PRIMARY KEY (`c1`,`c2`)
1399 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1400 DROP TABLE t1;
1401 SHOW TABLES;
1402 Tables_in_test
1403 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1404 SHOW TABLES;
1405 Tables_in_test
1406 t1
1407 SHOW CREATE TABLE t1;
1408 Table Create Table
1409 t1 CREATE TABLE `t1` (
1410 `c1` smallint NOT NULL,
1411 `c2` mediumint NOT NULL,
1412 `c3` int DEFAULT NULL,
1413 `c4` varchar(10) NOT NULL
1414 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1415 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1416 SHOW TABLES;
1417 Tables_in_test
1418 t1
1419 SHOW CREATE TABLE t1;
1420 Table Create Table
1421 t1 CREATE TABLE `t1` (
1422 `c1` smallint NOT NULL,
1423 `c2` mediumint NOT NULL,
1424 `c3` int DEFAULT NULL,
1425 `c4` varchar(10) NOT NULL,
1426 PRIMARY KEY (`c1`,`c2`)
1427 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1428 DROP TABLE t1;
1429 SHOW TABLES;
1430 Tables_in_test
1431 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1432 SHOW TABLES;
1433 Tables_in_test
1434 t1
1435 SHOW CREATE TABLE t1;
1436 Table Create Table
1437 t1 CREATE TABLE `t1` (
1438 `c1` mediumint NOT NULL,
1439 `c2` mediumint NOT NULL,
1440 `c3` int DEFAULT NULL,
1441 `c4` varchar(10) NOT NULL
1442 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1443 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1444 SHOW TABLES;
1445 Tables_in_test
1446 t1
1447 SHOW CREATE TABLE t1;
1448 Table Create Table
1449 t1 CREATE TABLE `t1` (
1450 `c1` mediumint NOT NULL,
1451 `c2` mediumint NOT NULL,
1452 `c3` int DEFAULT NULL,
1453 `c4` varchar(10) NOT NULL,
1454 PRIMARY KEY (`c1`,`c2`)
1455 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1456 DROP TABLE t1;
1457 SHOW TABLES;
1458 Tables_in_test
1459 CREATE TABLE t1(c1 INT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1460 SHOW TABLES;
1461 Tables_in_test
1462 t1
1463 SHOW CREATE TABLE t1;
1464 Table Create Table
1465 t1 CREATE TABLE `t1` (
1466 `c1` int NOT NULL,
1467 `c2` mediumint NOT NULL,
1468 `c3` int DEFAULT NULL,
1469 `c4` varchar(10) NOT NULL
1470 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1471 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1472 SHOW TABLES;
1473 Tables_in_test
1474 t1
1475 SHOW CREATE TABLE t1;
1476 Table Create Table
1477 t1 CREATE TABLE `t1` (
1478 `c1` int NOT NULL,
1479 `c2` mediumint NOT NULL,
1480 `c3` int DEFAULT NULL,
1481 `c4` varchar(10) NOT NULL,
1482 PRIMARY KEY (`c1`,`c2`)
1483 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1484 DROP TABLE t1;
1485 SHOW TABLES;
1486 Tables_in_test
1487 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1488 SHOW TABLES;
1489 Tables_in_test
1490 t1
1491 SHOW CREATE TABLE t1;
1492 Table Create Table
1493 t1 CREATE TABLE `t1` (
1494 `c1` int NOT NULL,
1495 `c2` mediumint NOT NULL,
1496 `c3` int DEFAULT NULL,
1497 `c4` varchar(10) NOT NULL
1498 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1499 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1500 SHOW TABLES;
1501 Tables_in_test
1502 t1
1503 SHOW CREATE TABLE t1;
1504 Table Create Table
1505 t1 CREATE TABLE `t1` (
1506 `c1` int NOT NULL,
1507 `c2` mediumint NOT NULL,
1508 `c3` int DEFAULT NULL,
1509 `c4` varchar(10) NOT NULL,
1510 PRIMARY KEY (`c1`,`c2`)
1511 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1512 DROP TABLE t1;
1513 SHOW TABLES;
1514 Tables_in_test
1515 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1516 SHOW TABLES;
1517 Tables_in_test
1518 t1
1519 SHOW CREATE TABLE t1;
1520 Table Create Table
1521 t1 CREATE TABLE `t1` (
1522 `c1` bigint NOT NULL,
1523 `c2` mediumint NOT NULL,
1524 `c3` int DEFAULT NULL,
1525 `c4` varchar(10) NOT NULL
1526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1527 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1528 SHOW TABLES;
1529 Tables_in_test
1530 t1
1531 SHOW CREATE TABLE t1;
1532 Table Create Table
1533 t1 CREATE TABLE `t1` (
1534 `c1` bigint NOT NULL,
1535 `c2` mediumint NOT NULL,
1536 `c3` int DEFAULT NULL,
1537 `c4` varchar(10) NOT NULL,
1538 PRIMARY KEY (`c1`,`c2`)
1539 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1540 DROP TABLE t1;
1541 SHOW TABLES;
1542 Tables_in_test
1543 CREATE TABLE t1(c1 REAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1544 SHOW TABLES;
1545 Tables_in_test
1546 t1
1547 SHOW CREATE TABLE t1;
1548 Table Create Table
1549 t1 CREATE TABLE `t1` (
1550 `c1` double NOT NULL,
1551 `c2` mediumint NOT NULL,
1552 `c3` int DEFAULT NULL,
1553 `c4` varchar(10) NOT NULL
1554 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1555 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1556 SHOW TABLES;
1557 Tables_in_test
1558 t1
1559 SHOW CREATE TABLE t1;
1560 Table Create Table
1561 t1 CREATE TABLE `t1` (
1562 `c1` double NOT NULL,
1563 `c2` mediumint NOT NULL,
1564 `c3` int DEFAULT NULL,
1565 `c4` varchar(10) NOT NULL,
1566 PRIMARY KEY (`c1`,`c2`)
1567 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1568 DROP TABLE t1;
1569 SHOW TABLES;
1570 Tables_in_test
1571 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1572 SHOW TABLES;
1573 Tables_in_test
1574 t1
1575 SHOW CREATE TABLE t1;
1576 Table Create Table
1577 t1 CREATE TABLE `t1` (
1578 `c1` double NOT NULL,
1579 `c2` mediumint NOT NULL,
1580 `c3` int DEFAULT NULL,
1581 `c4` varchar(10) NOT NULL
1582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1584 SHOW TABLES;
1585 Tables_in_test
1586 t1
1587 SHOW CREATE TABLE t1;
1588 Table Create Table
1589 t1 CREATE TABLE `t1` (
1590 `c1` double NOT NULL,
1591 `c2` mediumint NOT NULL,
1592 `c3` int DEFAULT NULL,
1593 `c4` varchar(10) NOT NULL,
1594 PRIMARY KEY (`c1`,`c2`)
1595 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1596 DROP TABLE t1;
1597 SHOW TABLES;
1598 Tables_in_test
1599 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1600 SHOW TABLES;
1601 Tables_in_test
1602 t1
1603 SHOW CREATE TABLE t1;
1604 Table Create Table
1605 t1 CREATE TABLE `t1` (
1606 `c1` float NOT NULL,
1607 `c2` mediumint NOT NULL,
1608 `c3` int DEFAULT NULL,
1609 `c4` varchar(10) NOT NULL
1610 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1611 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1612 SHOW TABLES;
1613 Tables_in_test
1614 t1
1615 SHOW CREATE TABLE t1;
1616 Table Create Table
1617 t1 CREATE TABLE `t1` (
1618 `c1` float NOT NULL,
1619 `c2` mediumint NOT NULL,
1620 `c3` int DEFAULT NULL,
1621 `c4` varchar(10) NOT NULL,
1622 PRIMARY KEY (`c1`,`c2`)
1623 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1624 DROP TABLE t1;
1625 SHOW TABLES;
1626 Tables_in_test
1627 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1628 SHOW TABLES;
1629 Tables_in_test
1630 t1
1631 SHOW CREATE TABLE t1;
1632 Table Create Table
1633 t1 CREATE TABLE `t1` (
1634 `c1` decimal(10,0) NOT NULL,
1635 `c2` mediumint NOT NULL,
1636 `c3` int DEFAULT NULL,
1637 `c4` varchar(10) NOT NULL
1638 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1639 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1640 SHOW TABLES;
1641 Tables_in_test
1642 t1
1643 SHOW CREATE TABLE t1;
1644 Table Create Table
1645 t1 CREATE TABLE `t1` (
1646 `c1` decimal(10,0) NOT NULL,
1647 `c2` mediumint NOT NULL,
1648 `c3` int DEFAULT NULL,
1649 `c4` varchar(10) NOT NULL,
1650 PRIMARY KEY (`c1`,`c2`)
1651 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1652 DROP TABLE t1;
1653 SHOW TABLES;
1654 Tables_in_test
1655 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1656 SHOW TABLES;
1657 Tables_in_test
1658 t1
1659 SHOW CREATE TABLE t1;
1660 Table Create Table
1661 t1 CREATE TABLE `t1` (
1662 `c1` decimal(10,0) NOT NULL,
1663 `c2` mediumint NOT NULL,
1664 `c3` int DEFAULT NULL,
1665 `c4` varchar(10) NOT NULL
1666 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1667 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1668 SHOW TABLES;
1669 Tables_in_test
1670 t1
1671 SHOW CREATE TABLE t1;
1672 Table Create Table
1673 t1 CREATE TABLE `t1` (
1674 `c1` decimal(10,0) NOT NULL,
1675 `c2` mediumint NOT NULL,
1676 `c3` int DEFAULT NULL,
1677 `c4` varchar(10) NOT NULL,
1678 PRIMARY KEY (`c1`,`c2`)
1679 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1680 DROP TABLE t1;
1681 SHOW TABLES;
1682 Tables_in_test
1683 CREATE TABLE t1(c1 DATE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1684 SHOW TABLES;
1685 Tables_in_test
1686 t1
1687 SHOW CREATE TABLE t1;
1688 Table Create Table
1689 t1 CREATE TABLE `t1` (
1690 `c1` date NOT NULL,
1691 `c2` mediumint NOT NULL,
1692 `c3` int DEFAULT NULL,
1693 `c4` varchar(10) NOT NULL
1694 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1695 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1696 SHOW TABLES;
1697 Tables_in_test
1698 t1
1699 SHOW CREATE TABLE t1;
1700 Table Create Table
1701 t1 CREATE TABLE `t1` (
1702 `c1` date NOT NULL,
1703 `c2` mediumint NOT NULL,
1704 `c3` int DEFAULT NULL,
1705 `c4` varchar(10) NOT NULL,
1706 PRIMARY KEY (`c1`,`c2`)
1707 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1708 DROP TABLE t1;
1709 SHOW TABLES;
1710 Tables_in_test
1711 CREATE TABLE t1(c1 TIME NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1712 SHOW TABLES;
1713 Tables_in_test
1714 t1
1715 SHOW CREATE TABLE t1;
1716 Table Create Table
1717 t1 CREATE TABLE `t1` (
1718 `c1` time NOT NULL,
1719 `c2` mediumint NOT NULL,
1720 `c3` int DEFAULT NULL,
1721 `c4` varchar(10) NOT NULL
1722 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1723 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1724 SHOW TABLES;
1725 Tables_in_test
1726 t1
1727 SHOW CREATE TABLE t1;
1728 Table Create Table
1729 t1 CREATE TABLE `t1` (
1730 `c1` time NOT NULL,
1731 `c2` mediumint NOT NULL,
1732 `c3` int DEFAULT NULL,
1733 `c4` varchar(10) NOT NULL,
1734 PRIMARY KEY (`c1`,`c2`)
1735 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1736 DROP TABLE t1;
1737 SHOW TABLES;
1738 Tables_in_test
1739 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1740 SHOW TABLES;
1741 Tables_in_test
1742 t1
1743 SHOW CREATE TABLE t1;
1744 Table Create Table
1745 t1 CREATE TABLE `t1` (
1746 `c1` timestamp NOT NULL,
1747 `c2` mediumint NOT NULL,
1748 `c3` int DEFAULT NULL,
1749 `c4` varchar(10) NOT NULL
1750 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1751 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1752 SHOW TABLES;
1753 Tables_in_test
1754 t1
1755 SHOW CREATE TABLE t1;
1756 Table Create Table
1757 t1 CREATE TABLE `t1` (
1758 `c1` timestamp NOT NULL,
1759 `c2` mediumint NOT NULL,
1760 `c3` int DEFAULT NULL,
1761 `c4` varchar(10) NOT NULL,
1762 PRIMARY KEY (`c1`,`c2`)
1763 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1764 DROP TABLE t1;
1765 SHOW TABLES;
1766 Tables_in_test
1767 CREATE TABLE t1(c1 YEAR NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1768 SHOW TABLES;
1769 Tables_in_test
1770 t1
1771 SHOW CREATE TABLE t1;
1772 Table Create Table
1773 t1 CREATE TABLE `t1` (
1774 `c1` year NOT NULL,
1775 `c2` mediumint NOT NULL,
1776 `c3` int DEFAULT NULL,
1777 `c4` varchar(10) NOT NULL
1778 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1779 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1780 SHOW TABLES;
1781 Tables_in_test
1782 t1
1783 SHOW CREATE TABLE t1;
1784 Table Create Table
1785 t1 CREATE TABLE `t1` (
1786 `c1` year NOT NULL,
1787 `c2` mediumint NOT NULL,
1788 `c3` int DEFAULT NULL,
1789 `c4` varchar(10) NOT NULL,
1790 PRIMARY KEY (`c1`,`c2`)
1791 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1792 DROP TABLE t1;
1793 SHOW TABLES;
1794 Tables_in_test
1795 CREATE TABLE t1(c1 BIT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1796 SHOW TABLES;
1797 Tables_in_test
1798 t1
1799 SHOW CREATE TABLE t1;
1800 Table Create Table
1801 t1 CREATE TABLE `t1` (
1802 `c1` bit(1) NOT NULL,
1803 `c2` int NOT NULL,
1804 `c3` int DEFAULT NULL,
1805 `c4` varchar(10) NOT NULL
1806 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1807 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1808 SHOW TABLES;
1809 Tables_in_test
1810 t1
1811 SHOW CREATE TABLE t1;
1812 Table Create Table
1813 t1 CREATE TABLE `t1` (
1814 `c1` bit(1) NOT NULL,
1815 `c2` int NOT NULL,
1816 `c3` int DEFAULT NULL,
1817 `c4` varchar(10) NOT NULL,
1818 PRIMARY KEY (`c1`,`c2`)
1819 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1820 DROP TABLE t1;
1821 SHOW TABLES;
1822 Tables_in_test
1823 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1824 SHOW TABLES;
1825 Tables_in_test
1826 t1
1827 SHOW CREATE TABLE t1;
1828 Table Create Table
1829 t1 CREATE TABLE `t1` (
1830 `c1` tinyint NOT NULL,
1831 `c2` int NOT NULL,
1832 `c3` int DEFAULT NULL,
1833 `c4` varchar(10) NOT NULL
1834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1835 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1836 SHOW TABLES;
1837 Tables_in_test
1838 t1
1839 SHOW CREATE TABLE t1;
1840 Table Create Table
1841 t1 CREATE TABLE `t1` (
1842 `c1` tinyint NOT NULL,
1843 `c2` int NOT NULL,
1844 `c3` int DEFAULT NULL,
1845 `c4` varchar(10) NOT NULL,
1846 PRIMARY KEY (`c1`,`c2`)
1847 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1848 DROP TABLE t1;
1849 SHOW TABLES;
1850 Tables_in_test
1851 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1852 SHOW TABLES;
1853 Tables_in_test
1854 t1
1855 SHOW CREATE TABLE t1;
1856 Table Create Table
1857 t1 CREATE TABLE `t1` (
1858 `c1` smallint NOT NULL,
1859 `c2` int NOT NULL,
1860 `c3` int DEFAULT NULL,
1861 `c4` varchar(10) NOT NULL
1862 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1863 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1864 SHOW TABLES;
1865 Tables_in_test
1866 t1
1867 SHOW CREATE TABLE t1;
1868 Table Create Table
1869 t1 CREATE TABLE `t1` (
1870 `c1` smallint NOT NULL,
1871 `c2` int NOT NULL,
1872 `c3` int DEFAULT NULL,
1873 `c4` varchar(10) NOT NULL,
1874 PRIMARY KEY (`c1`,`c2`)
1875 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1876 DROP TABLE t1;
1877 SHOW TABLES;
1878 Tables_in_test
1879 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1880 SHOW TABLES;
1881 Tables_in_test
1882 t1
1883 SHOW CREATE TABLE t1;
1884 Table Create Table
1885 t1 CREATE TABLE `t1` (
1886 `c1` mediumint NOT NULL,
1887 `c2` int NOT NULL,
1888 `c3` int DEFAULT NULL,
1889 `c4` varchar(10) NOT NULL
1890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1891 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1892 SHOW TABLES;
1893 Tables_in_test
1894 t1
1895 SHOW CREATE TABLE t1;
1896 Table Create Table
1897 t1 CREATE TABLE `t1` (
1898 `c1` mediumint NOT NULL,
1899 `c2` int NOT NULL,
1900 `c3` int DEFAULT NULL,
1901 `c4` varchar(10) NOT NULL,
1902 PRIMARY KEY (`c1`,`c2`)
1903 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1904 DROP TABLE t1;
1905 SHOW TABLES;
1906 Tables_in_test
1907 CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1908 SHOW TABLES;
1909 Tables_in_test
1910 t1
1911 SHOW CREATE TABLE t1;
1912 Table Create Table
1913 t1 CREATE TABLE `t1` (
1914 `c1` int NOT NULL,
1915 `c2` int NOT NULL,
1916 `c3` int DEFAULT NULL,
1917 `c4` varchar(10) NOT NULL
1918 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1919 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1920 SHOW TABLES;
1921 Tables_in_test
1922 t1
1923 SHOW CREATE TABLE t1;
1924 Table Create Table
1925 t1 CREATE TABLE `t1` (
1926 `c1` int NOT NULL,
1927 `c2` int NOT NULL,
1928 `c3` int DEFAULT NULL,
1929 `c4` varchar(10) NOT NULL,
1930 PRIMARY KEY (`c1`,`c2`)
1931 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1932 DROP TABLE t1;
1933 SHOW TABLES;
1934 Tables_in_test
1935 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1936 SHOW TABLES;
1937 Tables_in_test
1938 t1
1939 SHOW CREATE TABLE t1;
1940 Table Create Table
1941 t1 CREATE TABLE `t1` (
1942 `c1` int NOT NULL,
1943 `c2` int NOT NULL,
1944 `c3` int DEFAULT NULL,
1945 `c4` varchar(10) NOT NULL
1946 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1947 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1948 SHOW TABLES;
1949 Tables_in_test
1950 t1
1951 SHOW CREATE TABLE t1;
1952 Table Create Table
1953 t1 CREATE TABLE `t1` (
1954 `c1` int NOT NULL,
1955 `c2` int NOT NULL,
1956 `c3` int DEFAULT NULL,
1957 `c4` varchar(10) NOT NULL,
1958 PRIMARY KEY (`c1`,`c2`)
1959 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1960 DROP TABLE t1;
1961 SHOW TABLES;
1962 Tables_in_test
1963 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1964 SHOW TABLES;
1965 Tables_in_test
1966 t1
1967 SHOW CREATE TABLE t1;
1968 Table Create Table
1969 t1 CREATE TABLE `t1` (
1970 `c1` bigint NOT NULL,
1971 `c2` int NOT NULL,
1972 `c3` int DEFAULT NULL,
1973 `c4` varchar(10) NOT NULL
1974 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1975 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1976 SHOW TABLES;
1977 Tables_in_test
1978 t1
1979 SHOW CREATE TABLE t1;
1980 Table Create Table
1981 t1 CREATE TABLE `t1` (
1982 `c1` bigint NOT NULL,
1983 `c2` int NOT NULL,
1984 `c3` int DEFAULT NULL,
1985 `c4` varchar(10) NOT NULL,
1986 PRIMARY KEY (`c1`,`c2`)
1987 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1988 DROP TABLE t1;
1989 SHOW TABLES;
1990 Tables_in_test
1991 CREATE TABLE t1(c1 REAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1992 SHOW TABLES;
1993 Tables_in_test
1994 t1
1995 SHOW CREATE TABLE t1;
1996 Table Create Table
1997 t1 CREATE TABLE `t1` (
1998 `c1` double NOT NULL,
1999 `c2` int NOT NULL,
2000 `c3` int DEFAULT NULL,
2001 `c4` varchar(10) NOT NULL
2002 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2003 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2004 SHOW TABLES;
2005 Tables_in_test
2006 t1
2007 SHOW CREATE TABLE t1;
2008 Table Create Table
2009 t1 CREATE TABLE `t1` (
2010 `c1` double NOT NULL,
2011 `c2` int NOT NULL,
2012 `c3` int DEFAULT NULL,
2013 `c4` varchar(10) NOT NULL,
2014 PRIMARY KEY (`c1`,`c2`)
2015 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2016 DROP TABLE t1;
2017 SHOW TABLES;
2018 Tables_in_test
2019 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2020 SHOW TABLES;
2021 Tables_in_test
2022 t1
2023 SHOW CREATE TABLE t1;
2024 Table Create Table
2025 t1 CREATE TABLE `t1` (
2026 `c1` double NOT NULL,
2027 `c2` int NOT NULL,
2028 `c3` int DEFAULT NULL,
2029 `c4` varchar(10) NOT NULL
2030 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2031 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2032 SHOW TABLES;
2033 Tables_in_test
2034 t1
2035 SHOW CREATE TABLE t1;
2036 Table Create Table
2037 t1 CREATE TABLE `t1` (
2038 `c1` double NOT NULL,
2039 `c2` int NOT NULL,
2040 `c3` int DEFAULT NULL,
2041 `c4` varchar(10) NOT NULL,
2042 PRIMARY KEY (`c1`,`c2`)
2043 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2044 DROP TABLE t1;
2045 SHOW TABLES;
2046 Tables_in_test
2047 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2048 SHOW TABLES;
2049 Tables_in_test
2050 t1
2051 SHOW CREATE TABLE t1;
2052 Table Create Table
2053 t1 CREATE TABLE `t1` (
2054 `c1` float NOT NULL,
2055 `c2` int NOT NULL,
2056 `c3` int DEFAULT NULL,
2057 `c4` varchar(10) NOT NULL
2058 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2059 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2060 SHOW TABLES;
2061 Tables_in_test
2062 t1
2063 SHOW CREATE TABLE t1;
2064 Table Create Table
2065 t1 CREATE TABLE `t1` (
2066 `c1` float NOT NULL,
2067 `c2` int NOT NULL,
2068 `c3` int DEFAULT NULL,
2069 `c4` varchar(10) NOT NULL,
2070 PRIMARY KEY (`c1`,`c2`)
2071 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2072 DROP TABLE t1;
2073 SHOW TABLES;
2074 Tables_in_test
2075 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2076 SHOW TABLES;
2077 Tables_in_test
2078 t1
2079 SHOW CREATE TABLE t1;
2080 Table Create Table
2081 t1 CREATE TABLE `t1` (
2082 `c1` decimal(10,0) NOT NULL,
2083 `c2` int NOT NULL,
2084 `c3` int DEFAULT NULL,
2085 `c4` varchar(10) NOT NULL
2086 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2087 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2088 SHOW TABLES;
2089 Tables_in_test
2090 t1
2091 SHOW CREATE TABLE t1;
2092 Table Create Table
2093 t1 CREATE TABLE `t1` (
2094 `c1` decimal(10,0) NOT NULL,
2095 `c2` int NOT NULL,
2096 `c3` int DEFAULT NULL,
2097 `c4` varchar(10) NOT NULL,
2098 PRIMARY KEY (`c1`,`c2`)
2099 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2100 DROP TABLE t1;
2101 SHOW TABLES;
2102 Tables_in_test
2103 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2104 SHOW TABLES;
2105 Tables_in_test
2106 t1
2107 SHOW CREATE TABLE t1;
2108 Table Create Table
2109 t1 CREATE TABLE `t1` (
2110 `c1` decimal(10,0) NOT NULL,
2111 `c2` int NOT NULL,
2112 `c3` int DEFAULT NULL,
2113 `c4` varchar(10) NOT NULL
2114 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2115 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2116 SHOW TABLES;
2117 Tables_in_test
2118 t1
2119 SHOW CREATE TABLE t1;
2120 Table Create Table
2121 t1 CREATE TABLE `t1` (
2122 `c1` decimal(10,0) NOT NULL,
2123 `c2` int NOT NULL,
2124 `c3` int DEFAULT NULL,
2125 `c4` varchar(10) NOT NULL,
2126 PRIMARY KEY (`c1`,`c2`)
2127 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2128 DROP TABLE t1;
2129 SHOW TABLES;
2130 Tables_in_test
2131 CREATE TABLE t1(c1 DATE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2132 SHOW TABLES;
2133 Tables_in_test
2134 t1
2135 SHOW CREATE TABLE t1;
2136 Table Create Table
2137 t1 CREATE TABLE `t1` (
2138 `c1` date NOT NULL,
2139 `c2` int NOT NULL,
2140 `c3` int DEFAULT NULL,
2141 `c4` varchar(10) NOT NULL
2142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2143 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2144 SHOW TABLES;
2145 Tables_in_test
2146 t1
2147 SHOW CREATE TABLE t1;
2148 Table Create Table
2149 t1 CREATE TABLE `t1` (
2150 `c1` date NOT NULL,
2151 `c2` int NOT NULL,
2152 `c3` int DEFAULT NULL,
2153 `c4` varchar(10) NOT NULL,
2154 PRIMARY KEY (`c1`,`c2`)
2155 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2156 DROP TABLE t1;
2157 SHOW TABLES;
2158 Tables_in_test
2159 CREATE TABLE t1(c1 TIME NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2160 SHOW TABLES;
2161 Tables_in_test
2162 t1
2163 SHOW CREATE TABLE t1;
2164 Table Create Table
2165 t1 CREATE TABLE `t1` (
2166 `c1` time NOT NULL,
2167 `c2` int NOT NULL,
2168 `c3` int DEFAULT NULL,
2169 `c4` varchar(10) NOT NULL
2170 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2171 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2172 SHOW TABLES;
2173 Tables_in_test
2174 t1
2175 SHOW CREATE TABLE t1;
2176 Table Create Table
2177 t1 CREATE TABLE `t1` (
2178 `c1` time NOT NULL,
2179 `c2` int NOT NULL,
2180 `c3` int DEFAULT NULL,
2181 `c4` varchar(10) NOT NULL,
2182 PRIMARY KEY (`c1`,`c2`)
2183 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2184 DROP TABLE t1;
2185 SHOW TABLES;
2186 Tables_in_test
2187 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2188 SHOW TABLES;
2189 Tables_in_test
2190 t1
2191 SHOW CREATE TABLE t1;
2192 Table Create Table
2193 t1 CREATE TABLE `t1` (
2194 `c1` timestamp NOT NULL,
2195 `c2` int NOT NULL,
2196 `c3` int DEFAULT NULL,
2197 `c4` varchar(10) NOT NULL
2198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2199 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2200 SHOW TABLES;
2201 Tables_in_test
2202 t1
2203 SHOW CREATE TABLE t1;
2204 Table Create Table
2205 t1 CREATE TABLE `t1` (
2206 `c1` timestamp NOT NULL,
2207 `c2` int NOT NULL,
2208 `c3` int DEFAULT NULL,
2209 `c4` varchar(10) NOT NULL,
2210 PRIMARY KEY (`c1`,`c2`)
2211 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2212 DROP TABLE t1;
2213 SHOW TABLES;
2214 Tables_in_test
2215 CREATE TABLE t1(c1 YEAR NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2216 SHOW TABLES;
2217 Tables_in_test
2218 t1
2219 SHOW CREATE TABLE t1;
2220 Table Create Table
2221 t1 CREATE TABLE `t1` (
2222 `c1` year NOT NULL,
2223 `c2` int NOT NULL,
2224 `c3` int DEFAULT NULL,
2225 `c4` varchar(10) NOT NULL
2226 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2227 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2228 SHOW TABLES;
2229 Tables_in_test
2230 t1
2231 SHOW CREATE TABLE t1;
2232 Table Create Table
2233 t1 CREATE TABLE `t1` (
2234 `c1` year NOT NULL,
2235 `c2` int NOT NULL,
2236 `c3` int DEFAULT NULL,
2237 `c4` varchar(10) NOT NULL,
2238 PRIMARY KEY (`c1`,`c2`)
2239 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2240 DROP TABLE t1;
2241 SHOW TABLES;
2242 Tables_in_test
2243 CREATE TABLE t1(c1 BIT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2244 SHOW TABLES;
2245 Tables_in_test
2246 t1
2247 SHOW CREATE TABLE t1;
2248 Table Create Table
2249 t1 CREATE TABLE `t1` (
2250 `c1` bit(1) NOT NULL,
2251 `c2` int NOT NULL,
2252 `c3` int DEFAULT NULL,
2253 `c4` varchar(10) NOT NULL
2254 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2255 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2256 SHOW TABLES;
2257 Tables_in_test
2258 t1
2259 SHOW CREATE TABLE t1;
2260 Table Create Table
2261 t1 CREATE TABLE `t1` (
2262 `c1` bit(1) NOT NULL,
2263 `c2` int NOT NULL,
2264 `c3` int DEFAULT NULL,
2265 `c4` varchar(10) NOT NULL,
2266 PRIMARY KEY (`c1`,`c2`)
2267 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2268 DROP TABLE t1;
2269 SHOW TABLES;
2270 Tables_in_test
2271 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2272 SHOW TABLES;
2273 Tables_in_test
2274 t1
2275 SHOW CREATE TABLE t1;
2276 Table Create Table
2277 t1 CREATE TABLE `t1` (
2278 `c1` tinyint NOT NULL,
2279 `c2` int NOT NULL,
2280 `c3` int DEFAULT NULL,
2281 `c4` varchar(10) NOT NULL
2282 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2283 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2284 SHOW TABLES;
2285 Tables_in_test
2286 t1
2287 SHOW CREATE TABLE t1;
2288 Table Create Table
2289 t1 CREATE TABLE `t1` (
2290 `c1` tinyint NOT NULL,
2291 `c2` int NOT NULL,
2292 `c3` int DEFAULT NULL,
2293 `c4` varchar(10) NOT NULL,
2294 PRIMARY KEY (`c1`,`c2`)
2295 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2296 DROP TABLE t1;
2297 SHOW TABLES;
2298 Tables_in_test
2299 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2300 SHOW TABLES;
2301 Tables_in_test
2302 t1
2303 SHOW CREATE TABLE t1;
2304 Table Create Table
2305 t1 CREATE TABLE `t1` (
2306 `c1` smallint NOT NULL,
2307 `c2` int NOT NULL,
2308 `c3` int DEFAULT NULL,
2309 `c4` varchar(10) NOT NULL
2310 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2311 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2312 SHOW TABLES;
2313 Tables_in_test
2314 t1
2315 SHOW CREATE TABLE t1;
2316 Table Create Table
2317 t1 CREATE TABLE `t1` (
2318 `c1` smallint NOT NULL,
2319 `c2` int NOT NULL,
2320 `c3` int DEFAULT NULL,
2321 `c4` varchar(10) NOT NULL,
2322 PRIMARY KEY (`c1`,`c2`)
2323 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2324 DROP TABLE t1;
2325 SHOW TABLES;
2326 Tables_in_test
2327 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2328 SHOW TABLES;
2329 Tables_in_test
2330 t1
2331 SHOW CREATE TABLE t1;
2332 Table Create Table
2333 t1 CREATE TABLE `t1` (
2334 `c1` mediumint NOT NULL,
2335 `c2` int NOT NULL,
2336 `c3` int DEFAULT NULL,
2337 `c4` varchar(10) NOT NULL
2338 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2339 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2340 SHOW TABLES;
2341 Tables_in_test
2342 t1
2343 SHOW CREATE TABLE t1;
2344 Table Create Table
2345 t1 CREATE TABLE `t1` (
2346 `c1` mediumint NOT NULL,
2347 `c2` int NOT NULL,
2348 `c3` int DEFAULT NULL,
2349 `c4` varchar(10) NOT NULL,
2350 PRIMARY KEY (`c1`,`c2`)
2351 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2352 DROP TABLE t1;
2353 SHOW TABLES;
2354 Tables_in_test
2355 CREATE TABLE t1(c1 INT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2356 SHOW TABLES;
2357 Tables_in_test
2358 t1
2359 SHOW CREATE TABLE t1;
2360 Table Create Table
2361 t1 CREATE TABLE `t1` (
2362 `c1` int NOT NULL,
2363 `c2` int NOT NULL,
2364 `c3` int DEFAULT NULL,
2365 `c4` varchar(10) NOT NULL
2366 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2367 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2368 SHOW TABLES;
2369 Tables_in_test
2370 t1
2371 SHOW CREATE TABLE t1;
2372 Table Create Table
2373 t1 CREATE TABLE `t1` (
2374 `c1` int NOT NULL,
2375 `c2` int NOT NULL,
2376 `c3` int DEFAULT NULL,
2377 `c4` varchar(10) NOT NULL,
2378 PRIMARY KEY (`c1`,`c2`)
2379 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2380 DROP TABLE t1;
2381 SHOW TABLES;
2382 Tables_in_test
2383 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2384 SHOW TABLES;
2385 Tables_in_test
2386 t1
2387 SHOW CREATE TABLE t1;
2388 Table Create Table
2389 t1 CREATE TABLE `t1` (
2390 `c1` int NOT NULL,
2391 `c2` int NOT NULL,
2392 `c3` int DEFAULT NULL,
2393 `c4` varchar(10) NOT NULL
2394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2395 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2396 SHOW TABLES;
2397 Tables_in_test
2398 t1
2399 SHOW CREATE TABLE t1;
2400 Table Create Table
2401 t1 CREATE TABLE `t1` (
2402 `c1` int NOT NULL,
2403 `c2` int NOT NULL,
2404 `c3` int DEFAULT NULL,
2405 `c4` varchar(10) NOT NULL,
2406 PRIMARY KEY (`c1`,`c2`)
2407 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2408 DROP TABLE t1;
2409 SHOW TABLES;
2410 Tables_in_test
2411 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2412 SHOW TABLES;
2413 Tables_in_test
2414 t1
2415 SHOW CREATE TABLE t1;
2416 Table Create Table
2417 t1 CREATE TABLE `t1` (
2418 `c1` bigint NOT NULL,
2419 `c2` int NOT NULL,
2420 `c3` int DEFAULT NULL,
2421 `c4` varchar(10) NOT NULL
2422 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2423 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2424 SHOW TABLES;
2425 Tables_in_test
2426 t1
2427 SHOW CREATE TABLE t1;
2428 Table Create Table
2429 t1 CREATE TABLE `t1` (
2430 `c1` bigint NOT NULL,
2431 `c2` int NOT NULL,
2432 `c3` int DEFAULT NULL,
2433 `c4` varchar(10) NOT NULL,
2434 PRIMARY KEY (`c1`,`c2`)
2435 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2436 DROP TABLE t1;
2437 SHOW TABLES;
2438 Tables_in_test
2439 CREATE TABLE t1(c1 REAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2440 SHOW TABLES;
2441 Tables_in_test
2442 t1
2443 SHOW CREATE TABLE t1;
2444 Table Create Table
2445 t1 CREATE TABLE `t1` (
2446 `c1` double NOT NULL,
2447 `c2` int NOT NULL,
2448 `c3` int DEFAULT NULL,
2449 `c4` varchar(10) NOT NULL
2450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2451 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2452 SHOW TABLES;
2453 Tables_in_test
2454 t1
2455 SHOW CREATE TABLE t1;
2456 Table Create Table
2457 t1 CREATE TABLE `t1` (
2458 `c1` double NOT NULL,
2459 `c2` int NOT NULL,
2460 `c3` int DEFAULT NULL,
2461 `c4` varchar(10) NOT NULL,
2462 PRIMARY KEY (`c1`,`c2`)
2463 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2464 DROP TABLE t1;
2465 SHOW TABLES;
2466 Tables_in_test
2467 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2468 SHOW TABLES;
2469 Tables_in_test
2470 t1
2471 SHOW CREATE TABLE t1;
2472 Table Create Table
2473 t1 CREATE TABLE `t1` (
2474 `c1` double NOT NULL,
2475 `c2` int NOT NULL,
2476 `c3` int DEFAULT NULL,
2477 `c4` varchar(10) NOT NULL
2478 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2479 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2480 SHOW TABLES;
2481 Tables_in_test
2482 t1
2483 SHOW CREATE TABLE t1;
2484 Table Create Table
2485 t1 CREATE TABLE `t1` (
2486 `c1` double NOT NULL,
2487 `c2` int NOT NULL,
2488 `c3` int DEFAULT NULL,
2489 `c4` varchar(10) NOT NULL,
2490 PRIMARY KEY (`c1`,`c2`)
2491 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2492 DROP TABLE t1;
2493 SHOW TABLES;
2494 Tables_in_test
2495 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2496 SHOW TABLES;
2497 Tables_in_test
2498 t1
2499 SHOW CREATE TABLE t1;
2500 Table Create Table
2501 t1 CREATE TABLE `t1` (
2502 `c1` float NOT NULL,
2503 `c2` int NOT NULL,
2504 `c3` int DEFAULT NULL,
2505 `c4` varchar(10) NOT NULL
2506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2507 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2508 SHOW TABLES;
2509 Tables_in_test
2510 t1
2511 SHOW CREATE TABLE t1;
2512 Table Create Table
2513 t1 CREATE TABLE `t1` (
2514 `c1` float NOT NULL,
2515 `c2` int NOT NULL,
2516 `c3` int DEFAULT NULL,
2517 `c4` varchar(10) NOT NULL,
2518 PRIMARY KEY (`c1`,`c2`)
2519 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2520 DROP TABLE t1;
2521 SHOW TABLES;
2522 Tables_in_test
2523 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2524 SHOW TABLES;
2525 Tables_in_test
2526 t1
2527 SHOW CREATE TABLE t1;
2528 Table Create Table
2529 t1 CREATE TABLE `t1` (
2530 `c1` decimal(10,0) NOT NULL,
2531 `c2` int NOT NULL,
2532 `c3` int DEFAULT NULL,
2533 `c4` varchar(10) NOT NULL
2534 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2535 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2536 SHOW TABLES;
2537 Tables_in_test
2538 t1
2539 SHOW CREATE TABLE t1;
2540 Table Create Table
2541 t1 CREATE TABLE `t1` (
2542 `c1` decimal(10,0) NOT NULL,
2543 `c2` int NOT NULL,
2544 `c3` int DEFAULT NULL,
2545 `c4` varchar(10) NOT NULL,
2546 PRIMARY KEY (`c1`,`c2`)
2547 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2548 DROP TABLE t1;
2549 SHOW TABLES;
2550 Tables_in_test
2551 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2552 SHOW TABLES;
2553 Tables_in_test
2554 t1
2555 SHOW CREATE TABLE t1;
2556 Table Create Table
2557 t1 CREATE TABLE `t1` (
2558 `c1` decimal(10,0) NOT NULL,
2559 `c2` int NOT NULL,
2560 `c3` int DEFAULT NULL,
2561 `c4` varchar(10) NOT NULL
2562 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2563 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2564 SHOW TABLES;
2565 Tables_in_test
2566 t1
2567 SHOW CREATE TABLE t1;
2568 Table Create Table
2569 t1 CREATE TABLE `t1` (
2570 `c1` decimal(10,0) NOT NULL,
2571 `c2` int NOT NULL,
2572 `c3` int DEFAULT NULL,
2573 `c4` varchar(10) NOT NULL,
2574 PRIMARY KEY (`c1`,`c2`)
2575 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2576 DROP TABLE t1;
2577 SHOW TABLES;
2578 Tables_in_test
2579 CREATE TABLE t1(c1 DATE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2580 SHOW TABLES;
2581 Tables_in_test
2582 t1
2583 SHOW CREATE TABLE t1;
2584 Table Create Table
2585 t1 CREATE TABLE `t1` (
2586 `c1` date NOT NULL,
2587 `c2` int NOT NULL,
2588 `c3` int DEFAULT NULL,
2589 `c4` varchar(10) NOT NULL
2590 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2591 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2592 SHOW TABLES;
2593 Tables_in_test
2594 t1
2595 SHOW CREATE TABLE t1;
2596 Table Create Table
2597 t1 CREATE TABLE `t1` (
2598 `c1` date NOT NULL,
2599 `c2` int NOT NULL,
2600 `c3` int DEFAULT NULL,
2601 `c4` varchar(10) NOT NULL,
2602 PRIMARY KEY (`c1`,`c2`)
2603 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2604 DROP TABLE t1;
2605 SHOW TABLES;
2606 Tables_in_test
2607 CREATE TABLE t1(c1 TIME NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2608 SHOW TABLES;
2609 Tables_in_test
2610 t1
2611 SHOW CREATE TABLE t1;
2612 Table Create Table
2613 t1 CREATE TABLE `t1` (
2614 `c1` time NOT NULL,
2615 `c2` int NOT NULL,
2616 `c3` int DEFAULT NULL,
2617 `c4` varchar(10) NOT NULL
2618 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2619 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2620 SHOW TABLES;
2621 Tables_in_test
2622 t1
2623 SHOW CREATE TABLE t1;
2624 Table Create Table
2625 t1 CREATE TABLE `t1` (
2626 `c1` time NOT NULL,
2627 `c2` int NOT NULL,
2628 `c3` int DEFAULT NULL,
2629 `c4` varchar(10) NOT NULL,
2630 PRIMARY KEY (`c1`,`c2`)
2631 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2632 DROP TABLE t1;
2633 SHOW TABLES;
2634 Tables_in_test
2635 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2636 SHOW TABLES;
2637 Tables_in_test
2638 t1
2639 SHOW CREATE TABLE t1;
2640 Table Create Table
2641 t1 CREATE TABLE `t1` (
2642 `c1` timestamp NOT NULL,
2643 `c2` int NOT NULL,
2644 `c3` int DEFAULT NULL,
2645 `c4` varchar(10) NOT NULL
2646 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2647 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2648 SHOW TABLES;
2649 Tables_in_test
2650 t1
2651 SHOW CREATE TABLE t1;
2652 Table Create Table
2653 t1 CREATE TABLE `t1` (
2654 `c1` timestamp NOT NULL,
2655 `c2` int NOT NULL,
2656 `c3` int DEFAULT NULL,
2657 `c4` varchar(10) NOT NULL,
2658 PRIMARY KEY (`c1`,`c2`)
2659 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2660 DROP TABLE t1;
2661 SHOW TABLES;
2662 Tables_in_test
2663 CREATE TABLE t1(c1 YEAR NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2664 SHOW TABLES;
2665 Tables_in_test
2666 t1
2667 SHOW CREATE TABLE t1;
2668 Table Create Table
2669 t1 CREATE TABLE `t1` (
2670 `c1` year NOT NULL,
2671 `c2` int NOT NULL,
2672 `c3` int DEFAULT NULL,
2673 `c4` varchar(10) NOT NULL
2674 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2675 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2676 SHOW TABLES;
2677 Tables_in_test
2678 t1
2679 SHOW CREATE TABLE t1;
2680 Table Create Table
2681 t1 CREATE TABLE `t1` (
2682 `c1` year NOT NULL,
2683 `c2` int NOT NULL,
2684 `c3` int DEFAULT NULL,
2685 `c4` varchar(10) NOT NULL,
2686 PRIMARY KEY (`c1`,`c2`)
2687 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2688 DROP TABLE t1;
2689 SHOW TABLES;
2690 Tables_in_test
2691 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2692 SHOW TABLES;
2693 Tables_in_test
2694 t1
2695 SHOW CREATE TABLE t1;
2696 Table Create Table
2697 t1 CREATE TABLE `t1` (
2698 `c1` bit(1) NOT NULL,
2699 `c2` bigint NOT NULL,
2700 `c3` int DEFAULT NULL,
2701 `c4` varchar(10) NOT NULL
2702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2703 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2704 SHOW TABLES;
2705 Tables_in_test
2706 t1
2707 SHOW CREATE TABLE t1;
2708 Table Create Table
2709 t1 CREATE TABLE `t1` (
2710 `c1` bit(1) NOT NULL,
2711 `c2` bigint NOT NULL,
2712 `c3` int DEFAULT NULL,
2713 `c4` varchar(10) NOT NULL,
2714 PRIMARY KEY (`c1`,`c2`)
2715 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2716 DROP TABLE t1;
2717 SHOW TABLES;
2718 Tables_in_test
2719 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2720 SHOW TABLES;
2721 Tables_in_test
2722 t1
2723 SHOW CREATE TABLE t1;
2724 Table Create Table
2725 t1 CREATE TABLE `t1` (
2726 `c1` tinyint NOT NULL,
2727 `c2` bigint NOT NULL,
2728 `c3` int DEFAULT NULL,
2729 `c4` varchar(10) NOT NULL
2730 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2731 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2732 SHOW TABLES;
2733 Tables_in_test
2734 t1
2735 SHOW CREATE TABLE t1;
2736 Table Create Table
2737 t1 CREATE TABLE `t1` (
2738 `c1` tinyint NOT NULL,
2739 `c2` bigint NOT NULL,
2740 `c3` int DEFAULT NULL,
2741 `c4` varchar(10) NOT NULL,
2742 PRIMARY KEY (`c1`,`c2`)
2743 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2744 DROP TABLE t1;
2745 SHOW TABLES;
2746 Tables_in_test
2747 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2748 SHOW TABLES;
2749 Tables_in_test
2750 t1
2751 SHOW CREATE TABLE t1;
2752 Table Create Table
2753 t1 CREATE TABLE `t1` (
2754 `c1` smallint NOT NULL,
2755 `c2` bigint NOT NULL,
2756 `c3` int DEFAULT NULL,
2757 `c4` varchar(10) NOT NULL
2758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2759 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2760 SHOW TABLES;
2761 Tables_in_test
2762 t1
2763 SHOW CREATE TABLE t1;
2764 Table Create Table
2765 t1 CREATE TABLE `t1` (
2766 `c1` smallint NOT NULL,
2767 `c2` bigint NOT NULL,
2768 `c3` int DEFAULT NULL,
2769 `c4` varchar(10) NOT NULL,
2770 PRIMARY KEY (`c1`,`c2`)
2771 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2772 DROP TABLE t1;
2773 SHOW TABLES;
2774 Tables_in_test
2775 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2776 SHOW TABLES;
2777 Tables_in_test
2778 t1
2779 SHOW CREATE TABLE t1;
2780 Table Create Table
2781 t1 CREATE TABLE `t1` (
2782 `c1` mediumint NOT NULL,
2783 `c2` bigint NOT NULL,
2784 `c3` int DEFAULT NULL,
2785 `c4` varchar(10) NOT NULL
2786 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2787 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2788 SHOW TABLES;
2789 Tables_in_test
2790 t1
2791 SHOW CREATE TABLE t1;
2792 Table Create Table
2793 t1 CREATE TABLE `t1` (
2794 `c1` mediumint NOT NULL,
2795 `c2` bigint NOT NULL,
2796 `c3` int DEFAULT NULL,
2797 `c4` varchar(10) NOT NULL,
2798 PRIMARY KEY (`c1`,`c2`)
2799 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2800 DROP TABLE t1;
2801 SHOW TABLES;
2802 Tables_in_test
2803 CREATE TABLE t1(c1 INT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2804 SHOW TABLES;
2805 Tables_in_test
2806 t1
2807 SHOW CREATE TABLE t1;
2808 Table Create Table
2809 t1 CREATE TABLE `t1` (
2810 `c1` int NOT NULL,
2811 `c2` bigint NOT NULL,
2812 `c3` int DEFAULT NULL,
2813 `c4` varchar(10) NOT NULL
2814 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2815 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2816 SHOW TABLES;
2817 Tables_in_test
2818 t1
2819 SHOW CREATE TABLE t1;
2820 Table Create Table
2821 t1 CREATE TABLE `t1` (
2822 `c1` int NOT NULL,
2823 `c2` bigint NOT NULL,
2824 `c3` int DEFAULT NULL,
2825 `c4` varchar(10) NOT NULL,
2826 PRIMARY KEY (`c1`,`c2`)
2827 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2828 DROP TABLE t1;
2829 SHOW TABLES;
2830 Tables_in_test
2831 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2832 SHOW TABLES;
2833 Tables_in_test
2834 t1
2835 SHOW CREATE TABLE t1;
2836 Table Create Table
2837 t1 CREATE TABLE `t1` (
2838 `c1` int NOT NULL,
2839 `c2` bigint NOT NULL,
2840 `c3` int DEFAULT NULL,
2841 `c4` varchar(10) NOT NULL
2842 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2843 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2844 SHOW TABLES;
2845 Tables_in_test
2846 t1
2847 SHOW CREATE TABLE t1;
2848 Table Create Table
2849 t1 CREATE TABLE `t1` (
2850 `c1` int NOT NULL,
2851 `c2` bigint NOT NULL,
2852 `c3` int DEFAULT NULL,
2853 `c4` varchar(10) NOT NULL,
2854 PRIMARY KEY (`c1`,`c2`)
2855 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2856 DROP TABLE t1;
2857 SHOW TABLES;
2858 Tables_in_test
2859 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2860 SHOW TABLES;
2861 Tables_in_test
2862 t1
2863 SHOW CREATE TABLE t1;
2864 Table Create Table
2865 t1 CREATE TABLE `t1` (
2866 `c1` bigint NOT NULL,
2867 `c2` bigint NOT NULL,
2868 `c3` int DEFAULT NULL,
2869 `c4` varchar(10) NOT NULL
2870 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2871 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2872 SHOW TABLES;
2873 Tables_in_test
2874 t1
2875 SHOW CREATE TABLE t1;
2876 Table Create Table
2877 t1 CREATE TABLE `t1` (
2878 `c1` bigint NOT NULL,
2879 `c2` bigint NOT NULL,
2880 `c3` int DEFAULT NULL,
2881 `c4` varchar(10) NOT NULL,
2882 PRIMARY KEY (`c1`,`c2`)
2883 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2884 DROP TABLE t1;
2885 SHOW TABLES;
2886 Tables_in_test
2887 CREATE TABLE t1(c1 REAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2888 SHOW TABLES;
2889 Tables_in_test
2890 t1
2891 SHOW CREATE TABLE t1;
2892 Table Create Table
2893 t1 CREATE TABLE `t1` (
2894 `c1` double NOT NULL,
2895 `c2` bigint NOT NULL,
2896 `c3` int DEFAULT NULL,
2897 `c4` varchar(10) NOT NULL
2898 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2899 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2900 SHOW TABLES;
2901 Tables_in_test
2902 t1
2903 SHOW CREATE TABLE t1;
2904 Table Create Table
2905 t1 CREATE TABLE `t1` (
2906 `c1` double NOT NULL,
2907 `c2` bigint NOT NULL,
2908 `c3` int DEFAULT NULL,
2909 `c4` varchar(10) NOT NULL,
2910 PRIMARY KEY (`c1`,`c2`)
2911 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2912 DROP TABLE t1;
2913 SHOW TABLES;
2914 Tables_in_test
2915 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2916 SHOW TABLES;
2917 Tables_in_test
2918 t1
2919 SHOW CREATE TABLE t1;
2920 Table Create Table
2921 t1 CREATE TABLE `t1` (
2922 `c1` double NOT NULL,
2923 `c2` bigint NOT NULL,
2924 `c3` int DEFAULT NULL,
2925 `c4` varchar(10) NOT NULL
2926 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2927 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2928 SHOW TABLES;
2929 Tables_in_test
2930 t1
2931 SHOW CREATE TABLE t1;
2932 Table Create Table
2933 t1 CREATE TABLE `t1` (
2934 `c1` double NOT NULL,
2935 `c2` bigint NOT NULL,
2936 `c3` int DEFAULT NULL,
2937 `c4` varchar(10) NOT NULL,
2938 PRIMARY KEY (`c1`,`c2`)
2939 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2940 DROP TABLE t1;
2941 SHOW TABLES;
2942 Tables_in_test
2943 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2944 SHOW TABLES;
2945 Tables_in_test
2946 t1
2947 SHOW CREATE TABLE t1;
2948 Table Create Table
2949 t1 CREATE TABLE `t1` (
2950 `c1` float NOT NULL,
2951 `c2` bigint NOT NULL,
2952 `c3` int DEFAULT NULL,
2953 `c4` varchar(10) NOT NULL
2954 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2955 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2956 SHOW TABLES;
2957 Tables_in_test
2958 t1
2959 SHOW CREATE TABLE t1;
2960 Table Create Table
2961 t1 CREATE TABLE `t1` (
2962 `c1` float NOT NULL,
2963 `c2` bigint NOT NULL,
2964 `c3` int DEFAULT NULL,
2965 `c4` varchar(10) NOT NULL,
2966 PRIMARY KEY (`c1`,`c2`)
2967 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2968 DROP TABLE t1;
2969 SHOW TABLES;
2970 Tables_in_test
2971 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2972 SHOW TABLES;
2973 Tables_in_test
2974 t1
2975 SHOW CREATE TABLE t1;
2976 Table Create Table
2977 t1 CREATE TABLE `t1` (
2978 `c1` decimal(10,0) NOT NULL,
2979 `c2` bigint NOT NULL,
2980 `c3` int DEFAULT NULL,
2981 `c4` varchar(10) NOT NULL
2982 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2983 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2984 SHOW TABLES;
2985 Tables_in_test
2986 t1
2987 SHOW CREATE TABLE t1;
2988 Table Create Table
2989 t1 CREATE TABLE `t1` (
2990 `c1` decimal(10,0) NOT NULL,
2991 `c2` bigint NOT NULL,
2992 `c3` int DEFAULT NULL,
2993 `c4` varchar(10) NOT NULL,
2994 PRIMARY KEY (`c1`,`c2`)
2995 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2996 DROP TABLE t1;
2997 SHOW TABLES;
2998 Tables_in_test
2999 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3000 SHOW TABLES;
3001 Tables_in_test
3002 t1
3003 SHOW CREATE TABLE t1;
3004 Table Create Table
3005 t1 CREATE TABLE `t1` (
3006 `c1` decimal(10,0) NOT NULL,
3007 `c2` bigint NOT NULL,
3008 `c3` int DEFAULT NULL,
3009 `c4` varchar(10) NOT NULL
3010 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3011 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3012 SHOW TABLES;
3013 Tables_in_test
3014 t1
3015 SHOW CREATE TABLE t1;
3016 Table Create Table
3017 t1 CREATE TABLE `t1` (
3018 `c1` decimal(10,0) NOT NULL,
3019 `c2` bigint NOT NULL,
3020 `c3` int DEFAULT NULL,
3021 `c4` varchar(10) NOT NULL,
3022 PRIMARY KEY (`c1`,`c2`)
3023 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3024 DROP TABLE t1;
3025 SHOW TABLES;
3026 Tables_in_test
3027 CREATE TABLE t1(c1 DATE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3028 SHOW TABLES;
3029 Tables_in_test
3030 t1
3031 SHOW CREATE TABLE t1;
3032 Table Create Table
3033 t1 CREATE TABLE `t1` (
3034 `c1` date NOT NULL,
3035 `c2` bigint NOT NULL,
3036 `c3` int DEFAULT NULL,
3037 `c4` varchar(10) NOT NULL
3038 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3039 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3040 SHOW TABLES;
3041 Tables_in_test
3042 t1
3043 SHOW CREATE TABLE t1;
3044 Table Create Table
3045 t1 CREATE TABLE `t1` (
3046 `c1` date NOT NULL,
3047 `c2` bigint NOT NULL,
3048 `c3` int DEFAULT NULL,
3049 `c4` varchar(10) NOT NULL,
3050 PRIMARY KEY (`c1`,`c2`)
3051 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3052 DROP TABLE t1;
3053 SHOW TABLES;
3054 Tables_in_test
3055 CREATE TABLE t1(c1 TIME NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3056 SHOW TABLES;
3057 Tables_in_test
3058 t1
3059 SHOW CREATE TABLE t1;
3060 Table Create Table
3061 t1 CREATE TABLE `t1` (
3062 `c1` time NOT NULL,
3063 `c2` bigint NOT NULL,
3064 `c3` int DEFAULT NULL,
3065 `c4` varchar(10) NOT NULL
3066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3067 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3068 SHOW TABLES;
3069 Tables_in_test
3070 t1
3071 SHOW CREATE TABLE t1;
3072 Table Create Table
3073 t1 CREATE TABLE `t1` (
3074 `c1` time NOT NULL,
3075 `c2` bigint NOT NULL,
3076 `c3` int DEFAULT NULL,
3077 `c4` varchar(10) NOT NULL,
3078 PRIMARY KEY (`c1`,`c2`)
3079 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3080 DROP TABLE t1;
3081 SHOW TABLES;
3082 Tables_in_test
3083 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3084 SHOW TABLES;
3085 Tables_in_test
3086 t1
3087 SHOW CREATE TABLE t1;
3088 Table Create Table
3089 t1 CREATE TABLE `t1` (
3090 `c1` timestamp NOT NULL,
3091 `c2` bigint NOT NULL,
3092 `c3` int DEFAULT NULL,
3093 `c4` varchar(10) NOT NULL
3094 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3095 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3096 SHOW TABLES;
3097 Tables_in_test
3098 t1
3099 SHOW CREATE TABLE t1;
3100 Table Create Table
3101 t1 CREATE TABLE `t1` (
3102 `c1` timestamp NOT NULL,
3103 `c2` bigint NOT NULL,
3104 `c3` int DEFAULT NULL,
3105 `c4` varchar(10) NOT NULL,
3106 PRIMARY KEY (`c1`,`c2`)
3107 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3108 DROP TABLE t1;
3109 SHOW TABLES;
3110 Tables_in_test
3111 CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3112 SHOW TABLES;
3113 Tables_in_test
3114 t1
3115 SHOW CREATE TABLE t1;
3116 Table Create Table
3117 t1 CREATE TABLE `t1` (
3118 `c1` year NOT NULL,
3119 `c2` bigint NOT NULL,
3120 `c3` int DEFAULT NULL,
3121 `c4` varchar(10) NOT NULL
3122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3123 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3124 SHOW TABLES;
3125 Tables_in_test
3126 t1
3127 SHOW CREATE TABLE t1;
3128 Table Create Table
3129 t1 CREATE TABLE `t1` (
3130 `c1` year NOT NULL,
3131 `c2` bigint NOT NULL,
3132 `c3` int DEFAULT NULL,
3133 `c4` varchar(10) NOT NULL,
3134 PRIMARY KEY (`c1`,`c2`)
3135 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3136 DROP TABLE t1;
3137 SHOW TABLES;
3138 Tables_in_test
3139 CREATE TABLE t1(c1 BIT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3140 SHOW TABLES;
3141 Tables_in_test
3142 t1
3143 SHOW CREATE TABLE t1;
3144 Table Create Table
3145 t1 CREATE TABLE `t1` (
3146 `c1` bit(1) NOT NULL,
3147 `c2` double NOT NULL,
3148 `c3` int DEFAULT NULL,
3149 `c4` varchar(10) NOT NULL
3150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3151 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3152 SHOW TABLES;
3153 Tables_in_test
3154 t1
3155 SHOW CREATE TABLE t1;
3156 Table Create Table
3157 t1 CREATE TABLE `t1` (
3158 `c1` bit(1) NOT NULL,
3159 `c2` double NOT NULL,
3160 `c3` int DEFAULT NULL,
3161 `c4` varchar(10) NOT NULL,
3162 PRIMARY KEY (`c1`,`c2`)
3163 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3164 DROP TABLE t1;
3165 SHOW TABLES;
3166 Tables_in_test
3167 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3168 SHOW TABLES;
3169 Tables_in_test
3170 t1
3171 SHOW CREATE TABLE t1;
3172 Table Create Table
3173 t1 CREATE TABLE `t1` (
3174 `c1` tinyint NOT NULL,
3175 `c2` double NOT NULL,
3176 `c3` int DEFAULT NULL,
3177 `c4` varchar(10) NOT NULL
3178 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3179 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3180 SHOW TABLES;
3181 Tables_in_test
3182 t1
3183 SHOW CREATE TABLE t1;
3184 Table Create Table
3185 t1 CREATE TABLE `t1` (
3186 `c1` tinyint NOT NULL,
3187 `c2` double NOT NULL,
3188 `c3` int DEFAULT NULL,
3189 `c4` varchar(10) NOT NULL,
3190 PRIMARY KEY (`c1`,`c2`)
3191 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3192 DROP TABLE t1;
3193 SHOW TABLES;
3194 Tables_in_test
3195 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3196 SHOW TABLES;
3197 Tables_in_test
3198 t1
3199 SHOW CREATE TABLE t1;
3200 Table Create Table
3201 t1 CREATE TABLE `t1` (
3202 `c1` smallint NOT NULL,
3203 `c2` double NOT NULL,
3204 `c3` int DEFAULT NULL,
3205 `c4` varchar(10) NOT NULL
3206 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3207 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3208 SHOW TABLES;
3209 Tables_in_test
3210 t1
3211 SHOW CREATE TABLE t1;
3212 Table Create Table
3213 t1 CREATE TABLE `t1` (
3214 `c1` smallint NOT NULL,
3215 `c2` double NOT NULL,
3216 `c3` int DEFAULT NULL,
3217 `c4` varchar(10) NOT NULL,
3218 PRIMARY KEY (`c1`,`c2`)
3219 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3220 DROP TABLE t1;
3221 SHOW TABLES;
3222 Tables_in_test
3223 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3224 SHOW TABLES;
3225 Tables_in_test
3226 t1
3227 SHOW CREATE TABLE t1;
3228 Table Create Table
3229 t1 CREATE TABLE `t1` (
3230 `c1` mediumint NOT NULL,
3231 `c2` double NOT NULL,
3232 `c3` int DEFAULT NULL,
3233 `c4` varchar(10) NOT NULL
3234 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3235 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3236 SHOW TABLES;
3237 Tables_in_test
3238 t1
3239 SHOW CREATE TABLE t1;
3240 Table Create Table
3241 t1 CREATE TABLE `t1` (
3242 `c1` mediumint NOT NULL,
3243 `c2` double NOT NULL,
3244 `c3` int DEFAULT NULL,
3245 `c4` varchar(10) NOT NULL,
3246 PRIMARY KEY (`c1`,`c2`)
3247 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3248 DROP TABLE t1;
3249 SHOW TABLES;
3250 Tables_in_test
3251 CREATE TABLE t1(c1 INT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3252 SHOW TABLES;
3253 Tables_in_test
3254 t1
3255 SHOW CREATE TABLE t1;
3256 Table Create Table
3257 t1 CREATE TABLE `t1` (
3258 `c1` int NOT NULL,
3259 `c2` double NOT NULL,
3260 `c3` int DEFAULT NULL,
3261 `c4` varchar(10) NOT NULL
3262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3263 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3264 SHOW TABLES;
3265 Tables_in_test
3266 t1
3267 SHOW CREATE TABLE t1;
3268 Table Create Table
3269 t1 CREATE TABLE `t1` (
3270 `c1` int NOT NULL,
3271 `c2` double NOT NULL,
3272 `c3` int DEFAULT NULL,
3273 `c4` varchar(10) NOT NULL,
3274 PRIMARY KEY (`c1`,`c2`)
3275 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3276 DROP TABLE t1;
3277 SHOW TABLES;
3278 Tables_in_test
3279 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3280 SHOW TABLES;
3281 Tables_in_test
3282 t1
3283 SHOW CREATE TABLE t1;
3284 Table Create Table
3285 t1 CREATE TABLE `t1` (
3286 `c1` int NOT NULL,
3287 `c2` double NOT NULL,
3288 `c3` int DEFAULT NULL,
3289 `c4` varchar(10) NOT NULL
3290 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3291 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3292 SHOW TABLES;
3293 Tables_in_test
3294 t1
3295 SHOW CREATE TABLE t1;
3296 Table Create Table
3297 t1 CREATE TABLE `t1` (
3298 `c1` int NOT NULL,
3299 `c2` double NOT NULL,
3300 `c3` int DEFAULT NULL,
3301 `c4` varchar(10) NOT NULL,
3302 PRIMARY KEY (`c1`,`c2`)
3303 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3304 DROP TABLE t1;
3305 SHOW TABLES;
3306 Tables_in_test
3307 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3308 SHOW TABLES;
3309 Tables_in_test
3310 t1
3311 SHOW CREATE TABLE t1;
3312 Table Create Table
3313 t1 CREATE TABLE `t1` (
3314 `c1` bigint NOT NULL,
3315 `c2` double NOT NULL,
3316 `c3` int DEFAULT NULL,
3317 `c4` varchar(10) NOT NULL
3318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3319 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3320 SHOW TABLES;
3321 Tables_in_test
3322 t1
3323 SHOW CREATE TABLE t1;
3324 Table Create Table
3325 t1 CREATE TABLE `t1` (
3326 `c1` bigint NOT NULL,
3327 `c2` double NOT NULL,
3328 `c3` int DEFAULT NULL,
3329 `c4` varchar(10) NOT NULL,
3330 PRIMARY KEY (`c1`,`c2`)
3331 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3332 DROP TABLE t1;
3333 SHOW TABLES;
3334 Tables_in_test
3335 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3336 SHOW TABLES;
3337 Tables_in_test
3338 t1
3339 SHOW CREATE TABLE t1;
3340 Table Create Table
3341 t1 CREATE TABLE `t1` (
3342 `c1` double NOT NULL,
3343 `c2` double NOT NULL,
3344 `c3` int DEFAULT NULL,
3345 `c4` varchar(10) NOT NULL
3346 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3347 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3348 SHOW TABLES;
3349 Tables_in_test
3350 t1
3351 SHOW CREATE TABLE t1;
3352 Table Create Table
3353 t1 CREATE TABLE `t1` (
3354 `c1` double NOT NULL,
3355 `c2` double NOT NULL,
3356 `c3` int DEFAULT NULL,
3357 `c4` varchar(10) NOT NULL,
3358 PRIMARY KEY (`c1`,`c2`)
3359 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3360 DROP TABLE t1;
3361 SHOW TABLES;
3362 Tables_in_test
3363 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3364 SHOW TABLES;
3365 Tables_in_test
3366 t1
3367 SHOW CREATE TABLE t1;
3368 Table Create Table
3369 t1 CREATE TABLE `t1` (
3370 `c1` double NOT NULL,
3371 `c2` double NOT NULL,
3372 `c3` int DEFAULT NULL,
3373 `c4` varchar(10) NOT NULL
3374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3375 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3376 SHOW TABLES;
3377 Tables_in_test
3378 t1
3379 SHOW CREATE TABLE t1;
3380 Table Create Table
3381 t1 CREATE TABLE `t1` (
3382 `c1` double NOT NULL,
3383 `c2` double NOT NULL,
3384 `c3` int DEFAULT NULL,
3385 `c4` varchar(10) NOT NULL,
3386 PRIMARY KEY (`c1`,`c2`)
3387 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3388 DROP TABLE t1;
3389 SHOW TABLES;
3390 Tables_in_test
3391 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3392 SHOW TABLES;
3393 Tables_in_test
3394 t1
3395 SHOW CREATE TABLE t1;
3396 Table Create Table
3397 t1 CREATE TABLE `t1` (
3398 `c1` float NOT NULL,
3399 `c2` double NOT NULL,
3400 `c3` int DEFAULT NULL,
3401 `c4` varchar(10) NOT NULL
3402 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3403 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3404 SHOW TABLES;
3405 Tables_in_test
3406 t1
3407 SHOW CREATE TABLE t1;
3408 Table Create Table
3409 t1 CREATE TABLE `t1` (
3410 `c1` float NOT NULL,
3411 `c2` double NOT NULL,
3412 `c3` int DEFAULT NULL,
3413 `c4` varchar(10) NOT NULL,
3414 PRIMARY KEY (`c1`,`c2`)
3415 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3416 DROP TABLE t1;
3417 SHOW TABLES;
3418 Tables_in_test
3419 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3420 SHOW TABLES;
3421 Tables_in_test
3422 t1
3423 SHOW CREATE TABLE t1;
3424 Table Create Table
3425 t1 CREATE TABLE `t1` (
3426 `c1` decimal(10,0) NOT NULL,
3427 `c2` double NOT NULL,
3428 `c3` int DEFAULT NULL,
3429 `c4` varchar(10) NOT NULL
3430 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3431 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3432 SHOW TABLES;
3433 Tables_in_test
3434 t1
3435 SHOW CREATE TABLE t1;
3436 Table Create Table
3437 t1 CREATE TABLE `t1` (
3438 `c1` decimal(10,0) NOT NULL,
3439 `c2` double NOT NULL,
3440 `c3` int DEFAULT NULL,
3441 `c4` varchar(10) NOT NULL,
3442 PRIMARY KEY (`c1`,`c2`)
3443 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3444 DROP TABLE t1;
3445 SHOW TABLES;
3446 Tables_in_test
3447 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3448 SHOW TABLES;
3449 Tables_in_test
3450 t1
3451 SHOW CREATE TABLE t1;
3452 Table Create Table
3453 t1 CREATE TABLE `t1` (
3454 `c1` decimal(10,0) NOT NULL,
3455 `c2` double NOT NULL,
3456 `c3` int DEFAULT NULL,
3457 `c4` varchar(10) NOT NULL
3458 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3459 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3460 SHOW TABLES;
3461 Tables_in_test
3462 t1
3463 SHOW CREATE TABLE t1;
3464 Table Create Table
3465 t1 CREATE TABLE `t1` (
3466 `c1` decimal(10,0) NOT NULL,
3467 `c2` double NOT NULL,
3468 `c3` int DEFAULT NULL,
3469 `c4` varchar(10) NOT NULL,
3470 PRIMARY KEY (`c1`,`c2`)
3471 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3472 DROP TABLE t1;
3473 SHOW TABLES;
3474 Tables_in_test
3475 CREATE TABLE t1(c1 DATE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3476 SHOW TABLES;
3477 Tables_in_test
3478 t1
3479 SHOW CREATE TABLE t1;
3480 Table Create Table
3481 t1 CREATE TABLE `t1` (
3482 `c1` date NOT NULL,
3483 `c2` double NOT NULL,
3484 `c3` int DEFAULT NULL,
3485 `c4` varchar(10) NOT NULL
3486 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3487 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3488 SHOW TABLES;
3489 Tables_in_test
3490 t1
3491 SHOW CREATE TABLE t1;
3492 Table Create Table
3493 t1 CREATE TABLE `t1` (
3494 `c1` date NOT NULL,
3495 `c2` double NOT NULL,
3496 `c3` int DEFAULT NULL,
3497 `c4` varchar(10) NOT NULL,
3498 PRIMARY KEY (`c1`,`c2`)
3499 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3500 DROP TABLE t1;
3501 SHOW TABLES;
3502 Tables_in_test
3503 CREATE TABLE t1(c1 TIME NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3504 SHOW TABLES;
3505 Tables_in_test
3506 t1
3507 SHOW CREATE TABLE t1;
3508 Table Create Table
3509 t1 CREATE TABLE `t1` (
3510 `c1` time NOT NULL,
3511 `c2` double NOT NULL,
3512 `c3` int DEFAULT NULL,
3513 `c4` varchar(10) NOT NULL
3514 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3515 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3516 SHOW TABLES;
3517 Tables_in_test
3518 t1
3519 SHOW CREATE TABLE t1;
3520 Table Create Table
3521 t1 CREATE TABLE `t1` (
3522 `c1` time NOT NULL,
3523 `c2` double NOT NULL,
3524 `c3` int DEFAULT NULL,
3525 `c4` varchar(10) NOT NULL,
3526 PRIMARY KEY (`c1`,`c2`)
3527 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3528 DROP TABLE t1;
3529 SHOW TABLES;
3530 Tables_in_test
3531 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3532 SHOW TABLES;
3533 Tables_in_test
3534 t1
3535 SHOW CREATE TABLE t1;
3536 Table Create Table
3537 t1 CREATE TABLE `t1` (
3538 `c1` timestamp NOT NULL,
3539 `c2` double NOT NULL,
3540 `c3` int DEFAULT NULL,
3541 `c4` varchar(10) NOT NULL
3542 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3543 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3544 SHOW TABLES;
3545 Tables_in_test
3546 t1
3547 SHOW CREATE TABLE t1;
3548 Table Create Table
3549 t1 CREATE TABLE `t1` (
3550 `c1` timestamp NOT NULL,
3551 `c2` double NOT NULL,
3552 `c3` int DEFAULT NULL,
3553 `c4` varchar(10) NOT NULL,
3554 PRIMARY KEY (`c1`,`c2`)
3555 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3556 DROP TABLE t1;
3557 SHOW TABLES;
3558 Tables_in_test
3559 CREATE TABLE t1(c1 YEAR NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3560 SHOW TABLES;
3561 Tables_in_test
3562 t1
3563 SHOW CREATE TABLE t1;
3564 Table Create Table
3565 t1 CREATE TABLE `t1` (
3566 `c1` year NOT NULL,
3567 `c2` double NOT NULL,
3568 `c3` int DEFAULT NULL,
3569 `c4` varchar(10) NOT NULL
3570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3571 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3572 SHOW TABLES;
3573 Tables_in_test
3574 t1
3575 SHOW CREATE TABLE t1;
3576 Table Create Table
3577 t1 CREATE TABLE `t1` (
3578 `c1` year NOT NULL,
3579 `c2` double NOT NULL,
3580 `c3` int DEFAULT NULL,
3581 `c4` varchar(10) NOT NULL,
3582 PRIMARY KEY (`c1`,`c2`)
3583 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3584 DROP TABLE t1;
3585 SHOW TABLES;
3586 Tables_in_test
3587 CREATE TABLE t1(c1 BIT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3588 SHOW TABLES;
3589 Tables_in_test
3590 t1
3591 SHOW CREATE TABLE t1;
3592 Table Create Table
3593 t1 CREATE TABLE `t1` (
3594 `c1` bit(1) NOT NULL,
3595 `c2` double NOT NULL,
3596 `c3` int DEFAULT NULL,
3597 `c4` varchar(10) NOT NULL
3598 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3599 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3600 SHOW TABLES;
3601 Tables_in_test
3602 t1
3603 SHOW CREATE TABLE t1;
3604 Table Create Table
3605 t1 CREATE TABLE `t1` (
3606 `c1` bit(1) NOT NULL,
3607 `c2` double NOT NULL,
3608 `c3` int DEFAULT NULL,
3609 `c4` varchar(10) NOT NULL,
3610 PRIMARY KEY (`c1`,`c2`)
3611 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3612 DROP TABLE t1;
3613 SHOW TABLES;
3614 Tables_in_test
3615 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3616 SHOW TABLES;
3617 Tables_in_test
3618 t1
3619 SHOW CREATE TABLE t1;
3620 Table Create Table
3621 t1 CREATE TABLE `t1` (
3622 `c1` tinyint NOT NULL,
3623 `c2` double NOT NULL,
3624 `c3` int DEFAULT NULL,
3625 `c4` varchar(10) NOT NULL
3626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3627 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3628 SHOW TABLES;
3629 Tables_in_test
3630 t1
3631 SHOW CREATE TABLE t1;
3632 Table Create Table
3633 t1 CREATE TABLE `t1` (
3634 `c1` tinyint NOT NULL,
3635 `c2` double NOT NULL,
3636 `c3` int DEFAULT NULL,
3637 `c4` varchar(10) NOT NULL,
3638 PRIMARY KEY (`c1`,`c2`)
3639 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3640 DROP TABLE t1;
3641 SHOW TABLES;
3642 Tables_in_test
3643 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3644 SHOW TABLES;
3645 Tables_in_test
3646 t1
3647 SHOW CREATE TABLE t1;
3648 Table Create Table
3649 t1 CREATE TABLE `t1` (
3650 `c1` smallint NOT NULL,
3651 `c2` double NOT NULL,
3652 `c3` int DEFAULT NULL,
3653 `c4` varchar(10) NOT NULL
3654 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3655 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3656 SHOW TABLES;
3657 Tables_in_test
3658 t1
3659 SHOW CREATE TABLE t1;
3660 Table Create Table
3661 t1 CREATE TABLE `t1` (
3662 `c1` smallint NOT NULL,
3663 `c2` double NOT NULL,
3664 `c3` int DEFAULT NULL,
3665 `c4` varchar(10) NOT NULL,
3666 PRIMARY KEY (`c1`,`c2`)
3667 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3668 DROP TABLE t1;
3669 SHOW TABLES;
3670 Tables_in_test
3671 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3672 SHOW TABLES;
3673 Tables_in_test
3674 t1
3675 SHOW CREATE TABLE t1;
3676 Table Create Table
3677 t1 CREATE TABLE `t1` (
3678 `c1` mediumint NOT NULL,
3679 `c2` double NOT NULL,
3680 `c3` int DEFAULT NULL,
3681 `c4` varchar(10) NOT NULL
3682 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3683 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3684 SHOW TABLES;
3685 Tables_in_test
3686 t1
3687 SHOW CREATE TABLE t1;
3688 Table Create Table
3689 t1 CREATE TABLE `t1` (
3690 `c1` mediumint NOT NULL,
3691 `c2` double NOT NULL,
3692 `c3` int DEFAULT NULL,
3693 `c4` varchar(10) NOT NULL,
3694 PRIMARY KEY (`c1`,`c2`)
3695 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3696 DROP TABLE t1;
3697 SHOW TABLES;
3698 Tables_in_test
3699 CREATE TABLE t1(c1 INT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3700 SHOW TABLES;
3701 Tables_in_test
3702 t1
3703 SHOW CREATE TABLE t1;
3704 Table Create Table
3705 t1 CREATE TABLE `t1` (
3706 `c1` int NOT NULL,
3707 `c2` double NOT NULL,
3708 `c3` int DEFAULT NULL,
3709 `c4` varchar(10) NOT NULL
3710 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3711 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3712 SHOW TABLES;
3713 Tables_in_test
3714 t1
3715 SHOW CREATE TABLE t1;
3716 Table Create Table
3717 t1 CREATE TABLE `t1` (
3718 `c1` int NOT NULL,
3719 `c2` double NOT NULL,
3720 `c3` int DEFAULT NULL,
3721 `c4` varchar(10) NOT NULL,
3722 PRIMARY KEY (`c1`,`c2`)
3723 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3724 DROP TABLE t1;
3725 SHOW TABLES;
3726 Tables_in_test
3727 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3728 SHOW TABLES;
3729 Tables_in_test
3730 t1
3731 SHOW CREATE TABLE t1;
3732 Table Create Table
3733 t1 CREATE TABLE `t1` (
3734 `c1` int NOT NULL,
3735 `c2` double NOT NULL,
3736 `c3` int DEFAULT NULL,
3737 `c4` varchar(10) NOT NULL
3738 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3739 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3740 SHOW TABLES;
3741 Tables_in_test
3742 t1
3743 SHOW CREATE TABLE t1;
3744 Table Create Table
3745 t1 CREATE TABLE `t1` (
3746 `c1` int NOT NULL,
3747 `c2` double NOT NULL,
3748 `c3` int DEFAULT NULL,
3749 `c4` varchar(10) NOT NULL,
3750 PRIMARY KEY (`c1`,`c2`)
3751 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3752 DROP TABLE t1;
3753 SHOW TABLES;
3754 Tables_in_test
3755 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3756 SHOW TABLES;
3757 Tables_in_test
3758 t1
3759 SHOW CREATE TABLE t1;
3760 Table Create Table
3761 t1 CREATE TABLE `t1` (
3762 `c1` bigint NOT NULL,
3763 `c2` double NOT NULL,
3764 `c3` int DEFAULT NULL,
3765 `c4` varchar(10) NOT NULL
3766 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3767 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3768 SHOW TABLES;
3769 Tables_in_test
3770 t1
3771 SHOW CREATE TABLE t1;
3772 Table Create Table
3773 t1 CREATE TABLE `t1` (
3774 `c1` bigint NOT NULL,
3775 `c2` double NOT NULL,
3776 `c3` int DEFAULT NULL,
3777 `c4` varchar(10) NOT NULL,
3778 PRIMARY KEY (`c1`,`c2`)
3779 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3780 DROP TABLE t1;
3781 SHOW TABLES;
3782 Tables_in_test
3783 CREATE TABLE t1(c1 REAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3784 SHOW TABLES;
3785 Tables_in_test
3786 t1
3787 SHOW CREATE TABLE t1;
3788 Table Create Table
3789 t1 CREATE TABLE `t1` (
3790 `c1` double NOT NULL,
3791 `c2` double NOT NULL,
3792 `c3` int DEFAULT NULL,
3793 `c4` varchar(10) NOT NULL
3794 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3795 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3796 SHOW TABLES;
3797 Tables_in_test
3798 t1
3799 SHOW CREATE TABLE t1;
3800 Table Create Table
3801 t1 CREATE TABLE `t1` (
3802 `c1` double NOT NULL,
3803 `c2` double NOT NULL,
3804 `c3` int DEFAULT NULL,
3805 `c4` varchar(10) NOT NULL,
3806 PRIMARY KEY (`c1`,`c2`)
3807 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3808 DROP TABLE t1;
3809 SHOW TABLES;
3810 Tables_in_test
3811 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3812 SHOW TABLES;
3813 Tables_in_test
3814 t1
3815 SHOW CREATE TABLE t1;
3816 Table Create Table
3817 t1 CREATE TABLE `t1` (
3818 `c1` double NOT NULL,
3819 `c2` double NOT NULL,
3820 `c3` int DEFAULT NULL,
3821 `c4` varchar(10) NOT NULL
3822 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3823 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3824 SHOW TABLES;
3825 Tables_in_test
3826 t1
3827 SHOW CREATE TABLE t1;
3828 Table Create Table
3829 t1 CREATE TABLE `t1` (
3830 `c1` double NOT NULL,
3831 `c2` double NOT NULL,
3832 `c3` int DEFAULT NULL,
3833 `c4` varchar(10) NOT NULL,
3834 PRIMARY KEY (`c1`,`c2`)
3835 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3836 DROP TABLE t1;
3837 SHOW TABLES;
3838 Tables_in_test
3839 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3840 SHOW TABLES;
3841 Tables_in_test
3842 t1
3843 SHOW CREATE TABLE t1;
3844 Table Create Table
3845 t1 CREATE TABLE `t1` (
3846 `c1` float NOT NULL,
3847 `c2` double NOT NULL,
3848 `c3` int DEFAULT NULL,
3849 `c4` varchar(10) NOT NULL
3850 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3851 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3852 SHOW TABLES;
3853 Tables_in_test
3854 t1
3855 SHOW CREATE TABLE t1;
3856 Table Create Table
3857 t1 CREATE TABLE `t1` (
3858 `c1` float NOT NULL,
3859 `c2` double NOT NULL,
3860 `c3` int DEFAULT NULL,
3861 `c4` varchar(10) NOT NULL,
3862 PRIMARY KEY (`c1`,`c2`)
3863 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3864 DROP TABLE t1;
3865 SHOW TABLES;
3866 Tables_in_test
3867 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3868 SHOW TABLES;
3869 Tables_in_test
3870 t1
3871 SHOW CREATE TABLE t1;
3872 Table Create Table
3873 t1 CREATE TABLE `t1` (
3874 `c1` decimal(10,0) NOT NULL,
3875 `c2` double NOT NULL,
3876 `c3` int DEFAULT NULL,
3877 `c4` varchar(10) NOT NULL
3878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3879 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3880 SHOW TABLES;
3881 Tables_in_test
3882 t1
3883 SHOW CREATE TABLE t1;
3884 Table Create Table
3885 t1 CREATE TABLE `t1` (
3886 `c1` decimal(10,0) NOT NULL,
3887 `c2` double NOT NULL,
3888 `c3` int DEFAULT NULL,
3889 `c4` varchar(10) NOT NULL,
3890 PRIMARY KEY (`c1`,`c2`)
3891 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3892 DROP TABLE t1;
3893 SHOW TABLES;
3894 Tables_in_test
3895 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3896 SHOW TABLES;
3897 Tables_in_test
3898 t1
3899 SHOW CREATE TABLE t1;
3900 Table Create Table
3901 t1 CREATE TABLE `t1` (
3902 `c1` decimal(10,0) NOT NULL,
3903 `c2` double NOT NULL,
3904 `c3` int DEFAULT NULL,
3905 `c4` varchar(10) NOT NULL
3906 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3907 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3908 SHOW TABLES;
3909 Tables_in_test
3910 t1
3911 SHOW CREATE TABLE t1;
3912 Table Create Table
3913 t1 CREATE TABLE `t1` (
3914 `c1` decimal(10,0) NOT NULL,
3915 `c2` double NOT NULL,
3916 `c3` int DEFAULT NULL,
3917 `c4` varchar(10) NOT NULL,
3918 PRIMARY KEY (`c1`,`c2`)
3919 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3920 DROP TABLE t1;
3921 SHOW TABLES;
3922 Tables_in_test
3923 CREATE TABLE t1(c1 DATE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3924 SHOW TABLES;
3925 Tables_in_test
3926 t1
3927 SHOW CREATE TABLE t1;
3928 Table Create Table
3929 t1 CREATE TABLE `t1` (
3930 `c1` date NOT NULL,
3931 `c2` double NOT NULL,
3932 `c3` int DEFAULT NULL,
3933 `c4` varchar(10) NOT NULL
3934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3935 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3936 SHOW TABLES;
3937 Tables_in_test
3938 t1
3939 SHOW CREATE TABLE t1;
3940 Table Create Table
3941 t1 CREATE TABLE `t1` (
3942 `c1` date NOT NULL,
3943 `c2` double NOT NULL,
3944 `c3` int DEFAULT NULL,
3945 `c4` varchar(10) NOT NULL,
3946 PRIMARY KEY (`c1`,`c2`)
3947 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3948 DROP TABLE t1;
3949 SHOW TABLES;
3950 Tables_in_test
3951 CREATE TABLE t1(c1 TIME NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3952 SHOW TABLES;
3953 Tables_in_test
3954 t1
3955 SHOW CREATE TABLE t1;
3956 Table Create Table
3957 t1 CREATE TABLE `t1` (
3958 `c1` time NOT NULL,
3959 `c2` double NOT NULL,
3960 `c3` int DEFAULT NULL,
3961 `c4` varchar(10) NOT NULL
3962 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3963 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3964 SHOW TABLES;
3965 Tables_in_test
3966 t1
3967 SHOW CREATE TABLE t1;
3968 Table Create Table
3969 t1 CREATE TABLE `t1` (
3970 `c1` time NOT NULL,
3971 `c2` double NOT NULL,
3972 `c3` int DEFAULT NULL,
3973 `c4` varchar(10) NOT NULL,
3974 PRIMARY KEY (`c1`,`c2`)
3975 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3976 DROP TABLE t1;
3977 SHOW TABLES;
3978 Tables_in_test
3979 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3980 SHOW TABLES;
3981 Tables_in_test
3982 t1
3983 SHOW CREATE TABLE t1;
3984 Table Create Table
3985 t1 CREATE TABLE `t1` (
3986 `c1` timestamp NOT NULL,
3987 `c2` double NOT NULL,
3988 `c3` int DEFAULT NULL,
3989 `c4` varchar(10) NOT NULL
3990 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3991 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3992 SHOW TABLES;
3993 Tables_in_test
3994 t1
3995 SHOW CREATE TABLE t1;
3996 Table Create Table
3997 t1 CREATE TABLE `t1` (
3998 `c1` timestamp NOT NULL,
3999 `c2` double NOT NULL,
4000 `c3` int DEFAULT NULL,
4001 `c4` varchar(10) NOT NULL,
4002 PRIMARY KEY (`c1`,`c2`)
4003 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4004 DROP TABLE t1;
4005 SHOW TABLES;
4006 Tables_in_test
4007 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4008 SHOW TABLES;
4009 Tables_in_test
4010 t1
4011 SHOW CREATE TABLE t1;
4012 Table Create Table
4013 t1 CREATE TABLE `t1` (
4014 `c1` year NOT NULL,
4015 `c2` double NOT NULL,
4016 `c3` int DEFAULT NULL,
4017 `c4` varchar(10) NOT NULL
4018 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4019 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4020 SHOW TABLES;
4021 Tables_in_test
4022 t1
4023 SHOW CREATE TABLE t1;
4024 Table Create Table
4025 t1 CREATE TABLE `t1` (
4026 `c1` year NOT NULL,
4027 `c2` double NOT NULL,
4028 `c3` int DEFAULT NULL,
4029 `c4` varchar(10) NOT NULL,
4030 PRIMARY KEY (`c1`,`c2`)
4031 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4032 DROP TABLE t1;
4033 SHOW TABLES;
4034 Tables_in_test
4035 CREATE TABLE t1(c1 BIT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4036 SHOW TABLES;
4037 Tables_in_test
4038 t1
4039 SHOW CREATE TABLE t1;
4040 Table Create Table
4041 t1 CREATE TABLE `t1` (
4042 `c1` bit(1) NOT NULL,
4043 `c2` float NOT NULL,
4044 `c3` int DEFAULT NULL,
4045 `c4` varchar(10) NOT NULL
4046 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4047 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4048 SHOW TABLES;
4049 Tables_in_test
4050 t1
4051 SHOW CREATE TABLE t1;
4052 Table Create Table
4053 t1 CREATE TABLE `t1` (
4054 `c1` bit(1) NOT NULL,
4055 `c2` float NOT NULL,
4056 `c3` int DEFAULT NULL,
4057 `c4` varchar(10) NOT NULL,
4058 PRIMARY KEY (`c1`,`c2`)
4059 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4060 DROP TABLE t1;
4061 SHOW TABLES;
4062 Tables_in_test
4063 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4064 SHOW TABLES;
4065 Tables_in_test
4066 t1
4067 SHOW CREATE TABLE t1;
4068 Table Create Table
4069 t1 CREATE TABLE `t1` (
4070 `c1` tinyint NOT NULL,
4071 `c2` float NOT NULL,
4072 `c3` int DEFAULT NULL,
4073 `c4` varchar(10) NOT NULL
4074 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4075 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4076 SHOW TABLES;
4077 Tables_in_test
4078 t1
4079 SHOW CREATE TABLE t1;
4080 Table Create Table
4081 t1 CREATE TABLE `t1` (
4082 `c1` tinyint NOT NULL,
4083 `c2` float NOT NULL,
4084 `c3` int DEFAULT NULL,
4085 `c4` varchar(10) NOT NULL,
4086 PRIMARY KEY (`c1`,`c2`)
4087 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4088 DROP TABLE t1;
4089 SHOW TABLES;
4090 Tables_in_test
4091 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4092 SHOW TABLES;
4093 Tables_in_test
4094 t1
4095 SHOW CREATE TABLE t1;
4096 Table Create Table
4097 t1 CREATE TABLE `t1` (
4098 `c1` smallint NOT NULL,
4099 `c2` float NOT NULL,
4100 `c3` int DEFAULT NULL,
4101 `c4` varchar(10) NOT NULL
4102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4103 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4104 SHOW TABLES;
4105 Tables_in_test
4106 t1
4107 SHOW CREATE TABLE t1;
4108 Table Create Table
4109 t1 CREATE TABLE `t1` (
4110 `c1` smallint NOT NULL,
4111 `c2` float NOT NULL,
4112 `c3` int DEFAULT NULL,
4113 `c4` varchar(10) NOT NULL,
4114 PRIMARY KEY (`c1`,`c2`)
4115 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4116 DROP TABLE t1;
4117 SHOW TABLES;
4118 Tables_in_test
4119 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4120 SHOW TABLES;
4121 Tables_in_test
4122 t1
4123 SHOW CREATE TABLE t1;
4124 Table Create Table
4125 t1 CREATE TABLE `t1` (
4126 `c1` mediumint NOT NULL,
4127 `c2` float NOT NULL,
4128 `c3` int DEFAULT NULL,
4129 `c4` varchar(10) NOT NULL
4130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4131 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4132 SHOW TABLES;
4133 Tables_in_test
4134 t1
4135 SHOW CREATE TABLE t1;
4136 Table Create Table
4137 t1 CREATE TABLE `t1` (
4138 `c1` mediumint NOT NULL,
4139 `c2` float NOT NULL,
4140 `c3` int DEFAULT NULL,
4141 `c4` varchar(10) NOT NULL,
4142 PRIMARY KEY (`c1`,`c2`)
4143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4144 DROP TABLE t1;
4145 SHOW TABLES;
4146 Tables_in_test
4147 CREATE TABLE t1(c1 INT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4148 SHOW TABLES;
4149 Tables_in_test
4150 t1
4151 SHOW CREATE TABLE t1;
4152 Table Create Table
4153 t1 CREATE TABLE `t1` (
4154 `c1` int NOT NULL,
4155 `c2` float NOT NULL,
4156 `c3` int DEFAULT NULL,
4157 `c4` varchar(10) NOT NULL
4158 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4159 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4160 SHOW TABLES;
4161 Tables_in_test
4162 t1
4163 SHOW CREATE TABLE t1;
4164 Table Create Table
4165 t1 CREATE TABLE `t1` (
4166 `c1` int NOT NULL,
4167 `c2` float NOT NULL,
4168 `c3` int DEFAULT NULL,
4169 `c4` varchar(10) NOT NULL,
4170 PRIMARY KEY (`c1`,`c2`)
4171 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4172 DROP TABLE t1;
4173 SHOW TABLES;
4174 Tables_in_test
4175 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4176 SHOW TABLES;
4177 Tables_in_test
4178 t1
4179 SHOW CREATE TABLE t1;
4180 Table Create Table
4181 t1 CREATE TABLE `t1` (
4182 `c1` int NOT NULL,
4183 `c2` float NOT NULL,
4184 `c3` int DEFAULT NULL,
4185 `c4` varchar(10) NOT NULL
4186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4187 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4188 SHOW TABLES;
4189 Tables_in_test
4190 t1
4191 SHOW CREATE TABLE t1;
4192 Table Create Table
4193 t1 CREATE TABLE `t1` (
4194 `c1` int NOT NULL,
4195 `c2` float NOT NULL,
4196 `c3` int DEFAULT NULL,
4197 `c4` varchar(10) NOT NULL,
4198 PRIMARY KEY (`c1`,`c2`)
4199 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4200 DROP TABLE t1;
4201 SHOW TABLES;
4202 Tables_in_test
4203 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4204 SHOW TABLES;
4205 Tables_in_test
4206 t1
4207 SHOW CREATE TABLE t1;
4208 Table Create Table
4209 t1 CREATE TABLE `t1` (
4210 `c1` bigint NOT NULL,
4211 `c2` float NOT NULL,
4212 `c3` int DEFAULT NULL,
4213 `c4` varchar(10) NOT NULL
4214 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4215 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4216 SHOW TABLES;
4217 Tables_in_test
4218 t1
4219 SHOW CREATE TABLE t1;
4220 Table Create Table
4221 t1 CREATE TABLE `t1` (
4222 `c1` bigint NOT NULL,
4223 `c2` float NOT NULL,
4224 `c3` int DEFAULT NULL,
4225 `c4` varchar(10) NOT NULL,
4226 PRIMARY KEY (`c1`,`c2`)
4227 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4228 DROP TABLE t1;
4229 SHOW TABLES;
4230 Tables_in_test
4231 CREATE TABLE t1(c1 REAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4232 SHOW TABLES;
4233 Tables_in_test
4234 t1
4235 SHOW CREATE TABLE t1;
4236 Table Create Table
4237 t1 CREATE TABLE `t1` (
4238 `c1` double NOT NULL,
4239 `c2` float NOT NULL,
4240 `c3` int DEFAULT NULL,
4241 `c4` varchar(10) NOT NULL
4242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4243 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4244 SHOW TABLES;
4245 Tables_in_test
4246 t1
4247 SHOW CREATE TABLE t1;
4248 Table Create Table
4249 t1 CREATE TABLE `t1` (
4250 `c1` double NOT NULL,
4251 `c2` float NOT NULL,
4252 `c3` int DEFAULT NULL,
4253 `c4` varchar(10) NOT NULL,
4254 PRIMARY KEY (`c1`,`c2`)
4255 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4256 DROP TABLE t1;
4257 SHOW TABLES;
4258 Tables_in_test
4259 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4260 SHOW TABLES;
4261 Tables_in_test
4262 t1
4263 SHOW CREATE TABLE t1;
4264 Table Create Table
4265 t1 CREATE TABLE `t1` (
4266 `c1` double NOT NULL,
4267 `c2` float NOT NULL,
4268 `c3` int DEFAULT NULL,
4269 `c4` varchar(10) NOT NULL
4270 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4271 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4272 SHOW TABLES;
4273 Tables_in_test
4274 t1
4275 SHOW CREATE TABLE t1;
4276 Table Create Table
4277 t1 CREATE TABLE `t1` (
4278 `c1` double NOT NULL,
4279 `c2` float NOT NULL,
4280 `c3` int DEFAULT NULL,
4281 `c4` varchar(10) NOT NULL,
4282 PRIMARY KEY (`c1`,`c2`)
4283 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4284 DROP TABLE t1;
4285 SHOW TABLES;
4286 Tables_in_test
4287 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4288 SHOW TABLES;
4289 Tables_in_test
4290 t1
4291 SHOW CREATE TABLE t1;
4292 Table Create Table
4293 t1 CREATE TABLE `t1` (
4294 `c1` float NOT NULL,
4295 `c2` float NOT NULL,
4296 `c3` int DEFAULT NULL,
4297 `c4` varchar(10) NOT NULL
4298 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4299 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4300 SHOW TABLES;
4301 Tables_in_test
4302 t1
4303 SHOW CREATE TABLE t1;
4304 Table Create Table
4305 t1 CREATE TABLE `t1` (
4306 `c1` float NOT NULL,
4307 `c2` float NOT NULL,
4308 `c3` int DEFAULT NULL,
4309 `c4` varchar(10) NOT NULL,
4310 PRIMARY KEY (`c1`,`c2`)
4311 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4312 DROP TABLE t1;
4313 SHOW TABLES;
4314 Tables_in_test
4315 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4316 SHOW TABLES;
4317 Tables_in_test
4318 t1
4319 SHOW CREATE TABLE t1;
4320 Table Create Table
4321 t1 CREATE TABLE `t1` (
4322 `c1` decimal(10,0) NOT NULL,
4323 `c2` float NOT NULL,
4324 `c3` int DEFAULT NULL,
4325 `c4` varchar(10) NOT NULL
4326 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4327 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4328 SHOW TABLES;
4329 Tables_in_test
4330 t1
4331 SHOW CREATE TABLE t1;
4332 Table Create Table
4333 t1 CREATE TABLE `t1` (
4334 `c1` decimal(10,0) NOT NULL,
4335 `c2` float NOT NULL,
4336 `c3` int DEFAULT NULL,
4337 `c4` varchar(10) NOT NULL,
4338 PRIMARY KEY (`c1`,`c2`)
4339 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4340 DROP TABLE t1;
4341 SHOW TABLES;
4342 Tables_in_test
4343 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4344 SHOW TABLES;
4345 Tables_in_test
4346 t1
4347 SHOW CREATE TABLE t1;
4348 Table Create Table
4349 t1 CREATE TABLE `t1` (
4350 `c1` decimal(10,0) NOT NULL,
4351 `c2` float NOT NULL,
4352 `c3` int DEFAULT NULL,
4353 `c4` varchar(10) NOT NULL
4354 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4355 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4356 SHOW TABLES;
4357 Tables_in_test
4358 t1
4359 SHOW CREATE TABLE t1;
4360 Table Create Table
4361 t1 CREATE TABLE `t1` (
4362 `c1` decimal(10,0) NOT NULL,
4363 `c2` float NOT NULL,
4364 `c3` int DEFAULT NULL,
4365 `c4` varchar(10) NOT NULL,
4366 PRIMARY KEY (`c1`,`c2`)
4367 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4368 DROP TABLE t1;
4369 SHOW TABLES;
4370 Tables_in_test
4371 CREATE TABLE t1(c1 DATE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4372 SHOW TABLES;
4373 Tables_in_test
4374 t1
4375 SHOW CREATE TABLE t1;
4376 Table Create Table
4377 t1 CREATE TABLE `t1` (
4378 `c1` date NOT NULL,
4379 `c2` float NOT NULL,
4380 `c3` int DEFAULT NULL,
4381 `c4` varchar(10) NOT NULL
4382 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4383 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4384 SHOW TABLES;
4385 Tables_in_test
4386 t1
4387 SHOW CREATE TABLE t1;
4388 Table Create Table
4389 t1 CREATE TABLE `t1` (
4390 `c1` date NOT NULL,
4391 `c2` float NOT NULL,
4392 `c3` int DEFAULT NULL,
4393 `c4` varchar(10) NOT NULL,
4394 PRIMARY KEY (`c1`,`c2`)
4395 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4396 DROP TABLE t1;
4397 SHOW TABLES;
4398 Tables_in_test
4399 CREATE TABLE t1(c1 TIME NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4400 SHOW TABLES;
4401 Tables_in_test
4402 t1
4403 SHOW CREATE TABLE t1;
4404 Table Create Table
4405 t1 CREATE TABLE `t1` (
4406 `c1` time NOT NULL,
4407 `c2` float NOT NULL,
4408 `c3` int DEFAULT NULL,
4409 `c4` varchar(10) NOT NULL
4410 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4411 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4412 SHOW TABLES;
4413 Tables_in_test
4414 t1
4415 SHOW CREATE TABLE t1;
4416 Table Create Table
4417 t1 CREATE TABLE `t1` (
4418 `c1` time NOT NULL,
4419 `c2` float NOT NULL,
4420 `c3` int DEFAULT NULL,
4421 `c4` varchar(10) NOT NULL,
4422 PRIMARY KEY (`c1`,`c2`)
4423 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4424 DROP TABLE t1;
4425 SHOW TABLES;
4426 Tables_in_test
4427 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4428 SHOW TABLES;
4429 Tables_in_test
4430 t1
4431 SHOW CREATE TABLE t1;
4432 Table Create Table
4433 t1 CREATE TABLE `t1` (
4434 `c1` timestamp NOT NULL,
4435 `c2` float NOT NULL,
4436 `c3` int DEFAULT NULL,
4437 `c4` varchar(10) NOT NULL
4438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4439 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4440 SHOW TABLES;
4441 Tables_in_test
4442 t1
4443 SHOW CREATE TABLE t1;
4444 Table Create Table
4445 t1 CREATE TABLE `t1` (
4446 `c1` timestamp NOT NULL,
4447 `c2` float NOT NULL,
4448 `c3` int DEFAULT NULL,
4449 `c4` varchar(10) NOT NULL,
4450 PRIMARY KEY (`c1`,`c2`)
4451 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4452 DROP TABLE t1;
4453 SHOW TABLES;
4454 Tables_in_test
4455 CREATE TABLE t1(c1 YEAR NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4456 SHOW TABLES;
4457 Tables_in_test
4458 t1
4459 SHOW CREATE TABLE t1;
4460 Table Create Table
4461 t1 CREATE TABLE `t1` (
4462 `c1` year NOT NULL,
4463 `c2` float NOT NULL,
4464 `c3` int DEFAULT NULL,
4465 `c4` varchar(10) NOT NULL
4466 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4467 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4468 SHOW TABLES;
4469 Tables_in_test
4470 t1
4471 SHOW CREATE TABLE t1;
4472 Table Create Table
4473 t1 CREATE TABLE `t1` (
4474 `c1` year NOT NULL,
4475 `c2` float NOT NULL,
4476 `c3` int DEFAULT NULL,
4477 `c4` varchar(10) NOT NULL,
4478 PRIMARY KEY (`c1`,`c2`)
4479 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4480 DROP TABLE t1;
4481 SHOW TABLES;
4482 Tables_in_test
4483 CREATE TABLE t1(c1 BIT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4484 SHOW TABLES;
4485 Tables_in_test
4486 t1
4487 SHOW CREATE TABLE t1;
4488 Table Create Table
4489 t1 CREATE TABLE `t1` (
4490 `c1` bit(1) NOT NULL,
4491 `c2` decimal(10,0) NOT NULL,
4492 `c3` int DEFAULT NULL,
4493 `c4` varchar(10) NOT NULL
4494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4495 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4496 SHOW TABLES;
4497 Tables_in_test
4498 t1
4499 SHOW CREATE TABLE t1;
4500 Table Create Table
4501 t1 CREATE TABLE `t1` (
4502 `c1` bit(1) NOT NULL,
4503 `c2` decimal(10,0) NOT NULL,
4504 `c3` int DEFAULT NULL,
4505 `c4` varchar(10) NOT NULL,
4506 PRIMARY KEY (`c1`,`c2`)
4507 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4508 DROP TABLE t1;
4509 SHOW TABLES;
4510 Tables_in_test
4511 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4512 SHOW TABLES;
4513 Tables_in_test
4514 t1
4515 SHOW CREATE TABLE t1;
4516 Table Create Table
4517 t1 CREATE TABLE `t1` (
4518 `c1` tinyint NOT NULL,
4519 `c2` decimal(10,0) NOT NULL,
4520 `c3` int DEFAULT NULL,
4521 `c4` varchar(10) NOT NULL
4522 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4523 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4524 SHOW TABLES;
4525 Tables_in_test
4526 t1
4527 SHOW CREATE TABLE t1;
4528 Table Create Table
4529 t1 CREATE TABLE `t1` (
4530 `c1` tinyint NOT NULL,
4531 `c2` decimal(10,0) NOT NULL,
4532 `c3` int DEFAULT NULL,
4533 `c4` varchar(10) NOT NULL,
4534 PRIMARY KEY (`c1`,`c2`)
4535 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4536 DROP TABLE t1;
4537 SHOW TABLES;
4538 Tables_in_test
4539 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4540 SHOW TABLES;
4541 Tables_in_test
4542 t1
4543 SHOW CREATE TABLE t1;
4544 Table Create Table
4545 t1 CREATE TABLE `t1` (
4546 `c1` smallint NOT NULL,
4547 `c2` decimal(10,0) NOT NULL,
4548 `c3` int DEFAULT NULL,
4549 `c4` varchar(10) NOT NULL
4550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4551 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4552 SHOW TABLES;
4553 Tables_in_test
4554 t1
4555 SHOW CREATE TABLE t1;
4556 Table Create Table
4557 t1 CREATE TABLE `t1` (
4558 `c1` smallint NOT NULL,
4559 `c2` decimal(10,0) NOT NULL,
4560 `c3` int DEFAULT NULL,
4561 `c4` varchar(10) NOT NULL,
4562 PRIMARY KEY (`c1`,`c2`)
4563 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4564 DROP TABLE t1;
4565 SHOW TABLES;
4566 Tables_in_test
4567 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4568 SHOW TABLES;
4569 Tables_in_test
4570 t1
4571 SHOW CREATE TABLE t1;
4572 Table Create Table
4573 t1 CREATE TABLE `t1` (
4574 `c1` mediumint NOT NULL,
4575 `c2` decimal(10,0) NOT NULL,
4576 `c3` int DEFAULT NULL,
4577 `c4` varchar(10) NOT NULL
4578 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4579 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4580 SHOW TABLES;
4581 Tables_in_test
4582 t1
4583 SHOW CREATE TABLE t1;
4584 Table Create Table
4585 t1 CREATE TABLE `t1` (
4586 `c1` mediumint NOT NULL,
4587 `c2` decimal(10,0) NOT NULL,
4588 `c3` int DEFAULT NULL,
4589 `c4` varchar(10) NOT NULL,
4590 PRIMARY KEY (`c1`,`c2`)
4591 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4592 DROP TABLE t1;
4593 SHOW TABLES;
4594 Tables_in_test
4595 CREATE TABLE t1(c1 INT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4596 SHOW TABLES;
4597 Tables_in_test
4598 t1
4599 SHOW CREATE TABLE t1;
4600 Table Create Table
4601 t1 CREATE TABLE `t1` (
4602 `c1` int NOT NULL,
4603 `c2` decimal(10,0) NOT NULL,
4604 `c3` int DEFAULT NULL,
4605 `c4` varchar(10) NOT NULL
4606 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4607 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4608 SHOW TABLES;
4609 Tables_in_test
4610 t1
4611 SHOW CREATE TABLE t1;
4612 Table Create Table
4613 t1 CREATE TABLE `t1` (
4614 `c1` int NOT NULL,
4615 `c2` decimal(10,0) NOT NULL,
4616 `c3` int DEFAULT NULL,
4617 `c4` varchar(10) NOT NULL,
4618 PRIMARY KEY (`c1`,`c2`)
4619 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4620 DROP TABLE t1;
4621 SHOW TABLES;
4622 Tables_in_test
4623 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4624 SHOW TABLES;
4625 Tables_in_test
4626 t1
4627 SHOW CREATE TABLE t1;
4628 Table Create Table
4629 t1 CREATE TABLE `t1` (
4630 `c1` int NOT NULL,
4631 `c2` decimal(10,0) NOT NULL,
4632 `c3` int DEFAULT NULL,
4633 `c4` varchar(10) NOT NULL
4634 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4635 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4636 SHOW TABLES;
4637 Tables_in_test
4638 t1
4639 SHOW CREATE TABLE t1;
4640 Table Create Table
4641 t1 CREATE TABLE `t1` (
4642 `c1` int NOT NULL,
4643 `c2` decimal(10,0) NOT NULL,
4644 `c3` int DEFAULT NULL,
4645 `c4` varchar(10) NOT NULL,
4646 PRIMARY KEY (`c1`,`c2`)
4647 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4648 DROP TABLE t1;
4649 SHOW TABLES;
4650 Tables_in_test
4651 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4652 SHOW TABLES;
4653 Tables_in_test
4654 t1
4655 SHOW CREATE TABLE t1;
4656 Table Create Table
4657 t1 CREATE TABLE `t1` (
4658 `c1` bigint NOT NULL,
4659 `c2` decimal(10,0) NOT NULL,
4660 `c3` int DEFAULT NULL,
4661 `c4` varchar(10) NOT NULL
4662 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4663 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4664 SHOW TABLES;
4665 Tables_in_test
4666 t1
4667 SHOW CREATE TABLE t1;
4668 Table Create Table
4669 t1 CREATE TABLE `t1` (
4670 `c1` bigint NOT NULL,
4671 `c2` decimal(10,0) NOT NULL,
4672 `c3` int DEFAULT NULL,
4673 `c4` varchar(10) NOT NULL,
4674 PRIMARY KEY (`c1`,`c2`)
4675 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4676 DROP TABLE t1;
4677 SHOW TABLES;
4678 Tables_in_test
4679 CREATE TABLE t1(c1 REAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4680 SHOW TABLES;
4681 Tables_in_test
4682 t1
4683 SHOW CREATE TABLE t1;
4684 Table Create Table
4685 t1 CREATE TABLE `t1` (
4686 `c1` double NOT NULL,
4687 `c2` decimal(10,0) NOT NULL,
4688 `c3` int DEFAULT NULL,
4689 `c4` varchar(10) NOT NULL
4690 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4691 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4692 SHOW TABLES;
4693 Tables_in_test
4694 t1
4695 SHOW CREATE TABLE t1;
4696 Table Create Table
4697 t1 CREATE TABLE `t1` (
4698 `c1` double NOT NULL,
4699 `c2` decimal(10,0) NOT NULL,
4700 `c3` int DEFAULT NULL,
4701 `c4` varchar(10) NOT NULL,
4702 PRIMARY KEY (`c1`,`c2`)
4703 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4704 DROP TABLE t1;
4705 SHOW TABLES;
4706 Tables_in_test
4707 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4708 SHOW TABLES;
4709 Tables_in_test
4710 t1
4711 SHOW CREATE TABLE t1;
4712 Table Create Table
4713 t1 CREATE TABLE `t1` (
4714 `c1` double NOT NULL,
4715 `c2` decimal(10,0) NOT NULL,
4716 `c3` int DEFAULT NULL,
4717 `c4` varchar(10) NOT NULL
4718 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4719 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4720 SHOW TABLES;
4721 Tables_in_test
4722 t1
4723 SHOW CREATE TABLE t1;
4724 Table Create Table
4725 t1 CREATE TABLE `t1` (
4726 `c1` double NOT NULL,
4727 `c2` decimal(10,0) NOT NULL,
4728 `c3` int DEFAULT NULL,
4729 `c4` varchar(10) NOT NULL,
4730 PRIMARY KEY (`c1`,`c2`)
4731 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4732 DROP TABLE t1;
4733 SHOW TABLES;
4734 Tables_in_test
4735 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4736 SHOW TABLES;
4737 Tables_in_test
4738 t1
4739 SHOW CREATE TABLE t1;
4740 Table Create Table
4741 t1 CREATE TABLE `t1` (
4742 `c1` float NOT NULL,
4743 `c2` decimal(10,0) NOT NULL,
4744 `c3` int DEFAULT NULL,
4745 `c4` varchar(10) NOT NULL
4746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4747 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4748 SHOW TABLES;
4749 Tables_in_test
4750 t1
4751 SHOW CREATE TABLE t1;
4752 Table Create Table
4753 t1 CREATE TABLE `t1` (
4754 `c1` float NOT NULL,
4755 `c2` decimal(10,0) NOT NULL,
4756 `c3` int DEFAULT NULL,
4757 `c4` varchar(10) NOT NULL,
4758 PRIMARY KEY (`c1`,`c2`)
4759 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4760 DROP TABLE t1;
4761 SHOW TABLES;
4762 Tables_in_test
4763 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4764 SHOW TABLES;
4765 Tables_in_test
4766 t1
4767 SHOW CREATE TABLE t1;
4768 Table Create Table
4769 t1 CREATE TABLE `t1` (
4770 `c1` decimal(10,0) NOT NULL,
4771 `c2` decimal(10,0) NOT NULL,
4772 `c3` int DEFAULT NULL,
4773 `c4` varchar(10) NOT NULL
4774 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4775 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4776 SHOW TABLES;
4777 Tables_in_test
4778 t1
4779 SHOW CREATE TABLE t1;
4780 Table Create Table
4781 t1 CREATE TABLE `t1` (
4782 `c1` decimal(10,0) NOT NULL,
4783 `c2` decimal(10,0) NOT NULL,
4784 `c3` int DEFAULT NULL,
4785 `c4` varchar(10) NOT NULL,
4786 PRIMARY KEY (`c1`,`c2`)
4787 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4788 DROP TABLE t1;
4789 SHOW TABLES;
4790 Tables_in_test
4791 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4792 SHOW TABLES;
4793 Tables_in_test
4794 t1
4795 SHOW CREATE TABLE t1;
4796 Table Create Table
4797 t1 CREATE TABLE `t1` (
4798 `c1` decimal(10,0) NOT NULL,
4799 `c2` decimal(10,0) NOT NULL,
4800 `c3` int DEFAULT NULL,
4801 `c4` varchar(10) NOT NULL
4802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4803 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4804 SHOW TABLES;
4805 Tables_in_test
4806 t1
4807 SHOW CREATE TABLE t1;
4808 Table Create Table
4809 t1 CREATE TABLE `t1` (
4810 `c1` decimal(10,0) NOT NULL,
4811 `c2` decimal(10,0) NOT NULL,
4812 `c3` int DEFAULT NULL,
4813 `c4` varchar(10) NOT NULL,
4814 PRIMARY KEY (`c1`,`c2`)
4815 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4816 DROP TABLE t1;
4817 SHOW TABLES;
4818 Tables_in_test
4819 CREATE TABLE t1(c1 DATE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4820 SHOW TABLES;
4821 Tables_in_test
4822 t1
4823 SHOW CREATE TABLE t1;
4824 Table Create Table
4825 t1 CREATE TABLE `t1` (
4826 `c1` date NOT NULL,
4827 `c2` decimal(10,0) NOT NULL,
4828 `c3` int DEFAULT NULL,
4829 `c4` varchar(10) NOT NULL
4830 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4831 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4832 SHOW TABLES;
4833 Tables_in_test
4834 t1
4835 SHOW CREATE TABLE t1;
4836 Table Create Table
4837 t1 CREATE TABLE `t1` (
4838 `c1` date NOT NULL,
4839 `c2` decimal(10,0) NOT NULL,
4840 `c3` int DEFAULT NULL,
4841 `c4` varchar(10) NOT NULL,
4842 PRIMARY KEY (`c1`,`c2`)
4843 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4844 DROP TABLE t1;
4845 SHOW TABLES;
4846 Tables_in_test
4847 CREATE TABLE t1(c1 TIME NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4848 SHOW TABLES;
4849 Tables_in_test
4850 t1
4851 SHOW CREATE TABLE t1;
4852 Table Create Table
4853 t1 CREATE TABLE `t1` (
4854 `c1` time NOT NULL,
4855 `c2` decimal(10,0) NOT NULL,
4856 `c3` int DEFAULT NULL,
4857 `c4` varchar(10) NOT NULL
4858 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4859 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4860 SHOW TABLES;
4861 Tables_in_test
4862 t1
4863 SHOW CREATE TABLE t1;
4864 Table Create Table
4865 t1 CREATE TABLE `t1` (
4866 `c1` time NOT NULL,
4867 `c2` decimal(10,0) NOT NULL,
4868 `c3` int DEFAULT NULL,
4869 `c4` varchar(10) NOT NULL,
4870 PRIMARY KEY (`c1`,`c2`)
4871 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4872 DROP TABLE t1;
4873 SHOW TABLES;
4874 Tables_in_test
4875 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4876 SHOW TABLES;
4877 Tables_in_test
4878 t1
4879 SHOW CREATE TABLE t1;
4880 Table Create Table
4881 t1 CREATE TABLE `t1` (
4882 `c1` timestamp NOT NULL,
4883 `c2` decimal(10,0) NOT NULL,
4884 `c3` int DEFAULT NULL,
4885 `c4` varchar(10) NOT NULL
4886 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4887 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4888 SHOW TABLES;
4889 Tables_in_test
4890 t1
4891 SHOW CREATE TABLE t1;
4892 Table Create Table
4893 t1 CREATE TABLE `t1` (
4894 `c1` timestamp NOT NULL,
4895 `c2` decimal(10,0) NOT NULL,
4896 `c3` int DEFAULT NULL,
4897 `c4` varchar(10) NOT NULL,
4898 PRIMARY KEY (`c1`,`c2`)
4899 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4900 DROP TABLE t1;
4901 SHOW TABLES;
4902 Tables_in_test
4903 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4904 SHOW TABLES;
4905 Tables_in_test
4906 t1
4907 SHOW CREATE TABLE t1;
4908 Table Create Table
4909 t1 CREATE TABLE `t1` (
4910 `c1` year NOT NULL,
4911 `c2` decimal(10,0) NOT NULL,
4912 `c3` int DEFAULT NULL,
4913 `c4` varchar(10) NOT NULL
4914 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4915 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4916 SHOW TABLES;
4917 Tables_in_test
4918 t1
4919 SHOW CREATE TABLE t1;
4920 Table Create Table
4921 t1 CREATE TABLE `t1` (
4922 `c1` year NOT NULL,
4923 `c2` decimal(10,0) NOT NULL,
4924 `c3` int DEFAULT NULL,
4925 `c4` varchar(10) NOT NULL,
4926 PRIMARY KEY (`c1`,`c2`)
4927 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4928 DROP TABLE t1;
4929 SHOW TABLES;
4930 Tables_in_test
4931 CREATE TABLE t1(c1 BIT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4932 SHOW TABLES;
4933 Tables_in_test
4934 t1
4935 SHOW CREATE TABLE t1;
4936 Table Create Table
4937 t1 CREATE TABLE `t1` (
4938 `c1` bit(1) NOT NULL,
4939 `c2` decimal(10,0) NOT NULL,
4940 `c3` int DEFAULT NULL,
4941 `c4` varchar(10) NOT NULL
4942 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4943 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4944 SHOW TABLES;
4945 Tables_in_test
4946 t1
4947 SHOW CREATE TABLE t1;
4948 Table Create Table
4949 t1 CREATE TABLE `t1` (
4950 `c1` bit(1) NOT NULL,
4951 `c2` decimal(10,0) NOT NULL,
4952 `c3` int DEFAULT NULL,
4953 `c4` varchar(10) NOT NULL,
4954 PRIMARY KEY (`c1`,`c2`)
4955 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4956 DROP TABLE t1;
4957 SHOW TABLES;
4958 Tables_in_test
4959 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4960 SHOW TABLES;
4961 Tables_in_test
4962 t1
4963 SHOW CREATE TABLE t1;
4964 Table Create Table
4965 t1 CREATE TABLE `t1` (
4966 `c1` tinyint NOT NULL,
4967 `c2` decimal(10,0) NOT NULL,
4968 `c3` int DEFAULT NULL,
4969 `c4` varchar(10) NOT NULL
4970 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4971 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4972 SHOW TABLES;
4973 Tables_in_test
4974 t1
4975 SHOW CREATE TABLE t1;
4976 Table Create Table
4977 t1 CREATE TABLE `t1` (
4978 `c1` tinyint NOT NULL,
4979 `c2` decimal(10,0) NOT NULL,
4980 `c3` int DEFAULT NULL,
4981 `c4` varchar(10) NOT NULL,
4982 PRIMARY KEY (`c1`,`c2`)
4983 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4984 DROP TABLE t1;
4985 SHOW TABLES;
4986 Tables_in_test
4987 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4988 SHOW TABLES;
4989 Tables_in_test
4990 t1
4991 SHOW CREATE TABLE t1;
4992 Table Create Table
4993 t1 CREATE TABLE `t1` (
4994 `c1` smallint NOT NULL,
4995 `c2` decimal(10,0) NOT NULL,
4996 `c3` int DEFAULT NULL,
4997 `c4` varchar(10) NOT NULL
4998 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4999 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5000 SHOW TABLES;
5001 Tables_in_test
5002 t1
5003 SHOW CREATE TABLE t1;
5004 Table Create Table
5005 t1 CREATE TABLE `t1` (
5006 `c1` smallint NOT NULL,
5007 `c2` decimal(10,0) NOT NULL,
5008 `c3` int DEFAULT NULL,
5009 `c4` varchar(10) NOT NULL,
5010 PRIMARY KEY (`c1`,`c2`)
5011 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5012 DROP TABLE t1;
5013 SHOW TABLES;
5014 Tables_in_test
5015 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5016 SHOW TABLES;
5017 Tables_in_test
5018 t1
5019 SHOW CREATE TABLE t1;
5020 Table Create Table
5021 t1 CREATE TABLE `t1` (
5022 `c1` mediumint NOT NULL,
5023 `c2` decimal(10,0) NOT NULL,
5024 `c3` int DEFAULT NULL,
5025 `c4` varchar(10) NOT NULL
5026 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5027 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5028 SHOW TABLES;
5029 Tables_in_test
5030 t1
5031 SHOW CREATE TABLE t1;
5032 Table Create Table
5033 t1 CREATE TABLE `t1` (
5034 `c1` mediumint NOT NULL,
5035 `c2` decimal(10,0) NOT NULL,
5036 `c3` int DEFAULT NULL,
5037 `c4` varchar(10) NOT NULL,
5038 PRIMARY KEY (`c1`,`c2`)
5039 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5040 DROP TABLE t1;
5041 SHOW TABLES;
5042 Tables_in_test
5043 CREATE TABLE t1(c1 INT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5044 SHOW TABLES;
5045 Tables_in_test
5046 t1
5047 SHOW CREATE TABLE t1;
5048 Table Create Table
5049 t1 CREATE TABLE `t1` (
5050 `c1` int NOT NULL,
5051 `c2` decimal(10,0) NOT NULL,
5052 `c3` int DEFAULT NULL,
5053 `c4` varchar(10) NOT NULL
5054 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5055 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5056 SHOW TABLES;
5057 Tables_in_test
5058 t1
5059 SHOW CREATE TABLE t1;
5060 Table Create Table
5061 t1 CREATE TABLE `t1` (
5062 `c1` int NOT NULL,
5063 `c2` decimal(10,0) NOT NULL,
5064 `c3` int DEFAULT NULL,
5065 `c4` varchar(10) NOT NULL,
5066 PRIMARY KEY (`c1`,`c2`)
5067 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5068 DROP TABLE t1;
5069 SHOW TABLES;
5070 Tables_in_test
5071 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5072 SHOW TABLES;
5073 Tables_in_test
5074 t1
5075 SHOW CREATE TABLE t1;
5076 Table Create Table
5077 t1 CREATE TABLE `t1` (
5078 `c1` int NOT NULL,
5079 `c2` decimal(10,0) NOT NULL,
5080 `c3` int DEFAULT NULL,
5081 `c4` varchar(10) NOT NULL
5082 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5083 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5084 SHOW TABLES;
5085 Tables_in_test
5086 t1
5087 SHOW CREATE TABLE t1;
5088 Table Create Table
5089 t1 CREATE TABLE `t1` (
5090 `c1` int NOT NULL,
5091 `c2` decimal(10,0) NOT NULL,
5092 `c3` int DEFAULT NULL,
5093 `c4` varchar(10) NOT NULL,
5094 PRIMARY KEY (`c1`,`c2`)
5095 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5096 DROP TABLE t1;
5097 SHOW TABLES;
5098 Tables_in_test
5099 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5100 SHOW TABLES;
5101 Tables_in_test
5102 t1
5103 SHOW CREATE TABLE t1;
5104 Table Create Table
5105 t1 CREATE TABLE `t1` (
5106 `c1` bigint NOT NULL,
5107 `c2` decimal(10,0) NOT NULL,
5108 `c3` int DEFAULT NULL,
5109 `c4` varchar(10) NOT NULL
5110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5111 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5112 SHOW TABLES;
5113 Tables_in_test
5114 t1
5115 SHOW CREATE TABLE t1;
5116 Table Create Table
5117 t1 CREATE TABLE `t1` (
5118 `c1` bigint NOT NULL,
5119 `c2` decimal(10,0) NOT NULL,
5120 `c3` int DEFAULT NULL,
5121 `c4` varchar(10) NOT NULL,
5122 PRIMARY KEY (`c1`,`c2`)
5123 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5124 DROP TABLE t1;
5125 SHOW TABLES;
5126 Tables_in_test
5127 CREATE TABLE t1(c1 REAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5128 SHOW TABLES;
5129 Tables_in_test
5130 t1
5131 SHOW CREATE TABLE t1;
5132 Table Create Table
5133 t1 CREATE TABLE `t1` (
5134 `c1` double NOT NULL,
5135 `c2` decimal(10,0) NOT NULL,
5136 `c3` int DEFAULT NULL,
5137 `c4` varchar(10) NOT NULL
5138 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5139 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5140 SHOW TABLES;
5141 Tables_in_test
5142 t1
5143 SHOW CREATE TABLE t1;
5144 Table Create Table
5145 t1 CREATE TABLE `t1` (
5146 `c1` double NOT NULL,
5147 `c2` decimal(10,0) NOT NULL,
5148 `c3` int DEFAULT NULL,
5149 `c4` varchar(10) NOT NULL,
5150 PRIMARY KEY (`c1`,`c2`)
5151 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5152 DROP TABLE t1;
5153 SHOW TABLES;
5154 Tables_in_test
5155 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5156 SHOW TABLES;
5157 Tables_in_test
5158 t1
5159 SHOW CREATE TABLE t1;
5160 Table Create Table
5161 t1 CREATE TABLE `t1` (
5162 `c1` double NOT NULL,
5163 `c2` decimal(10,0) NOT NULL,
5164 `c3` int DEFAULT NULL,
5165 `c4` varchar(10) NOT NULL
5166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5167 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5168 SHOW TABLES;
5169 Tables_in_test
5170 t1
5171 SHOW CREATE TABLE t1;
5172 Table Create Table
5173 t1 CREATE TABLE `t1` (
5174 `c1` double NOT NULL,
5175 `c2` decimal(10,0) NOT NULL,
5176 `c3` int DEFAULT NULL,
5177 `c4` varchar(10) NOT NULL,
5178 PRIMARY KEY (`c1`,`c2`)
5179 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5180 DROP TABLE t1;
5181 SHOW TABLES;
5182 Tables_in_test
5183 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5184 SHOW TABLES;
5185 Tables_in_test
5186 t1
5187 SHOW CREATE TABLE t1;
5188 Table Create Table
5189 t1 CREATE TABLE `t1` (
5190 `c1` float NOT NULL,
5191 `c2` decimal(10,0) NOT NULL,
5192 `c3` int DEFAULT NULL,
5193 `c4` varchar(10) NOT NULL
5194 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5195 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5196 SHOW TABLES;
5197 Tables_in_test
5198 t1
5199 SHOW CREATE TABLE t1;
5200 Table Create Table
5201 t1 CREATE TABLE `t1` (
5202 `c1` float NOT NULL,
5203 `c2` decimal(10,0) NOT NULL,
5204 `c3` int DEFAULT NULL,
5205 `c4` varchar(10) NOT NULL,
5206 PRIMARY KEY (`c1`,`c2`)
5207 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5208 DROP TABLE t1;
5209 SHOW TABLES;
5210 Tables_in_test
5211 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5212 SHOW TABLES;
5213 Tables_in_test
5214 t1
5215 SHOW CREATE TABLE t1;
5216 Table Create Table
5217 t1 CREATE TABLE `t1` (
5218 `c1` decimal(10,0) NOT NULL,
5219 `c2` decimal(10,0) NOT NULL,
5220 `c3` int DEFAULT NULL,
5221 `c4` varchar(10) NOT NULL
5222 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5223 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5224 SHOW TABLES;
5225 Tables_in_test
5226 t1
5227 SHOW CREATE TABLE t1;
5228 Table Create Table
5229 t1 CREATE TABLE `t1` (
5230 `c1` decimal(10,0) NOT NULL,
5231 `c2` decimal(10,0) NOT NULL,
5232 `c3` int DEFAULT NULL,
5233 `c4` varchar(10) NOT NULL,
5234 PRIMARY KEY (`c1`,`c2`)
5235 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5236 DROP TABLE t1;
5237 SHOW TABLES;
5238 Tables_in_test
5239 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5240 SHOW TABLES;
5241 Tables_in_test
5242 t1
5243 SHOW CREATE TABLE t1;
5244 Table Create Table
5245 t1 CREATE TABLE `t1` (
5246 `c1` decimal(10,0) NOT NULL,
5247 `c2` decimal(10,0) NOT NULL,
5248 `c3` int DEFAULT NULL,
5249 `c4` varchar(10) NOT NULL
5250 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5251 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5252 SHOW TABLES;
5253 Tables_in_test
5254 t1
5255 SHOW CREATE TABLE t1;
5256 Table Create Table
5257 t1 CREATE TABLE `t1` (
5258 `c1` decimal(10,0) NOT NULL,
5259 `c2` decimal(10,0) NOT NULL,
5260 `c3` int DEFAULT NULL,
5261 `c4` varchar(10) NOT NULL,
5262 PRIMARY KEY (`c1`,`c2`)
5263 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5264 DROP TABLE t1;
5265 SHOW TABLES;
5266 Tables_in_test
5267 CREATE TABLE t1(c1 DATE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5268 SHOW TABLES;
5269 Tables_in_test
5270 t1
5271 SHOW CREATE TABLE t1;
5272 Table Create Table
5273 t1 CREATE TABLE `t1` (
5274 `c1` date NOT NULL,
5275 `c2` decimal(10,0) NOT NULL,
5276 `c3` int DEFAULT NULL,
5277 `c4` varchar(10) NOT NULL
5278 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5279 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5280 SHOW TABLES;
5281 Tables_in_test
5282 t1
5283 SHOW CREATE TABLE t1;
5284 Table Create Table
5285 t1 CREATE TABLE `t1` (
5286 `c1` date NOT NULL,
5287 `c2` decimal(10,0) NOT NULL,
5288 `c3` int DEFAULT NULL,
5289 `c4` varchar(10) NOT NULL,
5290 PRIMARY KEY (`c1`,`c2`)
5291 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5292 DROP TABLE t1;
5293 SHOW TABLES;
5294 Tables_in_test
5295 CREATE TABLE t1(c1 TIME NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5296 SHOW TABLES;
5297 Tables_in_test
5298 t1
5299 SHOW CREATE TABLE t1;
5300 Table Create Table
5301 t1 CREATE TABLE `t1` (
5302 `c1` time NOT NULL,
5303 `c2` decimal(10,0) NOT NULL,
5304 `c3` int DEFAULT NULL,
5305 `c4` varchar(10) NOT NULL
5306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5307 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5308 SHOW TABLES;
5309 Tables_in_test
5310 t1
5311 SHOW CREATE TABLE t1;
5312 Table Create Table
5313 t1 CREATE TABLE `t1` (
5314 `c1` time NOT NULL,
5315 `c2` decimal(10,0) NOT NULL,
5316 `c3` int DEFAULT NULL,
5317 `c4` varchar(10) NOT NULL,
5318 PRIMARY KEY (`c1`,`c2`)
5319 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5320 DROP TABLE t1;
5321 SHOW TABLES;
5322 Tables_in_test
5323 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5324 SHOW TABLES;
5325 Tables_in_test
5326 t1
5327 SHOW CREATE TABLE t1;
5328 Table Create Table
5329 t1 CREATE TABLE `t1` (
5330 `c1` timestamp NOT NULL,
5331 `c2` decimal(10,0) NOT NULL,
5332 `c3` int DEFAULT NULL,
5333 `c4` varchar(10) NOT NULL
5334 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5335 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5336 SHOW TABLES;
5337 Tables_in_test
5338 t1
5339 SHOW CREATE TABLE t1;
5340 Table Create Table
5341 t1 CREATE TABLE `t1` (
5342 `c1` timestamp NOT NULL,
5343 `c2` decimal(10,0) NOT NULL,
5344 `c3` int DEFAULT NULL,
5345 `c4` varchar(10) NOT NULL,
5346 PRIMARY KEY (`c1`,`c2`)
5347 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5348 DROP TABLE t1;
5349 SHOW TABLES;
5350 Tables_in_test
5351 CREATE TABLE t1(c1 YEAR NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5352 SHOW TABLES;
5353 Tables_in_test
5354 t1
5355 SHOW CREATE TABLE t1;
5356 Table Create Table
5357 t1 CREATE TABLE `t1` (
5358 `c1` year NOT NULL,
5359 `c2` decimal(10,0) NOT NULL,
5360 `c3` int DEFAULT NULL,
5361 `c4` varchar(10) NOT NULL
5362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5363 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5364 SHOW TABLES;
5365 Tables_in_test
5366 t1
5367 SHOW CREATE TABLE t1;
5368 Table Create Table
5369 t1 CREATE TABLE `t1` (
5370 `c1` year NOT NULL,
5371 `c2` decimal(10,0) NOT NULL,
5372 `c3` int DEFAULT NULL,
5373 `c4` varchar(10) NOT NULL,
5374 PRIMARY KEY (`c1`,`c2`)
5375 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5376 DROP TABLE t1;
5377 SHOW TABLES;
5378 Tables_in_test
5379 CREATE TABLE t1(c1 BIT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5380 SHOW TABLES;
5381 Tables_in_test
5382 t1
5383 SHOW CREATE TABLE t1;
5384 Table Create Table
5385 t1 CREATE TABLE `t1` (
5386 `c1` bit(1) NOT NULL,
5387 `c2` date NOT NULL,
5388 `c3` int DEFAULT NULL,
5389 `c4` varchar(10) NOT NULL
5390 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5391 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5392 SHOW TABLES;
5393 Tables_in_test
5394 t1
5395 SHOW CREATE TABLE t1;
5396 Table Create Table
5397 t1 CREATE TABLE `t1` (
5398 `c1` bit(1) NOT NULL,
5399 `c2` date NOT NULL,
5400 `c3` int DEFAULT NULL,
5401 `c4` varchar(10) NOT NULL,
5402 PRIMARY KEY (`c1`,`c2`)
5403 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5404 DROP TABLE t1;
5405 SHOW TABLES;
5406 Tables_in_test
5407 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5408 SHOW TABLES;
5409 Tables_in_test
5410 t1
5411 SHOW CREATE TABLE t1;
5412 Table Create Table
5413 t1 CREATE TABLE `t1` (
5414 `c1` tinyint NOT NULL,
5415 `c2` date NOT NULL,
5416 `c3` int DEFAULT NULL,
5417 `c4` varchar(10) NOT NULL
5418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5419 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5420 SHOW TABLES;
5421 Tables_in_test
5422 t1
5423 SHOW CREATE TABLE t1;
5424 Table Create Table
5425 t1 CREATE TABLE `t1` (
5426 `c1` tinyint NOT NULL,
5427 `c2` date NOT NULL,
5428 `c3` int DEFAULT NULL,
5429 `c4` varchar(10) NOT NULL,
5430 PRIMARY KEY (`c1`,`c2`)
5431 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5432 DROP TABLE t1;
5433 SHOW TABLES;
5434 Tables_in_test
5435 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5436 SHOW TABLES;
5437 Tables_in_test
5438 t1
5439 SHOW CREATE TABLE t1;
5440 Table Create Table
5441 t1 CREATE TABLE `t1` (
5442 `c1` smallint NOT NULL,
5443 `c2` date NOT NULL,
5444 `c3` int DEFAULT NULL,
5445 `c4` varchar(10) NOT NULL
5446 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5447 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5448 SHOW TABLES;
5449 Tables_in_test
5450 t1
5451 SHOW CREATE TABLE t1;
5452 Table Create Table
5453 t1 CREATE TABLE `t1` (
5454 `c1` smallint NOT NULL,
5455 `c2` date NOT NULL,
5456 `c3` int DEFAULT NULL,
5457 `c4` varchar(10) NOT NULL,
5458 PRIMARY KEY (`c1`,`c2`)
5459 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5460 DROP TABLE t1;
5461 SHOW TABLES;
5462 Tables_in_test
5463 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5464 SHOW TABLES;
5465 Tables_in_test
5466 t1
5467 SHOW CREATE TABLE t1;
5468 Table Create Table
5469 t1 CREATE TABLE `t1` (
5470 `c1` mediumint NOT NULL,
5471 `c2` date NOT NULL,
5472 `c3` int DEFAULT NULL,
5473 `c4` varchar(10) NOT NULL
5474 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5475 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5476 SHOW TABLES;
5477 Tables_in_test
5478 t1
5479 SHOW CREATE TABLE t1;
5480 Table Create Table
5481 t1 CREATE TABLE `t1` (
5482 `c1` mediumint NOT NULL,
5483 `c2` date NOT NULL,
5484 `c3` int DEFAULT NULL,
5485 `c4` varchar(10) NOT NULL,
5486 PRIMARY KEY (`c1`,`c2`)
5487 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5488 DROP TABLE t1;
5489 SHOW TABLES;
5490 Tables_in_test
5491 CREATE TABLE t1(c1 INT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5492 SHOW TABLES;
5493 Tables_in_test
5494 t1
5495 SHOW CREATE TABLE t1;
5496 Table Create Table
5497 t1 CREATE TABLE `t1` (
5498 `c1` int NOT NULL,
5499 `c2` date NOT NULL,
5500 `c3` int DEFAULT NULL,
5501 `c4` varchar(10) NOT NULL
5502 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5503 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5504 SHOW TABLES;
5505 Tables_in_test
5506 t1
5507 SHOW CREATE TABLE t1;
5508 Table Create Table
5509 t1 CREATE TABLE `t1` (
5510 `c1` int NOT NULL,
5511 `c2` date NOT NULL,
5512 `c3` int DEFAULT NULL,
5513 `c4` varchar(10) NOT NULL,
5514 PRIMARY KEY (`c1`,`c2`)
5515 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5516 DROP TABLE t1;
5517 SHOW TABLES;
5518 Tables_in_test
5519 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5520 SHOW TABLES;
5521 Tables_in_test
5522 t1
5523 SHOW CREATE TABLE t1;
5524 Table Create Table
5525 t1 CREATE TABLE `t1` (
5526 `c1` int NOT NULL,
5527 `c2` date NOT NULL,
5528 `c3` int DEFAULT NULL,
5529 `c4` varchar(10) NOT NULL
5530 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5531 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5532 SHOW TABLES;
5533 Tables_in_test
5534 t1
5535 SHOW CREATE TABLE t1;
5536 Table Create Table
5537 t1 CREATE TABLE `t1` (
5538 `c1` int NOT NULL,
5539 `c2` date NOT NULL,
5540 `c3` int DEFAULT NULL,
5541 `c4` varchar(10) NOT NULL,
5542 PRIMARY KEY (`c1`,`c2`)
5543 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5544 DROP TABLE t1;
5545 SHOW TABLES;
5546 Tables_in_test
5547 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5548 SHOW TABLES;
5549 Tables_in_test
5550 t1
5551 SHOW CREATE TABLE t1;
5552 Table Create Table
5553 t1 CREATE TABLE `t1` (
5554 `c1` bigint NOT NULL,
5555 `c2` date NOT NULL,
5556 `c3` int DEFAULT NULL,
5557 `c4` varchar(10) NOT NULL
5558 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5559 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5560 SHOW TABLES;
5561 Tables_in_test
5562 t1
5563 SHOW CREATE TABLE t1;
5564 Table Create Table
5565 t1 CREATE TABLE `t1` (
5566 `c1` bigint NOT NULL,
5567 `c2` date NOT NULL,
5568 `c3` int DEFAULT NULL,
5569 `c4` varchar(10) NOT NULL,
5570 PRIMARY KEY (`c1`,`c2`)
5571 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5572 DROP TABLE t1;
5573 SHOW TABLES;
5574 Tables_in_test
5575 CREATE TABLE t1(c1 REAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5576 SHOW TABLES;
5577 Tables_in_test
5578 t1
5579 SHOW CREATE TABLE t1;
5580 Table Create Table
5581 t1 CREATE TABLE `t1` (
5582 `c1` double NOT NULL,
5583 `c2` date NOT NULL,
5584 `c3` int DEFAULT NULL,
5585 `c4` varchar(10) NOT NULL
5586 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5587 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5588 SHOW TABLES;
5589 Tables_in_test
5590 t1
5591 SHOW CREATE TABLE t1;
5592 Table Create Table
5593 t1 CREATE TABLE `t1` (
5594 `c1` double NOT NULL,
5595 `c2` date NOT NULL,
5596 `c3` int DEFAULT NULL,
5597 `c4` varchar(10) NOT NULL,
5598 PRIMARY KEY (`c1`,`c2`)
5599 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5600 DROP TABLE t1;
5601 SHOW TABLES;
5602 Tables_in_test
5603 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5604 SHOW TABLES;
5605 Tables_in_test
5606 t1
5607 SHOW CREATE TABLE t1;
5608 Table Create Table
5609 t1 CREATE TABLE `t1` (
5610 `c1` double NOT NULL,
5611 `c2` date NOT NULL,
5612 `c3` int DEFAULT NULL,
5613 `c4` varchar(10) NOT NULL
5614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5615 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5616 SHOW TABLES;
5617 Tables_in_test
5618 t1
5619 SHOW CREATE TABLE t1;
5620 Table Create Table
5621 t1 CREATE TABLE `t1` (
5622 `c1` double NOT NULL,
5623 `c2` date NOT NULL,
5624 `c3` int DEFAULT NULL,
5625 `c4` varchar(10) NOT NULL,
5626 PRIMARY KEY (`c1`,`c2`)
5627 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5628 DROP TABLE t1;
5629 SHOW TABLES;
5630 Tables_in_test
5631 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5632 SHOW TABLES;
5633 Tables_in_test
5634 t1
5635 SHOW CREATE TABLE t1;
5636 Table Create Table
5637 t1 CREATE TABLE `t1` (
5638 `c1` float NOT NULL,
5639 `c2` date NOT NULL,
5640 `c3` int DEFAULT NULL,
5641 `c4` varchar(10) NOT NULL
5642 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5643 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5644 SHOW TABLES;
5645 Tables_in_test
5646 t1
5647 SHOW CREATE TABLE t1;
5648 Table Create Table
5649 t1 CREATE TABLE `t1` (
5650 `c1` float NOT NULL,
5651 `c2` date NOT NULL,
5652 `c3` int DEFAULT NULL,
5653 `c4` varchar(10) NOT NULL,
5654 PRIMARY KEY (`c1`,`c2`)
5655 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5656 DROP TABLE t1;
5657 SHOW TABLES;
5658 Tables_in_test
5659 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5660 SHOW TABLES;
5661 Tables_in_test
5662 t1
5663 SHOW CREATE TABLE t1;
5664 Table Create Table
5665 t1 CREATE TABLE `t1` (
5666 `c1` decimal(10,0) NOT NULL,
5667 `c2` date NOT NULL,
5668 `c3` int DEFAULT NULL,
5669 `c4` varchar(10) NOT NULL
5670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5671 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5672 SHOW TABLES;
5673 Tables_in_test
5674 t1
5675 SHOW CREATE TABLE t1;
5676 Table Create Table
5677 t1 CREATE TABLE `t1` (
5678 `c1` decimal(10,0) NOT NULL,
5679 `c2` date NOT NULL,
5680 `c3` int DEFAULT NULL,
5681 `c4` varchar(10) NOT NULL,
5682 PRIMARY KEY (`c1`,`c2`)
5683 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5684 DROP TABLE t1;
5685 SHOW TABLES;
5686 Tables_in_test
5687 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5688 SHOW TABLES;
5689 Tables_in_test
5690 t1
5691 SHOW CREATE TABLE t1;
5692 Table Create Table
5693 t1 CREATE TABLE `t1` (
5694 `c1` decimal(10,0) NOT NULL,
5695 `c2` date NOT NULL,
5696 `c3` int DEFAULT NULL,
5697 `c4` varchar(10) NOT NULL
5698 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5699 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5700 SHOW TABLES;
5701 Tables_in_test
5702 t1
5703 SHOW CREATE TABLE t1;
5704 Table Create Table
5705 t1 CREATE TABLE `t1` (
5706 `c1` decimal(10,0) NOT NULL,
5707 `c2` date NOT NULL,
5708 `c3` int DEFAULT NULL,
5709 `c4` varchar(10) NOT NULL,
5710 PRIMARY KEY (`c1`,`c2`)
5711 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5712 DROP TABLE t1;
5713 SHOW TABLES;
5714 Tables_in_test
5715 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5716 SHOW TABLES;
5717 Tables_in_test
5718 t1
5719 SHOW CREATE TABLE t1;
5720 Table Create Table
5721 t1 CREATE TABLE `t1` (
5722 `c1` date NOT NULL,
5723 `c2` date NOT NULL,
5724 `c3` int DEFAULT NULL,
5725 `c4` varchar(10) NOT NULL
5726 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5727 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5728 SHOW TABLES;
5729 Tables_in_test
5730 t1
5731 SHOW CREATE TABLE t1;
5732 Table Create Table
5733 t1 CREATE TABLE `t1` (
5734 `c1` date NOT NULL,
5735 `c2` date NOT NULL,
5736 `c3` int DEFAULT NULL,
5737 `c4` varchar(10) NOT NULL,
5738 PRIMARY KEY (`c1`,`c2`)
5739 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5740 DROP TABLE t1;
5741 SHOW TABLES;
5742 Tables_in_test
5743 CREATE TABLE t1(c1 TIME NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5744 SHOW TABLES;
5745 Tables_in_test
5746 t1
5747 SHOW CREATE TABLE t1;
5748 Table Create Table
5749 t1 CREATE TABLE `t1` (
5750 `c1` time NOT NULL,
5751 `c2` date NOT NULL,
5752 `c3` int DEFAULT NULL,
5753 `c4` varchar(10) NOT NULL
5754 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5755 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5756 SHOW TABLES;
5757 Tables_in_test
5758 t1
5759 SHOW CREATE TABLE t1;
5760 Table Create Table
5761 t1 CREATE TABLE `t1` (
5762 `c1` time NOT NULL,
5763 `c2` date NOT NULL,
5764 `c3` int DEFAULT NULL,
5765 `c4` varchar(10) NOT NULL,
5766 PRIMARY KEY (`c1`,`c2`)
5767 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5768 DROP TABLE t1;
5769 SHOW TABLES;
5770 Tables_in_test
5771 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5772 SHOW TABLES;
5773 Tables_in_test
5774 t1
5775 SHOW CREATE TABLE t1;
5776 Table Create Table
5777 t1 CREATE TABLE `t1` (
5778 `c1` timestamp NOT NULL,
5779 `c2` date NOT NULL,
5780 `c3` int DEFAULT NULL,
5781 `c4` varchar(10) NOT NULL
5782 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5783 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5784 SHOW TABLES;
5785 Tables_in_test
5786 t1
5787 SHOW CREATE TABLE t1;
5788 Table Create Table
5789 t1 CREATE TABLE `t1` (
5790 `c1` timestamp NOT NULL,
5791 `c2` date NOT NULL,
5792 `c3` int DEFAULT NULL,
5793 `c4` varchar(10) NOT NULL,
5794 PRIMARY KEY (`c1`,`c2`)
5795 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5796 DROP TABLE t1;
5797 SHOW TABLES;
5798 Tables_in_test
5799 CREATE TABLE t1(c1 YEAR NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5800 SHOW TABLES;
5801 Tables_in_test
5802 t1
5803 SHOW CREATE TABLE t1;
5804 Table Create Table
5805 t1 CREATE TABLE `t1` (
5806 `c1` year NOT NULL,
5807 `c2` date NOT NULL,
5808 `c3` int DEFAULT NULL,
5809 `c4` varchar(10) NOT NULL
5810 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5811 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5812 SHOW TABLES;
5813 Tables_in_test
5814 t1
5815 SHOW CREATE TABLE t1;
5816 Table Create Table
5817 t1 CREATE TABLE `t1` (
5818 `c1` year NOT NULL,
5819 `c2` date NOT NULL,
5820 `c3` int DEFAULT NULL,
5821 `c4` varchar(10) NOT NULL,
5822 PRIMARY KEY (`c1`,`c2`)
5823 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5824 DROP TABLE t1;
5825 SHOW TABLES;
5826 Tables_in_test
5827 CREATE TABLE t1(c1 BIT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5828 SHOW TABLES;
5829 Tables_in_test
5830 t1
5831 SHOW CREATE TABLE t1;
5832 Table Create Table
5833 t1 CREATE TABLE `t1` (
5834 `c1` bit(1) NOT NULL,
5835 `c2` time NOT NULL,
5836 `c3` int DEFAULT NULL,
5837 `c4` varchar(10) NOT NULL
5838 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5839 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5840 SHOW TABLES;
5841 Tables_in_test
5842 t1
5843 SHOW CREATE TABLE t1;
5844 Table Create Table
5845 t1 CREATE TABLE `t1` (
5846 `c1` bit(1) NOT NULL,
5847 `c2` time NOT NULL,
5848 `c3` int DEFAULT NULL,
5849 `c4` varchar(10) NOT NULL,
5850 PRIMARY KEY (`c1`,`c2`)
5851 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5852 DROP TABLE t1;
5853 SHOW TABLES;
5854 Tables_in_test
5855 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5856 SHOW TABLES;
5857 Tables_in_test
5858 t1
5859 SHOW CREATE TABLE t1;
5860 Table Create Table
5861 t1 CREATE TABLE `t1` (
5862 `c1` tinyint NOT NULL,
5863 `c2` time NOT NULL,
5864 `c3` int DEFAULT NULL,
5865 `c4` varchar(10) NOT NULL
5866 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5867 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5868 SHOW TABLES;
5869 Tables_in_test
5870 t1
5871 SHOW CREATE TABLE t1;
5872 Table Create Table
5873 t1 CREATE TABLE `t1` (
5874 `c1` tinyint NOT NULL,
5875 `c2` time NOT NULL,
5876 `c3` int DEFAULT NULL,
5877 `c4` varchar(10) NOT NULL,
5878 PRIMARY KEY (`c1`,`c2`)
5879 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5880 DROP TABLE t1;
5881 SHOW TABLES;
5882 Tables_in_test
5883 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5884 SHOW TABLES;
5885 Tables_in_test
5886 t1
5887 SHOW CREATE TABLE t1;
5888 Table Create Table
5889 t1 CREATE TABLE `t1` (
5890 `c1` smallint NOT NULL,
5891 `c2` time NOT NULL,
5892 `c3` int DEFAULT NULL,
5893 `c4` varchar(10) NOT NULL
5894 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5895 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5896 SHOW TABLES;
5897 Tables_in_test
5898 t1
5899 SHOW CREATE TABLE t1;
5900 Table Create Table
5901 t1 CREATE TABLE `t1` (
5902 `c1` smallint NOT NULL,
5903 `c2` time NOT NULL,
5904 `c3` int DEFAULT NULL,
5905 `c4` varchar(10) NOT NULL,
5906 PRIMARY KEY (`c1`,`c2`)
5907 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5908 DROP TABLE t1;
5909 SHOW TABLES;
5910 Tables_in_test
5911 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5912 SHOW TABLES;
5913 Tables_in_test
5914 t1
5915 SHOW CREATE TABLE t1;
5916 Table Create Table
5917 t1 CREATE TABLE `t1` (
5918 `c1` mediumint NOT NULL,
5919 `c2` time NOT NULL,
5920 `c3` int DEFAULT NULL,
5921 `c4` varchar(10) NOT NULL
5922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5923 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5924 SHOW TABLES;
5925 Tables_in_test
5926 t1
5927 SHOW CREATE TABLE t1;
5928 Table Create Table
5929 t1 CREATE TABLE `t1` (
5930 `c1` mediumint NOT NULL,
5931 `c2` time NOT NULL,
5932 `c3` int DEFAULT NULL,
5933 `c4` varchar(10) NOT NULL,
5934 PRIMARY KEY (`c1`,`c2`)
5935 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5936 DROP TABLE t1;
5937 SHOW TABLES;
5938 Tables_in_test
5939 CREATE TABLE t1(c1 INT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5940 SHOW TABLES;
5941 Tables_in_test
5942 t1
5943 SHOW CREATE TABLE t1;
5944 Table Create Table
5945 t1 CREATE TABLE `t1` (
5946 `c1` int NOT NULL,
5947 `c2` time NOT NULL,
5948 `c3` int DEFAULT NULL,
5949 `c4` varchar(10) NOT NULL
5950 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5951 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5952 SHOW TABLES;
5953 Tables_in_test
5954 t1
5955 SHOW CREATE TABLE t1;
5956 Table Create Table
5957 t1 CREATE TABLE `t1` (
5958 `c1` int NOT NULL,
5959 `c2` time NOT NULL,
5960 `c3` int DEFAULT NULL,
5961 `c4` varchar(10) NOT NULL,
5962 PRIMARY KEY (`c1`,`c2`)
5963 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5964 DROP TABLE t1;
5965 SHOW TABLES;
5966 Tables_in_test
5967 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5968 SHOW TABLES;
5969 Tables_in_test
5970 t1
5971 SHOW CREATE TABLE t1;
5972 Table Create Table
5973 t1 CREATE TABLE `t1` (
5974 `c1` int NOT NULL,
5975 `c2` time NOT NULL,
5976 `c3` int DEFAULT NULL,
5977 `c4` varchar(10) NOT NULL
5978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5979 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5980 SHOW TABLES;
5981 Tables_in_test
5982 t1
5983 SHOW CREATE TABLE t1;
5984 Table Create Table
5985 t1 CREATE TABLE `t1` (
5986 `c1` int NOT NULL,
5987 `c2` time NOT NULL,
5988 `c3` int DEFAULT NULL,
5989 `c4` varchar(10) NOT NULL,
5990 PRIMARY KEY (`c1`,`c2`)
5991 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
5992 DROP TABLE t1;
5993 SHOW TABLES;
5994 Tables_in_test
5995 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5996 SHOW TABLES;
5997 Tables_in_test
5998 t1
5999 SHOW CREATE TABLE t1;
6000 Table Create Table
6001 t1 CREATE TABLE `t1` (
6002 `c1` bigint NOT NULL,
6003 `c2` time NOT NULL,
6004 `c3` int DEFAULT NULL,
6005 `c4` varchar(10) NOT NULL
6006 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6007 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6008 SHOW TABLES;
6009 Tables_in_test
6010 t1
6011 SHOW CREATE TABLE t1;
6012 Table Create Table
6013 t1 CREATE TABLE `t1` (
6014 `c1` bigint NOT NULL,
6015 `c2` time NOT NULL,
6016 `c3` int DEFAULT NULL,
6017 `c4` varchar(10) NOT NULL,
6018 PRIMARY KEY (`c1`,`c2`)
6019 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6020 DROP TABLE t1;
6021 SHOW TABLES;
6022 Tables_in_test
6023 CREATE TABLE t1(c1 REAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6024 SHOW TABLES;
6025 Tables_in_test
6026 t1
6027 SHOW CREATE TABLE t1;
6028 Table Create Table
6029 t1 CREATE TABLE `t1` (
6030 `c1` double NOT NULL,
6031 `c2` time NOT NULL,
6032 `c3` int DEFAULT NULL,
6033 `c4` varchar(10) NOT NULL
6034 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6035 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6036 SHOW TABLES;
6037 Tables_in_test
6038 t1
6039 SHOW CREATE TABLE t1;
6040 Table Create Table
6041 t1 CREATE TABLE `t1` (
6042 `c1` double NOT NULL,
6043 `c2` time NOT NULL,
6044 `c3` int DEFAULT NULL,
6045 `c4` varchar(10) NOT NULL,
6046 PRIMARY KEY (`c1`,`c2`)
6047 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6048 DROP TABLE t1;
6049 SHOW TABLES;
6050 Tables_in_test
6051 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6052 SHOW TABLES;
6053 Tables_in_test
6054 t1
6055 SHOW CREATE TABLE t1;
6056 Table Create Table
6057 t1 CREATE TABLE `t1` (
6058 `c1` double NOT NULL,
6059 `c2` time NOT NULL,
6060 `c3` int DEFAULT NULL,
6061 `c4` varchar(10) NOT NULL
6062 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6063 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6064 SHOW TABLES;
6065 Tables_in_test
6066 t1
6067 SHOW CREATE TABLE t1;
6068 Table Create Table
6069 t1 CREATE TABLE `t1` (
6070 `c1` double NOT NULL,
6071 `c2` time NOT NULL,
6072 `c3` int DEFAULT NULL,
6073 `c4` varchar(10) NOT NULL,
6074 PRIMARY KEY (`c1`,`c2`)
6075 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6076 DROP TABLE t1;
6077 SHOW TABLES;
6078 Tables_in_test
6079 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6080 SHOW TABLES;
6081 Tables_in_test
6082 t1
6083 SHOW CREATE TABLE t1;
6084 Table Create Table
6085 t1 CREATE TABLE `t1` (
6086 `c1` float NOT NULL,
6087 `c2` time NOT NULL,
6088 `c3` int DEFAULT NULL,
6089 `c4` varchar(10) NOT NULL
6090 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6091 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6092 SHOW TABLES;
6093 Tables_in_test
6094 t1
6095 SHOW CREATE TABLE t1;
6096 Table Create Table
6097 t1 CREATE TABLE `t1` (
6098 `c1` float NOT NULL,
6099 `c2` time NOT NULL,
6100 `c3` int DEFAULT NULL,
6101 `c4` varchar(10) NOT NULL,
6102 PRIMARY KEY (`c1`,`c2`)
6103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6104 DROP TABLE t1;
6105 SHOW TABLES;
6106 Tables_in_test
6107 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6108 SHOW TABLES;
6109 Tables_in_test
6110 t1
6111 SHOW CREATE TABLE t1;
6112 Table Create Table
6113 t1 CREATE TABLE `t1` (
6114 `c1` decimal(10,0) NOT NULL,
6115 `c2` time NOT NULL,
6116 `c3` int DEFAULT NULL,
6117 `c4` varchar(10) NOT NULL
6118 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6119 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6120 SHOW TABLES;
6121 Tables_in_test
6122 t1
6123 SHOW CREATE TABLE t1;
6124 Table Create Table
6125 t1 CREATE TABLE `t1` (
6126 `c1` decimal(10,0) NOT NULL,
6127 `c2` time NOT NULL,
6128 `c3` int DEFAULT NULL,
6129 `c4` varchar(10) NOT NULL,
6130 PRIMARY KEY (`c1`,`c2`)
6131 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6132 DROP TABLE t1;
6133 SHOW TABLES;
6134 Tables_in_test
6135 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6136 SHOW TABLES;
6137 Tables_in_test
6138 t1
6139 SHOW CREATE TABLE t1;
6140 Table Create Table
6141 t1 CREATE TABLE `t1` (
6142 `c1` decimal(10,0) NOT NULL,
6143 `c2` time NOT NULL,
6144 `c3` int DEFAULT NULL,
6145 `c4` varchar(10) NOT NULL
6146 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6147 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6148 SHOW TABLES;
6149 Tables_in_test
6150 t1
6151 SHOW CREATE TABLE t1;
6152 Table Create Table
6153 t1 CREATE TABLE `t1` (
6154 `c1` decimal(10,0) NOT NULL,
6155 `c2` time NOT NULL,
6156 `c3` int DEFAULT NULL,
6157 `c4` varchar(10) NOT NULL,
6158 PRIMARY KEY (`c1`,`c2`)
6159 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6160 DROP TABLE t1;
6161 SHOW TABLES;
6162 Tables_in_test
6163 CREATE TABLE t1(c1 DATE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6164 SHOW TABLES;
6165 Tables_in_test
6166 t1
6167 SHOW CREATE TABLE t1;
6168 Table Create Table
6169 t1 CREATE TABLE `t1` (
6170 `c1` date NOT NULL,
6171 `c2` time NOT NULL,
6172 `c3` int DEFAULT NULL,
6173 `c4` varchar(10) NOT NULL
6174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6175 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6176 SHOW TABLES;
6177 Tables_in_test
6178 t1
6179 SHOW CREATE TABLE t1;
6180 Table Create Table
6181 t1 CREATE TABLE `t1` (
6182 `c1` date NOT NULL,
6183 `c2` time NOT NULL,
6184 `c3` int DEFAULT NULL,
6185 `c4` varchar(10) NOT NULL,
6186 PRIMARY KEY (`c1`,`c2`)
6187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6188 DROP TABLE t1;
6189 SHOW TABLES;
6190 Tables_in_test
6191 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6192 SHOW TABLES;
6193 Tables_in_test
6194 t1
6195 SHOW CREATE TABLE t1;
6196 Table Create Table
6197 t1 CREATE TABLE `t1` (
6198 `c1` time NOT NULL,
6199 `c2` time NOT NULL,
6200 `c3` int DEFAULT NULL,
6201 `c4` varchar(10) NOT NULL
6202 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6203 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6204 SHOW TABLES;
6205 Tables_in_test
6206 t1
6207 SHOW CREATE TABLE t1;
6208 Table Create Table
6209 t1 CREATE TABLE `t1` (
6210 `c1` time NOT NULL,
6211 `c2` time NOT NULL,
6212 `c3` int DEFAULT NULL,
6213 `c4` varchar(10) NOT NULL,
6214 PRIMARY KEY (`c1`,`c2`)
6215 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6216 DROP TABLE t1;
6217 SHOW TABLES;
6218 Tables_in_test
6219 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6220 SHOW TABLES;
6221 Tables_in_test
6222 t1
6223 SHOW CREATE TABLE t1;
6224 Table Create Table
6225 t1 CREATE TABLE `t1` (
6226 `c1` timestamp NOT NULL,
6227 `c2` time NOT NULL,
6228 `c3` int DEFAULT NULL,
6229 `c4` varchar(10) NOT NULL
6230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6231 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6232 SHOW TABLES;
6233 Tables_in_test
6234 t1
6235 SHOW CREATE TABLE t1;
6236 Table Create Table
6237 t1 CREATE TABLE `t1` (
6238 `c1` timestamp NOT NULL,
6239 `c2` time NOT NULL,
6240 `c3` int DEFAULT NULL,
6241 `c4` varchar(10) NOT NULL,
6242 PRIMARY KEY (`c1`,`c2`)
6243 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6244 DROP TABLE t1;
6245 SHOW TABLES;
6246 Tables_in_test
6247 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6248 SHOW TABLES;
6249 Tables_in_test
6250 t1
6251 SHOW CREATE TABLE t1;
6252 Table Create Table
6253 t1 CREATE TABLE `t1` (
6254 `c1` year NOT NULL,
6255 `c2` time NOT NULL,
6256 `c3` int DEFAULT NULL,
6257 `c4` varchar(10) NOT NULL
6258 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6259 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6260 SHOW TABLES;
6261 Tables_in_test
6262 t1
6263 SHOW CREATE TABLE t1;
6264 Table Create Table
6265 t1 CREATE TABLE `t1` (
6266 `c1` year NOT NULL,
6267 `c2` time NOT NULL,
6268 `c3` int DEFAULT NULL,
6269 `c4` varchar(10) NOT NULL,
6270 PRIMARY KEY (`c1`,`c2`)
6271 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6272 DROP TABLE t1;
6273 SHOW TABLES;
6274 Tables_in_test
6275 CREATE TABLE t1(c1 BIT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6276 SHOW TABLES;
6277 Tables_in_test
6278 t1
6279 SHOW CREATE TABLE t1;
6280 Table Create Table
6281 t1 CREATE TABLE `t1` (
6282 `c1` bit(1) NOT NULL,
6283 `c2` timestamp NOT NULL,
6284 `c3` int DEFAULT NULL,
6285 `c4` varchar(10) NOT NULL
6286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6287 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6288 SHOW TABLES;
6289 Tables_in_test
6290 t1
6291 SHOW CREATE TABLE t1;
6292 Table Create Table
6293 t1 CREATE TABLE `t1` (
6294 `c1` bit(1) NOT NULL,
6295 `c2` timestamp NOT NULL,
6296 `c3` int DEFAULT NULL,
6297 `c4` varchar(10) NOT NULL,
6298 PRIMARY KEY (`c1`,`c2`)
6299 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6300 DROP TABLE t1;
6301 SHOW TABLES;
6302 Tables_in_test
6303 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6304 SHOW TABLES;
6305 Tables_in_test
6306 t1
6307 SHOW CREATE TABLE t1;
6308 Table Create Table
6309 t1 CREATE TABLE `t1` (
6310 `c1` tinyint NOT NULL,
6311 `c2` timestamp NOT NULL,
6312 `c3` int DEFAULT NULL,
6313 `c4` varchar(10) NOT NULL
6314 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6315 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6316 SHOW TABLES;
6317 Tables_in_test
6318 t1
6319 SHOW CREATE TABLE t1;
6320 Table Create Table
6321 t1 CREATE TABLE `t1` (
6322 `c1` tinyint NOT NULL,
6323 `c2` timestamp NOT NULL,
6324 `c3` int DEFAULT NULL,
6325 `c4` varchar(10) NOT NULL,
6326 PRIMARY KEY (`c1`,`c2`)
6327 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6328 DROP TABLE t1;
6329 SHOW TABLES;
6330 Tables_in_test
6331 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6332 SHOW TABLES;
6333 Tables_in_test
6334 t1
6335 SHOW CREATE TABLE t1;
6336 Table Create Table
6337 t1 CREATE TABLE `t1` (
6338 `c1` smallint NOT NULL,
6339 `c2` timestamp NOT NULL,
6340 `c3` int DEFAULT NULL,
6341 `c4` varchar(10) NOT NULL
6342 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6343 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6344 SHOW TABLES;
6345 Tables_in_test
6346 t1
6347 SHOW CREATE TABLE t1;
6348 Table Create Table
6349 t1 CREATE TABLE `t1` (
6350 `c1` smallint NOT NULL,
6351 `c2` timestamp NOT NULL,
6352 `c3` int DEFAULT NULL,
6353 `c4` varchar(10) NOT NULL,
6354 PRIMARY KEY (`c1`,`c2`)
6355 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6356 DROP TABLE t1;
6357 SHOW TABLES;
6358 Tables_in_test
6359 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6360 SHOW TABLES;
6361 Tables_in_test
6362 t1
6363 SHOW CREATE TABLE t1;
6364 Table Create Table
6365 t1 CREATE TABLE `t1` (
6366 `c1` mediumint NOT NULL,
6367 `c2` timestamp NOT NULL,
6368 `c3` int DEFAULT NULL,
6369 `c4` varchar(10) NOT NULL
6370 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6371 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6372 SHOW TABLES;
6373 Tables_in_test
6374 t1
6375 SHOW CREATE TABLE t1;
6376 Table Create Table
6377 t1 CREATE TABLE `t1` (
6378 `c1` mediumint NOT NULL,
6379 `c2` timestamp NOT NULL,
6380 `c3` int DEFAULT NULL,
6381 `c4` varchar(10) NOT NULL,
6382 PRIMARY KEY (`c1`,`c2`)
6383 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6384 DROP TABLE t1;
6385 SHOW TABLES;
6386 Tables_in_test
6387 CREATE TABLE t1(c1 INT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6388 SHOW TABLES;
6389 Tables_in_test
6390 t1
6391 SHOW CREATE TABLE t1;
6392 Table Create Table
6393 t1 CREATE TABLE `t1` (
6394 `c1` int NOT NULL,
6395 `c2` timestamp NOT NULL,
6396 `c3` int DEFAULT NULL,
6397 `c4` varchar(10) NOT NULL
6398 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6399 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6400 SHOW TABLES;
6401 Tables_in_test
6402 t1
6403 SHOW CREATE TABLE t1;
6404 Table Create Table
6405 t1 CREATE TABLE `t1` (
6406 `c1` int NOT NULL,
6407 `c2` timestamp NOT NULL,
6408 `c3` int DEFAULT NULL,
6409 `c4` varchar(10) NOT NULL,
6410 PRIMARY KEY (`c1`,`c2`)
6411 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6412 DROP TABLE t1;
6413 SHOW TABLES;
6414 Tables_in_test
6415 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6416 SHOW TABLES;
6417 Tables_in_test
6418 t1
6419 SHOW CREATE TABLE t1;
6420 Table Create Table
6421 t1 CREATE TABLE `t1` (
6422 `c1` int NOT NULL,
6423 `c2` timestamp NOT NULL,
6424 `c3` int DEFAULT NULL,
6425 `c4` varchar(10) NOT NULL
6426 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6427 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6428 SHOW TABLES;
6429 Tables_in_test
6430 t1
6431 SHOW CREATE TABLE t1;
6432 Table Create Table
6433 t1 CREATE TABLE `t1` (
6434 `c1` int NOT NULL,
6435 `c2` timestamp NOT NULL,
6436 `c3` int DEFAULT NULL,
6437 `c4` varchar(10) NOT NULL,
6438 PRIMARY KEY (`c1`,`c2`)
6439 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6440 DROP TABLE t1;
6441 SHOW TABLES;
6442 Tables_in_test
6443 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6444 SHOW TABLES;
6445 Tables_in_test
6446 t1
6447 SHOW CREATE TABLE t1;
6448 Table Create Table
6449 t1 CREATE TABLE `t1` (
6450 `c1` bigint NOT NULL,
6451 `c2` timestamp NOT NULL,
6452 `c3` int DEFAULT NULL,
6453 `c4` varchar(10) NOT NULL
6454 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6455 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6456 SHOW TABLES;
6457 Tables_in_test
6458 t1
6459 SHOW CREATE TABLE t1;
6460 Table Create Table
6461 t1 CREATE TABLE `t1` (
6462 `c1` bigint NOT NULL,
6463 `c2` timestamp NOT NULL,
6464 `c3` int DEFAULT NULL,
6465 `c4` varchar(10) NOT NULL,
6466 PRIMARY KEY (`c1`,`c2`)
6467 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6468 DROP TABLE t1;
6469 SHOW TABLES;
6470 Tables_in_test
6471 CREATE TABLE t1(c1 REAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6472 SHOW TABLES;
6473 Tables_in_test
6474 t1
6475 SHOW CREATE TABLE t1;
6476 Table Create Table
6477 t1 CREATE TABLE `t1` (
6478 `c1` double NOT NULL,
6479 `c2` timestamp NOT NULL,
6480 `c3` int DEFAULT NULL,
6481 `c4` varchar(10) NOT NULL
6482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6483 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6484 SHOW TABLES;
6485 Tables_in_test
6486 t1
6487 SHOW CREATE TABLE t1;
6488 Table Create Table
6489 t1 CREATE TABLE `t1` (
6490 `c1` double NOT NULL,
6491 `c2` timestamp NOT NULL,
6492 `c3` int DEFAULT NULL,
6493 `c4` varchar(10) NOT NULL,
6494 PRIMARY KEY (`c1`,`c2`)
6495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6496 DROP TABLE t1;
6497 SHOW TABLES;
6498 Tables_in_test
6499 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6500 SHOW TABLES;
6501 Tables_in_test
6502 t1
6503 SHOW CREATE TABLE t1;
6504 Table Create Table
6505 t1 CREATE TABLE `t1` (
6506 `c1` double NOT NULL,
6507 `c2` timestamp NOT NULL,
6508 `c3` int DEFAULT NULL,
6509 `c4` varchar(10) NOT NULL
6510 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6511 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6512 SHOW TABLES;
6513 Tables_in_test
6514 t1
6515 SHOW CREATE TABLE t1;
6516 Table Create Table
6517 t1 CREATE TABLE `t1` (
6518 `c1` double NOT NULL,
6519 `c2` timestamp NOT NULL,
6520 `c3` int DEFAULT NULL,
6521 `c4` varchar(10) NOT NULL,
6522 PRIMARY KEY (`c1`,`c2`)
6523 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6524 DROP TABLE t1;
6525 SHOW TABLES;
6526 Tables_in_test
6527 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6528 SHOW TABLES;
6529 Tables_in_test
6530 t1
6531 SHOW CREATE TABLE t1;
6532 Table Create Table
6533 t1 CREATE TABLE `t1` (
6534 `c1` float NOT NULL,
6535 `c2` timestamp NOT NULL,
6536 `c3` int DEFAULT NULL,
6537 `c4` varchar(10) NOT NULL
6538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6539 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6540 SHOW TABLES;
6541 Tables_in_test
6542 t1
6543 SHOW CREATE TABLE t1;
6544 Table Create Table
6545 t1 CREATE TABLE `t1` (
6546 `c1` float NOT NULL,
6547 `c2` timestamp NOT NULL,
6548 `c3` int DEFAULT NULL,
6549 `c4` varchar(10) NOT NULL,
6550 PRIMARY KEY (`c1`,`c2`)
6551 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6552 DROP TABLE t1;
6553 SHOW TABLES;
6554 Tables_in_test
6555 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6556 SHOW TABLES;
6557 Tables_in_test
6558 t1
6559 SHOW CREATE TABLE t1;
6560 Table Create Table
6561 t1 CREATE TABLE `t1` (
6562 `c1` decimal(10,0) NOT NULL,
6563 `c2` timestamp NOT NULL,
6564 `c3` int DEFAULT NULL,
6565 `c4` varchar(10) NOT NULL
6566 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6567 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6568 SHOW TABLES;
6569 Tables_in_test
6570 t1
6571 SHOW CREATE TABLE t1;
6572 Table Create Table
6573 t1 CREATE TABLE `t1` (
6574 `c1` decimal(10,0) NOT NULL,
6575 `c2` timestamp NOT NULL,
6576 `c3` int DEFAULT NULL,
6577 `c4` varchar(10) NOT NULL,
6578 PRIMARY KEY (`c1`,`c2`)
6579 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6580 DROP TABLE t1;
6581 SHOW TABLES;
6582 Tables_in_test
6583 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6584 SHOW TABLES;
6585 Tables_in_test
6586 t1
6587 SHOW CREATE TABLE t1;
6588 Table Create Table
6589 t1 CREATE TABLE `t1` (
6590 `c1` decimal(10,0) NOT NULL,
6591 `c2` timestamp NOT NULL,
6592 `c3` int DEFAULT NULL,
6593 `c4` varchar(10) NOT NULL
6594 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6595 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6596 SHOW TABLES;
6597 Tables_in_test
6598 t1
6599 SHOW CREATE TABLE t1;
6600 Table Create Table
6601 t1 CREATE TABLE `t1` (
6602 `c1` decimal(10,0) NOT NULL,
6603 `c2` timestamp NOT NULL,
6604 `c3` int DEFAULT NULL,
6605 `c4` varchar(10) NOT NULL,
6606 PRIMARY KEY (`c1`,`c2`)
6607 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6608 DROP TABLE t1;
6609 SHOW TABLES;
6610 Tables_in_test
6611 CREATE TABLE t1(c1 DATE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6612 SHOW TABLES;
6613 Tables_in_test
6614 t1
6615 SHOW CREATE TABLE t1;
6616 Table Create Table
6617 t1 CREATE TABLE `t1` (
6618 `c1` date NOT NULL,
6619 `c2` timestamp NOT NULL,
6620 `c3` int DEFAULT NULL,
6621 `c4` varchar(10) NOT NULL
6622 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6623 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6624 SHOW TABLES;
6625 Tables_in_test
6626 t1
6627 SHOW CREATE TABLE t1;
6628 Table Create Table
6629 t1 CREATE TABLE `t1` (
6630 `c1` date NOT NULL,
6631 `c2` timestamp NOT NULL,
6632 `c3` int DEFAULT NULL,
6633 `c4` varchar(10) NOT NULL,
6634 PRIMARY KEY (`c1`,`c2`)
6635 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6636 DROP TABLE t1;
6637 SHOW TABLES;
6638 Tables_in_test
6639 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6640 SHOW TABLES;
6641 Tables_in_test
6642 t1
6643 SHOW CREATE TABLE t1;
6644 Table Create Table
6645 t1 CREATE TABLE `t1` (
6646 `c1` time NOT NULL,
6647 `c2` timestamp NOT NULL,
6648 `c3` int DEFAULT NULL,
6649 `c4` varchar(10) NOT NULL
6650 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6651 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6652 SHOW TABLES;
6653 Tables_in_test
6654 t1
6655 SHOW CREATE TABLE t1;
6656 Table Create Table
6657 t1 CREATE TABLE `t1` (
6658 `c1` time NOT NULL,
6659 `c2` timestamp NOT NULL,
6660 `c3` int DEFAULT NULL,
6661 `c4` varchar(10) NOT NULL,
6662 PRIMARY KEY (`c1`,`c2`)
6663 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6664 DROP TABLE t1;
6665 SHOW TABLES;
6666 Tables_in_test
6667 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6668 SHOW TABLES;
6669 Tables_in_test
6670 t1
6671 SHOW CREATE TABLE t1;
6672 Table Create Table
6673 t1 CREATE TABLE `t1` (
6674 `c1` timestamp NOT NULL,
6675 `c2` timestamp NOT NULL,
6676 `c3` int DEFAULT NULL,
6677 `c4` varchar(10) NOT NULL
6678 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6679 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6680 SHOW TABLES;
6681 Tables_in_test
6682 t1
6683 SHOW CREATE TABLE t1;
6684 Table Create Table
6685 t1 CREATE TABLE `t1` (
6686 `c1` timestamp NOT NULL,
6687 `c2` timestamp NOT NULL,
6688 `c3` int DEFAULT NULL,
6689 `c4` varchar(10) NOT NULL,
6690 PRIMARY KEY (`c1`,`c2`)
6691 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6692 DROP TABLE t1;
6693 SHOW TABLES;
6694 Tables_in_test
6695 CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6696 SHOW TABLES;
6697 Tables_in_test
6698 t1
6699 SHOW CREATE TABLE t1;
6700 Table Create Table
6701 t1 CREATE TABLE `t1` (
6702 `c1` year NOT NULL,
6703 `c2` timestamp NOT NULL,
6704 `c3` int DEFAULT NULL,
6705 `c4` varchar(10) NOT NULL
6706 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6707 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6708 SHOW TABLES;
6709 Tables_in_test
6710 t1
6711 SHOW CREATE TABLE t1;
6712 Table Create Table
6713 t1 CREATE TABLE `t1` (
6714 `c1` year NOT NULL,
6715 `c2` timestamp NOT NULL,
6716 `c3` int DEFAULT NULL,
6717 `c4` varchar(10) NOT NULL,
6718 PRIMARY KEY (`c1`,`c2`)
6719 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6720 DROP TABLE t1;
6721 SHOW TABLES;
6722 Tables_in_test
6723 CREATE TABLE t1(c1 BIT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6724 SHOW TABLES;
6725 Tables_in_test
6726 t1
6727 SHOW CREATE TABLE t1;
6728 Table Create Table
6729 t1 CREATE TABLE `t1` (
6730 `c1` bit(1) NOT NULL,
6731 `c2` year NOT NULL,
6732 `c3` int DEFAULT NULL,
6733 `c4` varchar(10) NOT NULL
6734 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6735 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6736 SHOW TABLES;
6737 Tables_in_test
6738 t1
6739 SHOW CREATE TABLE t1;
6740 Table Create Table
6741 t1 CREATE TABLE `t1` (
6742 `c1` bit(1) NOT NULL,
6743 `c2` year NOT NULL,
6744 `c3` int DEFAULT NULL,
6745 `c4` varchar(10) NOT NULL,
6746 PRIMARY KEY (`c1`,`c2`)
6747 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6748 DROP TABLE t1;
6749 SHOW TABLES;
6750 Tables_in_test
6751 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6752 SHOW TABLES;
6753 Tables_in_test
6754 t1
6755 SHOW CREATE TABLE t1;
6756 Table Create Table
6757 t1 CREATE TABLE `t1` (
6758 `c1` tinyint NOT NULL,
6759 `c2` year NOT NULL,
6760 `c3` int DEFAULT NULL,
6761 `c4` varchar(10) NOT NULL
6762 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6763 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6764 SHOW TABLES;
6765 Tables_in_test
6766 t1
6767 SHOW CREATE TABLE t1;
6768 Table Create Table
6769 t1 CREATE TABLE `t1` (
6770 `c1` tinyint NOT NULL,
6771 `c2` year NOT NULL,
6772 `c3` int DEFAULT NULL,
6773 `c4` varchar(10) NOT NULL,
6774 PRIMARY KEY (`c1`,`c2`)
6775 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6776 DROP TABLE t1;
6777 SHOW TABLES;
6778 Tables_in_test
6779 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6780 SHOW TABLES;
6781 Tables_in_test
6782 t1
6783 SHOW CREATE TABLE t1;
6784 Table Create Table
6785 t1 CREATE TABLE `t1` (
6786 `c1` smallint NOT NULL,
6787 `c2` year NOT NULL,
6788 `c3` int DEFAULT NULL,
6789 `c4` varchar(10) NOT NULL
6790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6791 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6792 SHOW TABLES;
6793 Tables_in_test
6794 t1
6795 SHOW CREATE TABLE t1;
6796 Table Create Table
6797 t1 CREATE TABLE `t1` (
6798 `c1` smallint NOT NULL,
6799 `c2` year NOT NULL,
6800 `c3` int DEFAULT NULL,
6801 `c4` varchar(10) NOT NULL,
6802 PRIMARY KEY (`c1`,`c2`)
6803 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6804 DROP TABLE t1;
6805 SHOW TABLES;
6806 Tables_in_test
6807 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6808 SHOW TABLES;
6809 Tables_in_test
6810 t1
6811 SHOW CREATE TABLE t1;
6812 Table Create Table
6813 t1 CREATE TABLE `t1` (
6814 `c1` mediumint NOT NULL,
6815 `c2` year NOT NULL,
6816 `c3` int DEFAULT NULL,
6817 `c4` varchar(10) NOT NULL
6818 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6819 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6820 SHOW TABLES;
6821 Tables_in_test
6822 t1
6823 SHOW CREATE TABLE t1;
6824 Table Create Table
6825 t1 CREATE TABLE `t1` (
6826 `c1` mediumint NOT NULL,
6827 `c2` year NOT NULL,
6828 `c3` int DEFAULT NULL,
6829 `c4` varchar(10) NOT NULL,
6830 PRIMARY KEY (`c1`,`c2`)
6831 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6832 DROP TABLE t1;
6833 SHOW TABLES;
6834 Tables_in_test
6835 CREATE TABLE t1(c1 INT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6836 SHOW TABLES;
6837 Tables_in_test
6838 t1
6839 SHOW CREATE TABLE t1;
6840 Table Create Table
6841 t1 CREATE TABLE `t1` (
6842 `c1` int NOT NULL,
6843 `c2` year NOT NULL,
6844 `c3` int DEFAULT NULL,
6845 `c4` varchar(10) NOT NULL
6846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6847 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6848 SHOW TABLES;
6849 Tables_in_test
6850 t1
6851 SHOW CREATE TABLE t1;
6852 Table Create Table
6853 t1 CREATE TABLE `t1` (
6854 `c1` int NOT NULL,
6855 `c2` year NOT NULL,
6856 `c3` int DEFAULT NULL,
6857 `c4` varchar(10) NOT NULL,
6858 PRIMARY KEY (`c1`,`c2`)
6859 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6860 DROP TABLE t1;
6861 SHOW TABLES;
6862 Tables_in_test
6863 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6864 SHOW TABLES;
6865 Tables_in_test
6866 t1
6867 SHOW CREATE TABLE t1;
6868 Table Create Table
6869 t1 CREATE TABLE `t1` (
6870 `c1` int NOT NULL,
6871 `c2` year NOT NULL,
6872 `c3` int DEFAULT NULL,
6873 `c4` varchar(10) NOT NULL
6874 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6875 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6876 SHOW TABLES;
6877 Tables_in_test
6878 t1
6879 SHOW CREATE TABLE t1;
6880 Table Create Table
6881 t1 CREATE TABLE `t1` (
6882 `c1` int NOT NULL,
6883 `c2` year NOT NULL,
6884 `c3` int DEFAULT NULL,
6885 `c4` varchar(10) NOT NULL,
6886 PRIMARY KEY (`c1`,`c2`)
6887 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6888 DROP TABLE t1;
6889 SHOW TABLES;
6890 Tables_in_test
6891 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6892 SHOW TABLES;
6893 Tables_in_test
6894 t1
6895 SHOW CREATE TABLE t1;
6896 Table Create Table
6897 t1 CREATE TABLE `t1` (
6898 `c1` bigint NOT NULL,
6899 `c2` year NOT NULL,
6900 `c3` int DEFAULT NULL,
6901 `c4` varchar(10) NOT NULL
6902 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6903 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6904 SHOW TABLES;
6905 Tables_in_test
6906 t1
6907 SHOW CREATE TABLE t1;
6908 Table Create Table
6909 t1 CREATE TABLE `t1` (
6910 `c1` bigint NOT NULL,
6911 `c2` year NOT NULL,
6912 `c3` int DEFAULT NULL,
6913 `c4` varchar(10) NOT NULL,
6914 PRIMARY KEY (`c1`,`c2`)
6915 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6916 DROP TABLE t1;
6917 SHOW TABLES;
6918 Tables_in_test
6919 CREATE TABLE t1(c1 REAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6920 SHOW TABLES;
6921 Tables_in_test
6922 t1
6923 SHOW CREATE TABLE t1;
6924 Table Create Table
6925 t1 CREATE TABLE `t1` (
6926 `c1` double NOT NULL,
6927 `c2` year NOT NULL,
6928 `c3` int DEFAULT NULL,
6929 `c4` varchar(10) NOT NULL
6930 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6931 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6932 SHOW TABLES;
6933 Tables_in_test
6934 t1
6935 SHOW CREATE TABLE t1;
6936 Table Create Table
6937 t1 CREATE TABLE `t1` (
6938 `c1` double NOT NULL,
6939 `c2` year NOT NULL,
6940 `c3` int DEFAULT NULL,
6941 `c4` varchar(10) NOT NULL,
6942 PRIMARY KEY (`c1`,`c2`)
6943 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6944 DROP TABLE t1;
6945 SHOW TABLES;
6946 Tables_in_test
6947 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6948 SHOW TABLES;
6949 Tables_in_test
6950 t1
6951 SHOW CREATE TABLE t1;
6952 Table Create Table
6953 t1 CREATE TABLE `t1` (
6954 `c1` double NOT NULL,
6955 `c2` year NOT NULL,
6956 `c3` int DEFAULT NULL,
6957 `c4` varchar(10) NOT NULL
6958 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6959 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6960 SHOW TABLES;
6961 Tables_in_test
6962 t1
6963 SHOW CREATE TABLE t1;
6964 Table Create Table
6965 t1 CREATE TABLE `t1` (
6966 `c1` double NOT NULL,
6967 `c2` year NOT NULL,
6968 `c3` int DEFAULT NULL,
6969 `c4` varchar(10) NOT NULL,
6970 PRIMARY KEY (`c1`,`c2`)
6971 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6972 DROP TABLE t1;
6973 SHOW TABLES;
6974 Tables_in_test
6975 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6976 SHOW TABLES;
6977 Tables_in_test
6978 t1
6979 SHOW CREATE TABLE t1;
6980 Table Create Table
6981 t1 CREATE TABLE `t1` (
6982 `c1` float NOT NULL,
6983 `c2` year NOT NULL,
6984 `c3` int DEFAULT NULL,
6985 `c4` varchar(10) NOT NULL
6986 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
6987 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6988 SHOW TABLES;
6989 Tables_in_test
6990 t1
6991 SHOW CREATE TABLE t1;
6992 Table Create Table
6993 t1 CREATE TABLE `t1` (
6994 `c1` float NOT NULL,
6995 `c2` year NOT NULL,
6996 `c3` int DEFAULT NULL,
6997 `c4` varchar(10) NOT NULL,
6998 PRIMARY KEY (`c1`,`c2`)
6999 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7000 DROP TABLE t1;
7001 SHOW TABLES;
7002 Tables_in_test
7003 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7004 SHOW TABLES;
7005 Tables_in_test
7006 t1
7007 SHOW CREATE TABLE t1;
7008 Table Create Table
7009 t1 CREATE TABLE `t1` (
7010 `c1` decimal(10,0) NOT NULL,
7011 `c2` year NOT NULL,
7012 `c3` int DEFAULT NULL,
7013 `c4` varchar(10) NOT NULL
7014 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7015 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7016 SHOW TABLES;
7017 Tables_in_test
7018 t1
7019 SHOW CREATE TABLE t1;
7020 Table Create Table
7021 t1 CREATE TABLE `t1` (
7022 `c1` decimal(10,0) NOT NULL,
7023 `c2` year NOT NULL,
7024 `c3` int DEFAULT NULL,
7025 `c4` varchar(10) NOT NULL,
7026 PRIMARY KEY (`c1`,`c2`)
7027 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7028 DROP TABLE t1;
7029 SHOW TABLES;
7030 Tables_in_test
7031 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7032 SHOW TABLES;
7033 Tables_in_test
7034 t1
7035 SHOW CREATE TABLE t1;
7036 Table Create Table
7037 t1 CREATE TABLE `t1` (
7038 `c1` decimal(10,0) NOT NULL,
7039 `c2` year NOT NULL,
7040 `c3` int DEFAULT NULL,
7041 `c4` varchar(10) NOT NULL
7042 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7043 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7044 SHOW TABLES;
7045 Tables_in_test
7046 t1
7047 SHOW CREATE TABLE t1;
7048 Table Create Table
7049 t1 CREATE TABLE `t1` (
7050 `c1` decimal(10,0) NOT NULL,
7051 `c2` year NOT NULL,
7052 `c3` int DEFAULT NULL,
7053 `c4` varchar(10) NOT NULL,
7054 PRIMARY KEY (`c1`,`c2`)
7055 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7056 DROP TABLE t1;
7057 SHOW TABLES;
7058 Tables_in_test
7059 CREATE TABLE t1(c1 DATE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7060 SHOW TABLES;
7061 Tables_in_test
7062 t1
7063 SHOW CREATE TABLE t1;
7064 Table Create Table
7065 t1 CREATE TABLE `t1` (
7066 `c1` date NOT NULL,
7067 `c2` year NOT NULL,
7068 `c3` int DEFAULT NULL,
7069 `c4` varchar(10) NOT NULL
7070 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7071 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7072 SHOW TABLES;
7073 Tables_in_test
7074 t1
7075 SHOW CREATE TABLE t1;
7076 Table Create Table
7077 t1 CREATE TABLE `t1` (
7078 `c1` date NOT NULL,
7079 `c2` year NOT NULL,
7080 `c3` int DEFAULT NULL,
7081 `c4` varchar(10) NOT NULL,
7082 PRIMARY KEY (`c1`,`c2`)
7083 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7084 DROP TABLE t1;
7085 SHOW TABLES;
7086 Tables_in_test
7087 CREATE TABLE t1(c1 TIME NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7088 SHOW TABLES;
7089 Tables_in_test
7090 t1
7091 SHOW CREATE TABLE t1;
7092 Table Create Table
7093 t1 CREATE TABLE `t1` (
7094 `c1` time NOT NULL,
7095 `c2` year NOT NULL,
7096 `c3` int DEFAULT NULL,
7097 `c4` varchar(10) NOT NULL
7098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7099 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7100 SHOW TABLES;
7101 Tables_in_test
7102 t1
7103 SHOW CREATE TABLE t1;
7104 Table Create Table
7105 t1 CREATE TABLE `t1` (
7106 `c1` time NOT NULL,
7107 `c2` year NOT NULL,
7108 `c3` int DEFAULT NULL,
7109 `c4` varchar(10) NOT NULL,
7110 PRIMARY KEY (`c1`,`c2`)
7111 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7112 DROP TABLE t1;
7113 SHOW TABLES;
7114 Tables_in_test
7115 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7116 SHOW TABLES;
7117 Tables_in_test
7118 t1
7119 SHOW CREATE TABLE t1;
7120 Table Create Table
7121 t1 CREATE TABLE `t1` (
7122 `c1` timestamp NOT NULL,
7123 `c2` year NOT NULL,
7124 `c3` int DEFAULT NULL,
7125 `c4` varchar(10) NOT NULL
7126 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7127 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7128 SHOW TABLES;
7129 Tables_in_test
7130 t1
7131 SHOW CREATE TABLE t1;
7132 Table Create Table
7133 t1 CREATE TABLE `t1` (
7134 `c1` timestamp NOT NULL,
7135 `c2` year NOT NULL,
7136 `c3` int DEFAULT NULL,
7137 `c4` varchar(10) NOT NULL,
7138 PRIMARY KEY (`c1`,`c2`)
7139 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7140 DROP TABLE t1;
7141 SHOW TABLES;
7142 Tables_in_test
7143 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7144 SHOW TABLES;
7145 Tables_in_test
7146 t1
7147 SHOW CREATE TABLE t1;
7148 Table Create Table
7149 t1 CREATE TABLE `t1` (
7150 `c1` year NOT NULL,
7151 `c2` year NOT NULL,
7152 `c3` int DEFAULT NULL,
7153 `c4` varchar(10) NOT NULL
7154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7155 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7156 SHOW TABLES;
7157 Tables_in_test
7158 t1
7159 SHOW CREATE TABLE t1;
7160 Table Create Table
7161 t1 CREATE TABLE `t1` (
7162 `c1` year NOT NULL,
7163 `c2` year NOT NULL,
7164 `c3` int DEFAULT NULL,
7165 `c4` varchar(10) NOT NULL,
7166 PRIMARY KEY (`c1`,`c2`)
7167 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7168 DROP TABLE t1;
7169 SHOW TABLES;
7170 Tables_in_test
7171 SET sql_mode=default;