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 character_set_collations='utf8mb3=utf8mb3_general_ci';
11 SET NAMES utf8;
12 SET character_set_database = utf8;
13 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
16 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
19 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
21 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
22 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
23 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
24 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
25 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
26 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
27 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
28 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
29 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
30 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
31 SELECT * FROM `T1` WHERE `C1` LIKE ' %';
32 C1
33 !"#$%&'()*+,-./
34 。「」、・ヲァィゥェォャュョッ
35 SELECT * FROM `T1` WHERE `C1` LIKE '% %';
36 C1
37 !"#$%&'()*+,-./
38 。「」、・ヲァィゥェォャュョッ
39 SELECT * FROM `T1` WHERE `C1` LIKE '% ';
40 C1
41 SELECT * FROM `T1` WHERE `C1` LIKE 'タ%';
42 C1
43 タチツテトナニヌネノハヒフヘホマ
44 SELECT * FROM `T1` WHERE `C1` LIKE '%ラリ%';
45 C1
46 ミムメモヤユヨラリルレロワン゙゚
47 SELECT * FROM `T1` WHERE `C1` LIKE '%ソ';
48 C1
49 ーアイウエオカキクケコサシスセソ
50 SELECT * FROM `T1` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
51 C1
52 ーアイウエオカキクケコサシスセソ
53 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
54 C1
55 ーアイウエオカキクケコサシスセソ
56 SELECT * FROM `T1` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
57 C1
58 ーアイウエオカキクケコサシスセソ
59 SELECT * FROM `T2` WHERE `C1` LIKE ' %';
60 C1
61   、。,.・:;?!゛゜´`¨^ ̄_ヽ
62 SELECT * FROM `T2` WHERE `C1` LIKE '% %';
63 C1
64   、。,.・:;?!゛゜´`¨^ ̄_ヽ
65 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
66 SELECT * FROM `T2` WHERE `C1` LIKE '% ';
67 C1
68 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
69 SELECT * FROM `T2` WHERE `C1` LIKE 'と%';
70 C1
71 とどなにぬねのはばぱひびぴふぶぷへべぺほ
72 SELECT * FROM `T2` WHERE `C1` LIKE '%あ%';
73 C1
74 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
75 SELECT * FROM `T2` WHERE `C1` LIKE '%わ';
76 C1
77 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
78 SELECT * FROM `T2` 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 SELECT * FROM `T3` WHERE `C1` LIKE '鼫%';
88 C1
89 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
90 SELECT * FROM `T3` WHERE `C1` LIKE '%鼺%';
91 C1
92 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
93 SELECT * FROM `T3` WHERE `C1` LIKE '%齖';
94 C1
95 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
96 SELECT * FROM `T3` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
97 C1
98 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
99 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
100 C1
101 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
102 SELECT * FROM `T3` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
103 C1
104 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
105 SELECT * FROM `T4` WHERE `C1` LIKE ' %';
106 C1
107 !"#$%&'()*+,-./
108 。「」、・ヲァィゥェォャュョッ
109 SELECT * FROM `T4` WHERE `C1` LIKE '% %';
110 C1
111 !"#$%&'()*+,-./
112 。「」、・ヲァィゥェォャュョッ
113 SELECT * FROM `T4` WHERE `C1` LIKE '% ';
114 C1
115 SELECT * FROM `T4` WHERE `C1` LIKE 'タ%';
116 C1
117 タチツテトナニヌネノハヒフヘホマ
118 SELECT * FROM `T4` WHERE `C1` LIKE '%ラリ%';
119 C1
120 ミムメモヤユヨラリルレロワン゙゚
121 SELECT * FROM `T4` WHERE `C1` LIKE '%ソ';
122 C1
123 ーアイウエオカキクケコサシスセソ
124 SELECT * FROM `T4` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
125 C1
126 ーアイウエオカキクケコサシスセソ
127 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
128 C1
129 ーアイウエオカキクケコサシスセソ
130 SELECT * FROM `T4` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
131 C1
132 ーアイウエオカキクケコサシスセソ
133 SELECT * FROM `T5` WHERE `C1` LIKE ' %';
134 C1
135   、。,.・:;?!゛゜´`¨^ ̄_ヽ
136 SELECT * FROM `T5` WHERE `C1` LIKE '% %';
137 C1
138   、。,.・:;?!゛゜´`¨^ ̄_ヽ
139 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
140 SELECT * FROM `T5` WHERE `C1` LIKE '% ';
141 C1
142 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
143 SELECT * FROM `T5` WHERE `C1` LIKE 'と%';
144 C1
145 とどなにぬねのはばぱひびぴふぶぷへべぺほ
146 SELECT * FROM `T5` WHERE `C1` LIKE '%あ%';
147 C1
148 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
149 SELECT * FROM `T5` WHERE `C1` LIKE '%わ';
150 C1
151 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
152 SELECT * FROM `T5` 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 SELECT * FROM `T6` WHERE `C1` LIKE '鼫%';
162 C1
163 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
164 SELECT * FROM `T6` WHERE `C1` LIKE '%鼺%';
165 C1
166 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
167 SELECT * FROM `T6` WHERE `C1` LIKE '%齖';
168 C1
169 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
170 SELECT * FROM `T6` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
171 C1
172 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
173 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
174 C1
175 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
176 SELECT * FROM `T6` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
177 C1
178 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
179 SELECT * FROM `T7` WHERE `C1` LIKE ' %';
180 C1
181 !"#$%&'()*+,-./
182 。「」、・ヲァィゥェォャュョッ
183 SELECT * FROM `T7` WHERE `C1` LIKE '% %';
184 C1
185 !"#$%&'()*+,-./
186 。「」、・ヲァィゥェォャュョッ
187 SELECT * FROM `T7` WHERE `C1` LIKE '% ';
188 C1
189 SELECT * FROM `T7` WHERE `C1` LIKE 'タ%';
190 C1
191 タチツテトナニヌネノハヒフヘホマ
192 SELECT * FROM `T7` WHERE `C1` LIKE '%ラリ%';
193 C1
194 ミムメモヤユヨラリルレロワン゙゚
195 SELECT * FROM `T7` WHERE `C1` LIKE '%ソ';
196 C1
197 ーアイウエオカキクケコサシスセソ
198 SELECT * FROM `T7` WHERE `C1` LIKE 'ーアイウエオカキクケコサシスセソ%';
199 C1
200 ーアイウエオカキクケコサシスセソ
201 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ%';
202 C1
203 ーアイウエオカキクケコサシスセソ
204 SELECT * FROM `T7` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ';
205 C1
206 ーアイウエオカキクケコサシスセソ
207 SELECT * FROM `T8` WHERE `C1` LIKE ' %';
208 C1
209   、。,.・:;?!゛゜´`¨^ ̄_ヽ
210 SELECT * FROM `T8` WHERE `C1` LIKE '% %';
211 C1
212   、。,.・:;?!゛゜´`¨^ ̄_ヽ
213 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
214 SELECT * FROM `T8` WHERE `C1` LIKE '% ';
215 C1
216 ・・ʼn♯♭♪†‡¶・・・・◯・・・・ 
217 SELECT * FROM `T8` WHERE `C1` LIKE 'と%';
218 C1
219 とどなにぬねのはばぱひびぴふぶぷへべぺほ
220 SELECT * FROM `T8` WHERE `C1` LIKE '%あ%';
221 C1
222 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
223 SELECT * FROM `T8` WHERE `C1` LIKE '%わ';
224 C1
225 ぼぽまみむめもゃやゅゆょよらりるれろゎわ
226 SELECT * FROM `T8` 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 SELECT * FROM `T9` WHERE `C1` LIKE '鼫%';
236 C1
237 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
238 SELECT * FROM `T9` WHERE `C1` LIKE '%鼺%';
239 C1
240 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
241 SELECT * FROM `T9` WHERE `C1` LIKE '%齖';
242 C1
243 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
244 SELECT * FROM `T9` WHERE `C1` LIKE '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
245 C1
246 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
247 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖%';
248 C1
249 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
250 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
251 C1
252 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
253 DROP TABLE `T1`;
254 DROP TABLE `T2`;
255 DROP TABLE `T3`;
256 DROP TABLE `T4`;
257 DROP TABLE `T5`;
258 DROP TABLE `T6`;
259 DROP TABLE `T7`;
260 DROP TABLE `T8`;
261 DROP TABLE `T9`;