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