Debian Codegraph @

mysql-test/suite/jp/r/jp_enum_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 SET character_set_database = utf8;
12 CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
16 CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
19 CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
21 INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
22 INSERT INTO `T2` VALUES ('あ'),('い'),('う');
23 INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
24 INSERT INTO `T4` VALUES ('ア'),('イ'),('ウ');
25 INSERT INTO `T5` VALUES ('あ'),('い'),('う');
26 INSERT INTO `T6` VALUES ('龔'),('龖'),('龗');
27 INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
28 INSERT INTO `T8` VALUES ('あ'),('い'),('う');
29 INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
30 SELECT * FROM `T1`;
31 C1
32 ア
33 イ
34 ウ
35 SELECT * FROM `T2`;
36 C1
37 あ
38 い
39 う
40 SELECT * FROM `T3`;
41 C1
42 龔
43 龖
44 龗
45 SELECT * FROM `T4`;
46 C1
47 ア
48 イ
49 ウ
50 SELECT * FROM `T5`;
51 C1
52 あ
53 い
54 う
55 SELECT * FROM `T6`;
56 C1
57 龔
58 龖
59 龗
60 SELECT * FROM `T7`;
61 C1
62 ア
63 イ
64 ウ
65 SELECT * FROM `T8`;
66 C1
67 あ
68 い
69 う
70 SELECT * FROM `T9`;
71 C1
72 龔
73 龖
74 龗
75 SHOW CREATE TABLE `T1`;
76 Table Create Table
77 T1 CREATE TABLE `T1` (
78 `C1` enum('ア','イ','ウ') DEFAULT NULL,
79 KEY `C1` (`C1`)
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
81 SHOW CREATE TABLE `T2`;
82 Table Create Table
83 T2 CREATE TABLE `T2` (
84 `C1` enum('あ','い','う') DEFAULT NULL,
85 KEY `C1` (`C1`)
86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
87 SHOW CREATE TABLE `T3`;
88 Table Create Table
89 T3 CREATE TABLE `T3` (
90 `C1` enum('龔','龖','龗') DEFAULT NULL,
91 KEY `C1` (`C1`)
92 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
93 SHOW CREATE TABLE `T4`;
94 Table Create Table
95 T4 CREATE TABLE `T4` (
96 `C1` enum('ア','イ','ウ') DEFAULT NULL,
97 KEY `C1` (`C1`)
98 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
99 SHOW CREATE TABLE `T5`;
100 Table Create Table
101 T5 CREATE TABLE `T5` (
102 `C1` enum('あ','い','う') DEFAULT NULL,
103 KEY `C1` (`C1`)
104 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
105 SHOW CREATE TABLE `T6`;
106 Table Create Table
107 T6 CREATE TABLE `T6` (
108 `C1` enum('龔','龖','龗') DEFAULT NULL,
109 KEY `C1` (`C1`)
110 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
111 SHOW CREATE TABLE `T7`;
112 Table Create Table
113 T7 CREATE TABLE `T7` (
114 `C1` enum('ア','イ','ウ') DEFAULT NULL,
115 KEY `C1` (`C1`)
116 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
117 SHOW CREATE TABLE `T8`;
118 Table Create Table
119 T8 CREATE TABLE `T8` (
120 `C1` enum('あ','い','う') DEFAULT NULL,
121 KEY `C1` (`C1`)
122 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
123 SHOW CREATE TABLE `T9`;
124 Table Create Table
125 T9 CREATE TABLE `T9` (
126 `C1` enum('龔','龖','龗') DEFAULT NULL,
127 KEY `C1` (`C1`)
128 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
129 DESC `T1`;
130 Field Type Null Key Default Extra
131 C1 enum('ア','イ','ウ') YES MUL NULL
132 DESC `T2`;
133 Field Type Null Key Default Extra
134 C1 enum('あ','い','う') YES MUL NULL
135 DESC `T3`;
136 Field Type Null Key Default Extra
137 C1 enum('龔','龖','龗') YES MUL NULL
138 DESC `T4`;
139 Field Type Null Key Default Extra
140 C1 enum('ア','イ','ウ') YES MUL NULL
141 DESC `T5`;
142 Field Type Null Key Default Extra
143 C1 enum('あ','い','う') YES MUL NULL
144 DESC `T6`;
145 Field Type Null Key Default Extra
146 C1 enum('龔','龖','龗') YES MUL NULL
147 DESC `T7`;
148 Field Type Null Key Default Extra
149 C1 enum('ア','イ','ウ') YES MUL NULL
150 DESC `T8`;
151 Field Type Null Key Default Extra
152 C1 enum('あ','い','う') YES MUL NULL
153 DESC `T9`;
154 Field Type Null Key Default Extra
155 C1 enum('龔','龖','龗') YES MUL NULL
156 ALTER TABLE `T1` ADD `C2` CHAR(1) NOT NULL FIRST;
157 ALTER TABLE `T2` ADD `C2` CHAR(1) NOT NULL FIRST;
158 ALTER TABLE `T3` ADD `C2` CHAR(1) NOT NULL FIRST;
159 ALTER TABLE `T4` ADD `C2` CHAR(1) NOT NULL FIRST;
160 ALTER TABLE `T5` ADD `C2` CHAR(1) NOT NULL FIRST;
161 ALTER TABLE `T6` ADD `C2` CHAR(1) NOT NULL FIRST;
162 ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
163 ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
164 ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
165 SHOW CREATE TABLE `T1`;
166 Table Create Table
167 T1 CREATE TABLE `T1` (
168 `C2` char(1) NOT NULL,
169 `C1` enum('ア','イ','ウ') DEFAULT NULL,
170 KEY `C1` (`C1`)
171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
172 SHOW CREATE TABLE `T2`;
173 Table Create Table
174 T2 CREATE TABLE `T2` (
175 `C2` char(1) NOT NULL,
176 `C1` enum('あ','い','う') DEFAULT NULL,
177 KEY `C1` (`C1`)
178 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
179 SHOW CREATE TABLE `T3`;
180 Table Create Table
181 T3 CREATE TABLE `T3` (
182 `C2` char(1) NOT NULL,
183 `C1` enum('龔','龖','龗') DEFAULT NULL,
184 KEY `C1` (`C1`)
185 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
186 SHOW CREATE TABLE `T4`;
187 Table Create Table
188 T4 CREATE TABLE `T4` (
189 `C2` char(1) NOT NULL,
190 `C1` enum('ア','イ','ウ') DEFAULT NULL,
191 KEY `C1` (`C1`)
192 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
193 SHOW CREATE TABLE `T5`;
194 Table Create Table
195 T5 CREATE TABLE `T5` (
196 `C2` char(1) NOT NULL,
197 `C1` enum('あ','い','う') DEFAULT NULL,
198 KEY `C1` (`C1`)
199 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
200 SHOW CREATE TABLE `T6`;
201 Table Create Table
202 T6 CREATE TABLE `T6` (
203 `C2` char(1) NOT NULL,
204 `C1` enum('龔','龖','龗') DEFAULT NULL,
205 KEY `C1` (`C1`)
206 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
207 SHOW CREATE TABLE `T7`;
208 Table Create Table
209 T7 CREATE TABLE `T7` (
210 `C2` char(1) NOT NULL,
211 `C1` enum('ア','イ','ウ') DEFAULT NULL,
212 KEY `C1` (`C1`)
213 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
214 SHOW CREATE TABLE `T8`;
215 Table Create Table
216 T8 CREATE TABLE `T8` (
217 `C2` char(1) NOT NULL,
218 `C1` enum('あ','い','う') DEFAULT NULL,
219 KEY `C1` (`C1`)
220 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
221 SHOW CREATE TABLE `T9`;
222 Table Create Table
223 T9 CREATE TABLE `T9` (
224 `C2` char(1) NOT NULL,
225 `C1` enum('龔','龖','龗') DEFAULT NULL,
226 KEY `C1` (`C1`)
227 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
228 DESC `T1`;
229 Field Type Null Key Default Extra
230 C2 char(1) NO NULL
231 C1 enum('ア','イ','ウ') YES MUL NULL
232 DESC `T2`;
233 Field Type Null Key Default Extra
234 C2 char(1) NO NULL
235 C1 enum('あ','い','う') YES MUL NULL
236 DESC `T3`;
237 Field Type Null Key Default Extra
238 C2 char(1) NO NULL
239 C1 enum('龔','龖','龗') YES MUL NULL
240 DESC `T4`;
241 Field Type Null Key Default Extra
242 C2 char(1) NO NULL
243 C1 enum('ア','イ','ウ') YES MUL NULL
244 DESC `T5`;
245 Field Type Null Key Default Extra
246 C2 char(1) NO NULL
247 C1 enum('あ','い','う') YES MUL NULL
248 DESC `T6`;
249 Field Type Null Key Default Extra
250 C2 char(1) NO NULL
251 C1 enum('龔','龖','龗') YES MUL NULL
252 DESC `T7`;
253 Field Type Null Key Default Extra
254 C2 char(1) NO NULL
255 C1 enum('ア','イ','ウ') YES MUL NULL
256 DESC `T8`;
257 Field Type Null Key Default Extra
258 C2 char(1) NO NULL
259 C1 enum('あ','い','う') YES MUL NULL
260 DESC `T9`;
261 Field Type Null Key Default Extra
262 C2 char(1) NO NULL
263 C1 enum('龔','龖','龗') YES MUL NULL
264 DROP TABLE `T1`;
265 DROP TABLE `T2`;
266 DROP TABLE `T3`;
267 DROP TABLE `T4`;
268 DROP TABLE `T5`;
269 DROP TABLE `T6`;
270 DROP TABLE `T7`;
271 DROP TABLE `T8`;
272 DROP TABLE `T9`;