Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_2part_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);
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 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
13 SHOW TABLES;
14 Tables_in_test
15 t1
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` char(30) NOT NULL,
20 `c2` char(20) NOT NULL,
21 PRIMARY KEY (`c1`,`c2`)
22 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
23 DROP TABLE t1;
24 SHOW TABLES;
25 Tables_in_test
26 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(20) NOT NULL);
27 SHOW TABLES;
28 Tables_in_test
29 t1
30 SHOW CREATE TABLE t1;
31 Table Create Table
32 t1 CREATE TABLE `t1` (
33 `c1` varchar(30) NOT NULL,
34 `c2` varchar(20) NOT NULL
35 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
36 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
37 SHOW TABLES;
38 Tables_in_test
39 t1
40 SHOW CREATE TABLE t1;
41 Table Create Table
42 t1 CREATE TABLE `t1` (
43 `c1` varchar(30) NOT NULL,
44 `c2` varchar(20) NOT NULL,
45 PRIMARY KEY (`c1`,`c2`)
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 DROP TABLE t1;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(20) NOT NULL);
51 SHOW TABLES;
52 Tables_in_test
53 t1
54 SHOW CREATE TABLE t1;
55 Table Create Table
56 t1 CREATE TABLE `t1` (
57 `c1` binary(30) NOT NULL,
58 `c2` binary(20) NOT NULL
59 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
60 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
61 SHOW TABLES;
62 Tables_in_test
63 t1
64 SHOW CREATE TABLE t1;
65 Table Create Table
66 t1 CREATE TABLE `t1` (
67 `c1` binary(30) NOT NULL,
68 `c2` binary(20) NOT NULL,
69 PRIMARY KEY (`c1`,`c2`)
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 DROP TABLE t1;
72 SHOW TABLES;
73 Tables_in_test
74 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(20) NOT NULL);
75 SHOW TABLES;
76 Tables_in_test
77 t1
78 SHOW CREATE TABLE t1;
79 Table Create Table
80 t1 CREATE TABLE `t1` (
81 `c1` varbinary(30) NOT NULL,
82 `c2` varbinary(20) NOT NULL
83 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
84 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
85 SHOW TABLES;
86 Tables_in_test
87 t1
88 SHOW CREATE TABLE t1;
89 Table Create Table
90 t1 CREATE TABLE `t1` (
91 `c1` varbinary(30) NOT NULL,
92 `c2` varbinary(20) NOT NULL,
93 PRIMARY KEY (`c1`,`c2`)
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 DROP TABLE t1;
96 SHOW TABLES;
97 Tables_in_test