Debian Codegraph @

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

raw
1 drop table if exists `T1a`;
2 drop table if exists `T1b`;
3 drop table if exists `T2a`;
4 drop table if exists `T2b`;
5 drop table if exists `T3a`;
6 drop table if exists `T3b`;
7 drop table if exists `T4a`;
8 drop table if exists `T4b`;
9 drop table if exists `T5a`;
10 drop table if exists `T5b`;
11 drop table if exists `T6a`;
12 drop table if exists `T6b`;
13 drop table if exists `T7a`;
14 drop table if exists `T7b`;
15 drop table if exists `T8a`;
16 drop table if exists `T8b`;
17 drop table if exists `T9a`;
18 drop table if exists `T9b`;
19 SET NAMES utf8;
20 SET character_set_database = utf8;
21 CREATE TABLE `T1a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
22 CREATE TABLE `T1b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
23 CREATE TABLE `T2a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
24 CREATE TABLE `T2b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
25 CREATE TABLE `T3a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
26 CREATE TABLE `T3b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB;
27 CREATE TABLE `T4a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
28 CREATE TABLE `T4b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
29 CREATE TABLE `T5a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
30 CREATE TABLE `T5b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
31 CREATE TABLE `T6a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
32 CREATE TABLE `T6b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM;
33 CREATE TABLE `T7a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
34 CREATE TABLE `T7b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
35 CREATE TABLE `T8a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
36 CREATE TABLE `T8b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
37 CREATE TABLE `T9a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
38 CREATE TABLE `T9b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY;
39 INSERT INTO `T1a` VALUES ('ア'),('カ'),('サ');
40 INSERT INTO `T1b` VALUES ('ア');
41 INSERT INTO `T2a` VALUES ('あ'),('か'),('さ');
42 INSERT INTO `T2b` VALUES ('あ');
43 INSERT INTO `T3a` VALUES ('龔'),('龖'),('龗');
44 INSERT INTO `T3b` VALUES ('龔');
45 INSERT INTO `T4a` VALUES ('ア'),('カ'),('サ');
46 INSERT INTO `T4b` VALUES ('ア');
47 INSERT INTO `T5a` VALUES ('あ'),('か'),('さ');
48 INSERT INTO `T5b` VALUES ('あ');
49 INSERT INTO `T6a` VALUES ('龔'),('龖'),('龗');
50 INSERT INTO `T6b` VALUES ('龔');
51 INSERT INTO `T7a` VALUES ('ア'),('カ'),('サ');
52 INSERT INTO `T7b` VALUES ('ア');
53 INSERT INTO `T8a` VALUES ('あ'),('か'),('さ');
54 INSERT INTO `T8b` VALUES ('あ');
55 INSERT INTO `T9a` VALUES ('龔'),('龖'),('龗');
56 INSERT INTO `T9b` VALUES ('龔');
57 SELECT * FROM `T1a` JOIN `T1b`;
58 C1 C1
59 ア ア
60 カ ア
61 サ ア
62 SELECT * FROM `T1a` INNER JOIN `T1b`;
63 C1 C1
64 ア ア
65 カ ア
66 サ ア
67 SELECT * FROM `T1a` JOIN `T1b` USING (`C1`);
68 C1
69 ア
70 SELECT * FROM `T1a` INNER JOIN `T1b` USING (`C1`);
71 C1
72 ア
73 SELECT * FROM `T1a` CROSS JOIN `T1b`;
74 C1 C1
75 ア ア
76 カ ア
77 サ ア
78 SELECT * FROM `T1a` LEFT JOIN `T1b` USING (`C1`);
79 C1
80 ア
81 カ
82 サ
83 SELECT * FROM `T1a` LEFT JOIN `T1b` ON (`T1a`.`C1` = `T1b`.`C1`);
84 C1 C1
85 ア ア
86 カ NULL
87 サ NULL
88 SELECT * FROM `T1b` RIGHT JOIN `T1a` USING (`C1`);
89 C1
90 ア
91 カ
92 サ
93 SELECT * FROM `T1b` RIGHT JOIN `T1a` ON (`T1a`.`C1` = `T1b`.`C1`);
94 C1 C1
95 ア ア
96 NULL カ
97 NULL サ
98 SELECT * FROM `T2a` JOIN `T2b`;
99 C1 C1
100 あ あ
101 か あ
102 さ あ
103 SELECT * FROM `T2a` INNER JOIN `T2b`;
104 C1 C1
105 あ あ
106 か あ
107 さ あ
108 SELECT * FROM `T2a` JOIN `T2b` USING (`C1`);
109 C1
110 あ
111 SELECT * FROM `T2a` INNER JOIN `T2b` USING (`C1`);
112 C1
113 あ
114 SELECT * FROM `T2a` CROSS JOIN `T2b`;
115 C1 C1
116 あ あ
117 か あ
118 さ あ
119 SELECT * FROM `T2a` LEFT JOIN `T2b` USING (`C1`);
120 C1
121 あ
122 か
123 さ
124 SELECT * FROM `T2a` LEFT JOIN `T2b` ON (`T2a`.`C1` = `T2b`.`C1`);
125 C1 C1
126 あ あ
127 か NULL
128 さ NULL
129 SELECT * FROM `T2b` RIGHT JOIN `T2a` USING (`C1`);
130 C1
131 あ
132 か
133 さ
134 SELECT * FROM `T2b` RIGHT JOIN `T2a` ON (`T2a`.`C1` = `T2b`.`C1`);
135 C1 C1
136 あ あ
137 NULL か
138 NULL さ
139 SELECT * FROM `T3a` JOIN `T3b`;
140 C1 C1
141 龔 龔
142 龖 龔
143 龗 龔
144 SELECT * FROM `T3a` INNER JOIN `T3b`;
145 C1 C1
146 龔 龔
147 龖 龔
148 龗 龔
149 SELECT * FROM `T3a` JOIN `T3b` USING (`C1`);
150 C1
151 龔
152 SELECT * FROM `T3a` INNER JOIN `T3b` USING (`C1`);
153 C1
154 龔
155 SELECT * FROM `T3a` CROSS JOIN `T3b`;
156 C1 C1
157 龔 龔
158 龖 龔
159 龗 龔
160 SELECT * FROM `T3a` LEFT JOIN `T3b` USING (`C1`);
161 C1
162 龔
163 龖
164 龗
165 SELECT * FROM `T3a` LEFT JOIN `T3b` ON (`T3a`.`C1` = `T3b`.`C1`);
166 C1 C1
167 龔 龔
168 龖 NULL
169 龗 NULL
170 SELECT * FROM `T3b` RIGHT JOIN `T3a` USING (`C1`);
171 C1
172 龔
173 龖
174 龗
175 SELECT * FROM `T3b` RIGHT JOIN `T3a` ON (`T3a`.`C1` = `T3b`.`C1`);
176 C1 C1
177 龔 龔
178 NULL 龖
179 NULL 龗
180 SELECT * FROM `T4a` JOIN `T4b`;
181 C1 C1
182 ア ア
183 カ ア
184 サ ア
185 SELECT * FROM `T4a` INNER JOIN `T4b`;
186 C1 C1
187 ア ア
188 カ ア
189 サ ア
190 SELECT * FROM `T4a` JOIN `T4b` USING (`C1`);
191 C1
192 ア
193 SELECT * FROM `T4a` INNER JOIN `T4b` USING (`C1`);
194 C1
195 ア
196 SELECT * FROM `T4a` CROSS JOIN `T4b`;
197 C1 C1
198 ア ア
199 カ ア
200 サ ア
201 SELECT * FROM `T4a` LEFT JOIN `T4b` USING (`C1`);
202 C1
203 ア
204 カ
205 サ
206 SELECT * FROM `T4a` LEFT JOIN `T4b` ON (`T4a`.`C1` = `T4b`.`C1`);
207 C1 C1
208 ア ア
209 カ NULL
210 サ NULL
211 SELECT * FROM `T4b` RIGHT JOIN `T4a` USING (`C1`);
212 C1
213 ア
214 カ
215 サ
216 SELECT * FROM `T4b` RIGHT JOIN `T4a` ON (`T4a`.`C1` = `T4b`.`C1`);
217 C1 C1
218 ア ア
219 NULL カ
220 NULL サ
221 SELECT * FROM `T5a` JOIN `T5b`;
222 C1 C1
223 あ あ
224 か あ
225 さ あ
226 SELECT * FROM `T5a` INNER JOIN `T5b`;
227 C1 C1
228 あ あ
229 か あ
230 さ あ
231 SELECT * FROM `T5a` JOIN `T5b` USING (`C1`);
232 C1
233 あ
234 SELECT * FROM `T5a` INNER JOIN `T5b` USING (`C1`);
235 C1
236 あ
237 SELECT * FROM `T5a` CROSS JOIN `T5b`;
238 C1 C1
239 あ あ
240 か あ
241 さ あ
242 SELECT * FROM `T5a` LEFT JOIN `T5b` USING (`C1`);
243 C1
244 あ
245 か
246 さ
247 SELECT * FROM `T5a` LEFT JOIN `T5b` ON (`T5a`.`C1` = `T5b`.`C1`);
248 C1 C1
249 あ あ
250 か NULL
251 さ NULL
252 SELECT * FROM `T5b` RIGHT JOIN `T5a` USING (`C1`);
253 C1
254 あ
255 か
256 さ
257 SELECT * FROM `T5b` RIGHT JOIN `T5a` ON (`T5a`.`C1` = `T5b`.`C1`);
258 C1 C1
259 あ あ
260 NULL か
261 NULL さ
262 SELECT * FROM `T6a` JOIN `T6b`;
263 C1 C1
264 龔 龔
265 龖 龔
266 龗 龔
267 SELECT * FROM `T6a` INNER JOIN `T6b`;
268 C1 C1
269 龔 龔
270 龖 龔
271 龗 龔
272 SELECT * FROM `T6a` JOIN `T6b` USING (`C1`);
273 C1
274 龔
275 SELECT * FROM `T6a` INNER JOIN `T6b` USING (`C1`);
276 C1
277 龔
278 SELECT * FROM `T6a` CROSS JOIN `T6b`;
279 C1 C1
280 龔 龔
281 龖 龔
282 龗 龔
283 SELECT * FROM `T6a` LEFT JOIN `T6b` USING (`C1`);
284 C1
285 龔
286 龖
287 龗
288 SELECT * FROM `T6a` LEFT JOIN `T6b` ON (`T6a`.`C1` = `T6b`.`C1`);
289 C1 C1
290 龔 龔
291 龖 NULL
292 龗 NULL
293 SELECT * FROM `T6b` RIGHT JOIN `T6a` USING (`C1`);
294 C1
295 龔
296 龖
297 龗
298 SELECT * FROM `T6b` RIGHT JOIN `T6a` ON (`T6a`.`C1` = `T6b`.`C1`);
299 C1 C1
300 龔 龔
301 NULL 龖
302 NULL 龗
303 SELECT * FROM `T7a` JOIN `T7b`;
304 C1 C1
305 ア ア
306 カ ア
307 サ ア
308 SELECT * FROM `T7a` INNER JOIN `T7b`;
309 C1 C1
310 ア ア
311 カ ア
312 サ ア
313 SELECT * FROM `T7a` JOIN `T7b` USING (`C1`);
314 C1
315 ア
316 SELECT * FROM `T7a` INNER JOIN `T7b` USING (`C1`);
317 C1
318 ア
319 SELECT * FROM `T7a` CROSS JOIN `T7b`;
320 C1 C1
321 ア ア
322 カ ア
323 サ ア
324 SELECT * FROM `T7a` LEFT JOIN `T7b` USING (`C1`);
325 C1
326 ア
327 カ
328 サ
329 SELECT * FROM `T7a` LEFT JOIN `T7b` ON (`T7a`.`C1` = `T7b`.`C1`);
330 C1 C1
331 ア ア
332 カ NULL
333 サ NULL
334 SELECT * FROM `T7b` RIGHT JOIN `T7a` USING (`C1`);
335 C1
336 ア
337 カ
338 サ
339 SELECT * FROM `T7b` RIGHT JOIN `T7a` ON (`T7a`.`C1` = `T7b`.`C1`);
340 C1 C1
341 ア ア
342 NULL カ
343 NULL サ
344 SELECT * FROM `T8a` JOIN `T8b`;
345 C1 C1
346 あ あ
347 か あ
348 さ あ
349 SELECT * FROM `T8a` INNER JOIN `T8b`;
350 C1 C1
351 あ あ
352 か あ
353 さ あ
354 SELECT * FROM `T8a` JOIN `T8b` USING (`C1`);
355 C1
356 あ
357 SELECT * FROM `T8a` INNER JOIN `T8b` USING (`C1`);
358 C1
359 あ
360 SELECT * FROM `T8a` CROSS JOIN `T8b`;
361 C1 C1
362 あ あ
363 か あ
364 さ あ
365 SELECT * FROM `T8a` LEFT JOIN `T8b` USING (`C1`);
366 C1
367 あ
368 か
369 さ
370 SELECT * FROM `T8a` LEFT JOIN `T8b` ON (`T8a`.`C1` = `T8b`.`C1`);
371 C1 C1
372 あ あ
373 か NULL
374 さ NULL
375 SELECT * FROM `T8b` RIGHT JOIN `T8a` USING (`C1`);
376 C1
377 あ
378 か
379 さ
380 SELECT * FROM `T8b` RIGHT JOIN `T8a` ON (`T8a`.`C1` = `T8b`.`C1`);
381 C1 C1
382 あ あ
383 NULL か
384 NULL さ
385 SELECT * FROM `T9a` JOIN `T9b`;
386 C1 C1
387 龔 龔
388 龖 龔
389 龗 龔
390 SELECT * FROM `T9a` INNER JOIN `T9b`;
391 C1 C1
392 龔 龔
393 龖 龔
394 龗 龔
395 SELECT * FROM `T9a` JOIN `T9b` USING (`C1`);
396 C1
397 龔
398 SELECT * FROM `T9a` INNER JOIN `T9b` USING (`C1`);
399 C1
400 龔
401 SELECT * FROM `T9a` CROSS JOIN `T9b`;
402 C1 C1
403 龔 龔
404 龖 龔
405 龗 龔
406 SELECT * FROM `T9a` LEFT JOIN `T9b` USING (`C1`);
407 C1
408 龔
409 龖
410 龗
411 SELECT * FROM `T9a` LEFT JOIN `T9b` ON (`T9a`.`C1` = `T9b`.`C1`);
412 C1 C1
413 龔 龔
414 龖 NULL
415 龗 NULL
416 SELECT * FROM `T9b` RIGHT JOIN `T9a` USING (`C1`);
417 C1
418 龔
419 龖
420 龗
421 SELECT * FROM `T9b` RIGHT JOIN `T9a` ON (`T9a`.`C1` = `T9b`.`C1`);
422 C1 C1
423 龔 龔
424 NULL 龖
425 NULL 龗
426 DROP TABLE `T1a`;
427 DROP TABLE `T1b`;
428 DROP TABLE `T2a`;
429 DROP TABLE `T2b`;
430 DROP TABLE `T3a`;
431 DROP TABLE `T3b`;
432 DROP TABLE `T4a`;
433 DROP TABLE `T4b`;
434 DROP TABLE `T5a`;
435 DROP TABLE `T5b`;
436 DROP TABLE `T6a`;
437 DROP TABLE `T6b`;
438 DROP TABLE `T7a`;
439 DROP TABLE `T7b`;
440 DROP TABLE `T8a`;
441 DROP TABLE `T8b`;
442 DROP TABLE `T9a`;
443 DROP TABLE `T9b`;