Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS m2;
2 CREATE TABLE m2(c1 CHAR(1) NULL, c2 CHAR(5) NOT NULL, c3 CHAR(255) NULL, c4 CHAR(4) NOT NULL PRIMARY KEY, c5 CHAR(30) NOT NULL UNIQUE KEY);
3 SHOW TABLES;
4 Tables_in_test
5 m2
6 SHOW CREATE TABLE m2;
7 Table Create Table
8 m2 CREATE TABLE `m2` (
9 `c1` char(1) DEFAULT NULL,
10 `c2` char(5) NOT NULL,
11 `c3` char(255) DEFAULT NULL,
12 `c4` char(4) NOT NULL,
13 `c5` char(30) NOT NULL,
14 PRIMARY KEY (`c4`),
15 UNIQUE KEY `c5` (`c5`)
16 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
17 DROP TABLE m2;
18 SHOW TABLES;
19 Tables_in_test
20 CREATE TABLE m2(c1 VARCHAR(1) NULL, c2 VARCHAR(5) NOT NULL, c3 VARCHAR(255) NULL, c4 VARCHAR(4) NOT NULL PRIMARY KEY, c5 VARCHAR(30) NOT NULL UNIQUE KEY);
21 SHOW TABLES;
22 Tables_in_test
23 m2
24 SHOW CREATE TABLE m2;
25 Table Create Table
26 m2 CREATE TABLE `m2` (
27 `c1` varchar(1) DEFAULT NULL,
28 `c2` varchar(5) NOT NULL,
29 `c3` varchar(255) DEFAULT NULL,
30 `c4` varchar(4) NOT NULL,
31 `c5` varchar(30) NOT NULL,
32 PRIMARY KEY (`c4`),
33 UNIQUE KEY `c5` (`c5`)
34 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
35 DROP TABLE m2;
36 SHOW TABLES;
37 Tables_in_test
38 CREATE TABLE m2(c1 BINARY(1) NULL, c2 BINARY(5) NOT NULL, c3 BINARY(255) NULL, c4 BINARY(4) NOT NULL PRIMARY KEY, c5 BINARY(30) NOT NULL UNIQUE KEY);
39 SHOW TABLES;
40 Tables_in_test
41 m2
42 SHOW CREATE TABLE m2;
43 Table Create Table
44 m2 CREATE TABLE `m2` (
45 `c1` binary(1) DEFAULT NULL,
46 `c2` binary(5) NOT NULL,
47 `c3` binary(255) DEFAULT NULL,
48 `c4` binary(4) NOT NULL,
49 `c5` binary(30) NOT NULL,
50 PRIMARY KEY (`c4`),
51 UNIQUE KEY `c5` (`c5`)
52 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 DROP TABLE m2;
54 SHOW TABLES;
55 Tables_in_test
56 CREATE TABLE m2(c1 VARBINARY(1) NULL, c2 VARBINARY(5) NOT NULL, c3 VARBINARY(255) NULL, c4 VARBINARY(4) NOT NULL PRIMARY KEY, c5 VARBINARY(30) NOT NULL UNIQUE KEY);
57 SHOW TABLES;
58 Tables_in_test
59 m2
60 SHOW CREATE TABLE m2;
61 Table Create Table
62 m2 CREATE TABLE `m2` (
63 `c1` varbinary(1) DEFAULT NULL,
64 `c2` varbinary(5) NOT NULL,
65 `c3` varbinary(255) DEFAULT NULL,
66 `c4` varbinary(4) NOT NULL,
67 `c5` varbinary(30) NOT NULL,
68 PRIMARY KEY (`c4`),
69 UNIQUE KEY `c5` (`c5`)
70 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 DROP TABLE m2;
72 SHOW TABLES;
73 Tables_in_test