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