Debian Codegraph @

mysql-test/suite/jp/r/jp_like_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` char(20), 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` char(20), 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` char(20), 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` char(20), 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` char(20), 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` char(20), 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` char(20), 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` char(20), 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` char(20), 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 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
47 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
48 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
49 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
50 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
51 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
52 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
53 SELECT * FROM `T1` WHERE `C1` LIKE ' %';
54 C1
55 !"#$%&'()*+,-./
56 。「」、・ヲァィゥェォャュョッ
57 SELECT * FROM `T1` WHERE `C1` LIKE '% %';
58 C1
59 !"#$%&'()*+,-./
60 。「」、・ヲァィゥェォャュョッ
61 SELECT * FROM `T1` WHERE `C1` LIKE '% ';
62 C1
63 SELECT * FROM `T1` WHERE `C1` LIKE 'タ%';
64 C1
65 タチツテトナニヌネノハヒフヘホマ
66 SELECT * FROM `T1` WHERE `C1` LIKE '%ラリ%';
67 C1
68 ミムメモヤユヨラリルレロワン゙゚
69 SELECT * FROM `T1` WHERE `C1` LIKE '%ソ';
70 C1
71 ーアイウエオカキクケコサシスセソ
72 SELECT * FROM `T1` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
73 C1
74 ーアイウエオカキクケコサシスセソ
75 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
76 C1
77 ーアイウエオカキクケコサシスセソ
78 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
79 C1
80 ーアイウエオカキクケコサシスセソ
81 SELECT * FROM `T2` WHERE `C1` LIKE ' %';
82 C1
83   、。,.・:;?!゛゜´`¨^ ̄_ヽ
84 SELECT * FROM `T2` WHERE `C1` LIKE '% %';
85 C1
86   、。,.・:;?!゛゜´`¨^ ̄_ヽ
87 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
88 SELECT * FROM `T2` WHERE `C1` LIKE '% ';
89 C1
90 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
91 SELECT * FROM `T2` WHERE `C1` LIKE 'と%';
92 C1
93 とどなにぬねのはばぱひびぴふぶぷへべぺほ
94 SELECT * FROM `T2` WHERE `C1` LIKE '%あ%';
95 C1
96 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
97 SELECT * FROM `T2` WHERE `C1` LIKE '%わ';
98 C1
99 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
100 SELECT * FROM `T2` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
101 C1
102 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
103 SELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
104 C1
105 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
106 SELECT * FROM `T2` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
107 C1
108 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
109 SELECT * FROM `T3` WHERE `C1` LIKE '鼫%';
110 C1
111 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
112 SELECT * FROM `T3` WHERE `C1` LIKE '%鼺%';
113 C1
114 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
115 SELECT * FROM `T3` WHERE `C1` LIKE '%齖';
116 C1
117 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
118 SELECT * FROM `T3` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
119 C1
120 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
121 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
122 C1
123 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
124 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
125 C1
126 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
127 SELECT * FROM `T4` WHERE `C1` LIKE ' %';
128 C1
129 !"#$%&'()*+,-./
130 。「」、・ヲァィゥェォャュョッ
131 SELECT * FROM `T4` WHERE `C1` LIKE '% %';
132 C1
133 !"#$%&'()*+,-./
134 。「」、・ヲァィゥェォャュョッ
135 SELECT * FROM `T4` WHERE `C1` LIKE '% ';
136 C1
137 SELECT * FROM `T4` WHERE `C1` LIKE 'タ%';
138 C1
139 タチツテトナニヌネノハヒフヘホマ
140 SELECT * FROM `T4` WHERE `C1` LIKE '%ラリ%';
141 C1
142 ミムメモヤユヨラリルレロワン゙゚
143 SELECT * FROM `T4` WHERE `C1` LIKE '%ソ';
144 C1
145 ーアイウエオカキクケコサシスセソ
146 SELECT * FROM `T4` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
147 C1
148 ーアイウエオカキクケコサシスセソ
149 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
150 C1
151 ーアイウエオカキクケコサシスセソ
152 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
153 C1
154 ーアイウエオカキクケコサシスセソ
155 SELECT * FROM `T5` WHERE `C1` LIKE ' %';
156 C1
157   、。,.・:;?!゛゜´`¨^ ̄_ヽ
158 SELECT * FROM `T5` WHERE `C1` LIKE '% %';
159 C1
160   、。,.・:;?!゛゜´`¨^ ̄_ヽ
161 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
162 SELECT * FROM `T5` WHERE `C1` LIKE '% ';
163 C1
164 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
165 SELECT * FROM `T5` WHERE `C1` LIKE 'と%';
166 C1
167 とどなにぬねのはばぱひびぴふぶぷへべぺほ
168 SELECT * FROM `T5` WHERE `C1` LIKE '%あ%';
169 C1
170 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
171 SELECT * FROM `T5` WHERE `C1` LIKE '%わ';
172 C1
173 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
174 SELECT * FROM `T5` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
175 C1
176 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
177 SELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
178 C1
179 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
180 SELECT * FROM `T5` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
181 C1
182 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
183 SELECT * FROM `T6` WHERE `C1` LIKE '鼫%';
184 C1
185 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
186 SELECT * FROM `T6` WHERE `C1` LIKE '%鼺%';
187 C1
188 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
189 SELECT * FROM `T6` WHERE `C1` LIKE '%齖';
190 C1
191 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
192 SELECT * FROM `T6` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
193 C1
194 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
195 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
196 C1
197 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
198 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
199 C1
200 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
201 SELECT * FROM `T7` WHERE `C1` LIKE ' %';
202 C1
203 !"#$%&'()*+,-./
204 。「」、・ヲァィゥェォャュョッ
205 SELECT * FROM `T7` WHERE `C1` LIKE '% %';
206 C1
207 !"#$%&'()*+,-./
208 。「」、・ヲァィゥェォャュョッ
209 SELECT * FROM `T7` WHERE `C1` LIKE '% ';
210 C1
211 SELECT * FROM `T7` WHERE `C1` LIKE 'タ%';
212 C1
213 タチツテトナニヌネノハヒフヘホマ
214 SELECT * FROM `T7` WHERE `C1` LIKE '%ラリ%';
215 C1
216 ミムメモヤユヨラリルレロワン゙゚
217 SELECT * FROM `T7` WHERE `C1` LIKE '%ソ';
218 C1
219 ーアイウエオカキクケコサシスセソ
220 SELECT * FROM `T7` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
221 C1
222 ーアイウエオカキクケコサシスセソ
223 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
224 C1
225 ーアイウエオカキクケコサシスセソ
226 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
227 C1
228 ーアイウエオカキクケコサシスセソ
229 SELECT * FROM `T8` WHERE `C1` LIKE ' %';
230 C1
231   、。,.・:;?!゛゜´`¨^ ̄_ヽ
232 SELECT * FROM `T8` WHERE `C1` LIKE '% %';
233 C1
234   、。,.・:;?!゛゜´`¨^ ̄_ヽ
235 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
236 SELECT * FROM `T8` WHERE `C1` LIKE '% ';
237 C1
238 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
239 SELECT * FROM `T8` WHERE `C1` LIKE 'と%';
240 C1
241 とどなにぬねのはばぱひびぴふぶぷへべぺほ
242 SELECT * FROM `T8` WHERE `C1` LIKE '%あ%';
243 C1
244 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
245 SELECT * FROM `T8` WHERE `C1` LIKE '%わ';
246 C1
247 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
248 SELECT * FROM `T8` WHERE `C1` LIKE '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
249 C1
250 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
251 SELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ%';
252 C1
253 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
254 SELECT * FROM `T8` WHERE `C1` LIKE '%・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
255 C1
256 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
257 SELECT * FROM `T9` WHERE `C1` LIKE '鼫%';
258 C1
259 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
260 SELECT * FROM `T9` WHERE `C1` LIKE '%鼺%';
261 C1
262 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
263 SELECT * FROM `T9` WHERE `C1` LIKE '%齖';
264 C1
265 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
266 SELECT * FROM `T9` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
267 C1
268 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
269 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
270 C1
271 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
272 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
273 C1
274 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
275 DROP TABLE `T1`;
276 DROP TABLE `T2`;
277 DROP TABLE `T3`;
278 DROP TABLE `T4`;
279 DROP TABLE `T5`;
280 DROP TABLE `T6`;
281 DROP TABLE `T7`;
282 DROP TABLE `T8`;
283 DROP TABLE `T9`;