Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(20) NOT NULL, c3 CHAR(10) NOT NULL);
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` char(30) NOT NULL,
10 `c2` char(20) NOT NULL,
11 `c3` char(10) NOT NULL
12 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
14 SHOW TABLES;
15 Tables_in_test
16 t1
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `c1` char(30) NOT NULL,
21 `c2` char(20) NOT NULL,
22 `c3` char(10) NOT NULL,
23 PRIMARY KEY (`c1`,`c2`)
24 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 DROP TABLE t1;
26 SHOW TABLES;
27 Tables_in_test
28 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL, c3 VARCHAR(10) NOT NULL);
29 SHOW TABLES;
30 Tables_in_test
31 t1
32 SHOW CREATE TABLE t1;
33 Table Create Table
34 t1 CREATE TABLE `t1` (
35 `c1` varchar(30) NOT NULL,
36 `c2` varchar(20) NOT NULL,
37 `c3` varchar(10) NOT NULL
38 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
40 SHOW TABLES;
41 Tables_in_test
42 t1
43 SHOW CREATE TABLE t1;
44 Table Create Table
45 t1 CREATE TABLE `t1` (
46 `c1` varchar(30) NOT NULL,
47 `c2` varchar(20) NOT NULL,
48 `c3` varchar(10) NOT NULL,
49 PRIMARY KEY (`c1`,`c2`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 DROP TABLE t1;
52 SHOW TABLES;
53 Tables_in_test
54 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(20) NOT NULL, c3 BINARY(10) NOT NULL);
55 SHOW TABLES;
56 Tables_in_test
57 t1
58 SHOW CREATE TABLE t1;
59 Table Create Table
60 t1 CREATE TABLE `t1` (
61 `c1` binary(30) NOT NULL,
62 `c2` binary(20) NOT NULL,
63 `c3` binary(10) NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
66 SHOW TABLES;
67 Tables_in_test
68 t1
69 SHOW CREATE TABLE t1;
70 Table Create Table
71 t1 CREATE TABLE `t1` (
72 `c1` binary(30) NOT NULL,
73 `c2` binary(20) NOT NULL,
74 `c3` binary(10) NOT NULL,
75 PRIMARY KEY (`c1`,`c2`)
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 DROP TABLE t1;
78 SHOW TABLES;
79 Tables_in_test
80 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL, c3 VARBINARY(10) NOT NULL);
81 SHOW TABLES;
82 Tables_in_test
83 t1
84 SHOW CREATE TABLE t1;
85 Table Create Table
86 t1 CREATE TABLE `t1` (
87 `c1` varbinary(30) NOT NULL,
88 `c2` varbinary(20) NOT NULL,
89 `c3` varbinary(10) NOT NULL
90 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
91 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
92 SHOW TABLES;
93 Tables_in_test
94 t1
95 SHOW CREATE TABLE t1;
96 Table Create Table
97 t1 CREATE TABLE `t1` (
98 `c1` varbinary(30) NOT NULL,
99 `c2` varbinary(20) NOT NULL,
100 `c3` varbinary(10) NOT NULL,
101 PRIMARY KEY (`c1`,`c2`)
102 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
103 DROP TABLE t1;
104 SHOW TABLES;
105 Tables_in_test