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`;
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`;
62
SELECT * FROM `T1a` INNER JOIN `T1b`;
67
SELECT * FROM `T1a` JOIN `T1b` USING (`C1`);
70
SELECT * FROM `T1a` INNER JOIN `T1b` USING (`C1`);
73
SELECT * FROM `T1a` CROSS JOIN `T1b`;
78
SELECT * FROM `T1a` LEFT JOIN `T1b` USING (`C1`);
83
SELECT * FROM `T1a` LEFT JOIN `T1b` ON (`T1a`.`C1` = `T1b`.`C1`);
88
SELECT * FROM `T1b` RIGHT JOIN `T1a` USING (`C1`);
93
SELECT * FROM `T1b` RIGHT JOIN `T1a` ON (`T1a`.`C1` = `T1b`.`C1`);
98
SELECT * FROM `T2a` JOIN `T2b`;
103
SELECT * FROM `T2a` INNER JOIN `T2b`;
108
SELECT * FROM `T2a` JOIN `T2b` USING (`C1`);
111
SELECT * FROM `T2a` INNER JOIN `T2b` USING (`C1`);
114
SELECT * FROM `T2a` CROSS JOIN `T2b`;
119
SELECT * FROM `T2a` LEFT JOIN `T2b` USING (`C1`);
124
SELECT * FROM `T2a` LEFT JOIN `T2b` ON (`T2a`.`C1` = `T2b`.`C1`);
129
SELECT * FROM `T2b` RIGHT JOIN `T2a` USING (`C1`);
134
SELECT * FROM `T2b` RIGHT JOIN `T2a` ON (`T2a`.`C1` = `T2b`.`C1`);
139
SELECT * FROM `T3a` JOIN `T3b`;
144
SELECT * FROM `T3a` INNER JOIN `T3b`;
149
SELECT * FROM `T3a` JOIN `T3b` USING (`C1`);
152
SELECT * FROM `T3a` INNER JOIN `T3b` USING (`C1`);
155
SELECT * FROM `T3a` CROSS JOIN `T3b`;
160
SELECT * FROM `T3a` LEFT JOIN `T3b` USING (`C1`);
165
SELECT * FROM `T3a` LEFT JOIN `T3b` ON (`T3a`.`C1` = `T3b`.`C1`);
170
SELECT * FROM `T3b` RIGHT JOIN `T3a` USING (`C1`);
175
SELECT * FROM `T3b` RIGHT JOIN `T3a` ON (`T3a`.`C1` = `T3b`.`C1`);
180
SELECT * FROM `T4a` JOIN `T4b`;
185
SELECT * FROM `T4a` INNER JOIN `T4b`;
190
SELECT * FROM `T4a` JOIN `T4b` USING (`C1`);
193
SELECT * FROM `T4a` INNER JOIN `T4b` USING (`C1`);
196
SELECT * FROM `T4a` CROSS JOIN `T4b`;
201
SELECT * FROM `T4a` LEFT JOIN `T4b` USING (`C1`);
206
SELECT * FROM `T4a` LEFT JOIN `T4b` ON (`T4a`.`C1` = `T4b`.`C1`);
211
SELECT * FROM `T4b` RIGHT JOIN `T4a` USING (`C1`);
216
SELECT * FROM `T4b` RIGHT JOIN `T4a` ON (`T4a`.`C1` = `T4b`.`C1`);
221
SELECT * FROM `T5a` JOIN `T5b`;
226
SELECT * FROM `T5a` INNER JOIN `T5b`;
231
SELECT * FROM `T5a` JOIN `T5b` USING (`C1`);
234
SELECT * FROM `T5a` INNER JOIN `T5b` USING (`C1`);
237
SELECT * FROM `T5a` CROSS JOIN `T5b`;
242
SELECT * FROM `T5a` LEFT JOIN `T5b` USING (`C1`);
247
SELECT * FROM `T5a` LEFT JOIN `T5b` ON (`T5a`.`C1` = `T5b`.`C1`);
252
SELECT * FROM `T5b` RIGHT JOIN `T5a` USING (`C1`);
257
SELECT * FROM `T5b` RIGHT JOIN `T5a` ON (`T5a`.`C1` = `T5b`.`C1`);
262
SELECT * FROM `T6a` JOIN `T6b`;
267
SELECT * FROM `T6a` INNER JOIN `T6b`;
272
SELECT * FROM `T6a` JOIN `T6b` USING (`C1`);
275
SELECT * FROM `T6a` INNER JOIN `T6b` USING (`C1`);
278
SELECT * FROM `T6a` CROSS JOIN `T6b`;
283
SELECT * FROM `T6a` LEFT JOIN `T6b` USING (`C1`);
288
SELECT * FROM `T6a` LEFT JOIN `T6b` ON (`T6a`.`C1` = `T6b`.`C1`);
293
SELECT * FROM `T6b` RIGHT JOIN `T6a` USING (`C1`);
298
SELECT * FROM `T6b` RIGHT JOIN `T6a` ON (`T6a`.`C1` = `T6b`.`C1`);
303
SELECT * FROM `T7a` JOIN `T7b`;
308
SELECT * FROM `T7a` INNER JOIN `T7b`;
313
SELECT * FROM `T7a` JOIN `T7b` USING (`C1`);
316
SELECT * FROM `T7a` INNER JOIN `T7b` USING (`C1`);
319
SELECT * FROM `T7a` CROSS JOIN `T7b`;
324
SELECT * FROM `T7a` LEFT JOIN `T7b` USING (`C1`);
329
SELECT * FROM `T7a` LEFT JOIN `T7b` ON (`T7a`.`C1` = `T7b`.`C1`);
334
SELECT * FROM `T7b` RIGHT JOIN `T7a` USING (`C1`);
339
SELECT * FROM `T7b` RIGHT JOIN `T7a` ON (`T7a`.`C1` = `T7b`.`C1`);
344
SELECT * FROM `T8a` JOIN `T8b`;
349
SELECT * FROM `T8a` INNER JOIN `T8b`;
354
SELECT * FROM `T8a` JOIN `T8b` USING (`C1`);
357
SELECT * FROM `T8a` INNER JOIN `T8b` USING (`C1`);
360
SELECT * FROM `T8a` CROSS JOIN `T8b`;
365
SELECT * FROM `T8a` LEFT JOIN `T8b` USING (`C1`);
370
SELECT * FROM `T8a` LEFT JOIN `T8b` ON (`T8a`.`C1` = `T8b`.`C1`);
375
SELECT * FROM `T8b` RIGHT JOIN `T8a` USING (`C1`);
380
SELECT * FROM `T8b` RIGHT JOIN `T8a` ON (`T8a`.`C1` = `T8b`.`C1`);
385
SELECT * FROM `T9a` JOIN `T9b`;
390
SELECT * FROM `T9a` INNER JOIN `T9b`;
395
SELECT * FROM `T9a` JOIN `T9b` USING (`C1`);
398
SELECT * FROM `T9a` INNER JOIN `T9b` USING (`C1`);
401
SELECT * FROM `T9a` CROSS JOIN `T9b`;
406
SELECT * FROM `T9a` LEFT JOIN `T9b` USING (`C1`);
411
SELECT * FROM `T9a` LEFT JOIN `T9b` ON (`T9a`.`C1` = `T9b`.`C1`);
416
SELECT * FROM `T9b` RIGHT JOIN `T9a` USING (`C1`);
421
SELECT * FROM `T9b` RIGHT JOIN `T9a` ON (`T9a`.`C1` = `T9b`.`C1`);