Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t9;
2 CREATE TABLE t9(c1 CHAR(10) NOT NULL PRIMARY KEY);
3 SHOW TABLES;
4 Tables_in_test
5 t9
6 SHOW CREATE TABLE t9;
7 Table Create Table
8 t9 CREATE TABLE `t9` (
9 `c1` char(10) NOT NULL,
10 PRIMARY KEY (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 DROP TABLE t9;
13 SHOW TABLES;
14 Tables_in_test
15 CREATE TABLE t9(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
16 SHOW TABLES;
17 Tables_in_test
18 t9
19 SHOW CREATE TABLE t9;
20 Table Create Table
21 t9 CREATE TABLE `t9` (
22 `c1` varchar(10) NOT NULL,
23 PRIMARY KEY (`c1`)
24 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
25 DROP TABLE t9;
26 SHOW TABLES;
27 Tables_in_test
28 CREATE TABLE t9(c1 BINARY(10) NOT NULL PRIMARY KEY);
29 SHOW TABLES;
30 Tables_in_test
31 t9
32 SHOW CREATE TABLE t9;
33 Table Create Table
34 t9 CREATE TABLE `t9` (
35 `c1` binary(10) NOT NULL,
36 PRIMARY KEY (`c1`)
37 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
38 DROP TABLE t9;
39 SHOW TABLES;
40 Tables_in_test
41 CREATE TABLE t9(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
42 SHOW TABLES;
43 Tables_in_test
44 t9
45 SHOW CREATE TABLE t9;
46 Table Create Table
47 t9 CREATE TABLE `t9` (
48 `c1` varbinary(10) NOT NULL,
49 PRIMARY KEY (`c1`)
50 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 DROP TABLE t9;
52 SHOW TABLES;
53 Tables_in_test