Debian Codegraph @

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

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