~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/r/jp_join

~drizzle-trunk/drizzle/development : (revision 1)

drop table if exists `Ｔ１`;
drop table if exists `Ｔ２`;
drop table if exists `Ｔ３`;
drop table if exists `Ｔ４`;
drop table if exists `Ｔ５`;
drop table if exists `Ｔ６`;
drop table if exists `Ｔ７`;
drop table if exists `Ｔ８`;
drop table if exists `Ｔ９`;
drop table if exists `Ｔ１０`;
drop table if exists `Ｔ１１`;
drop table if exists `Ｔ１２`;
SET NAMES utf8;
SET character_set_database = utf8;
CREATE TABLE `Ｔ１a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ２a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ２b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ３a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ３b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ４a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ４b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ５a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ５b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ６a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ６b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ７a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ７b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ８a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ８b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ９a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ９b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１０a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１０b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１１a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１１b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１２a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
CREATE TABLE `Ｔ１２b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
INSERT INTO `Ｔ１a` VALUES ('ｱ'),('ｶ'),('ｻ');
INSERT INTO `Ｔ１b` VALUES ('ｱ');
INSERT INTO `Ｔ２a` VALUES ('あ'),('か'),('さ');
INSERT INTO `Ｔ２b` VALUES ('あ');
INSERT INTO `Ｔ３a` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ３b` VALUES ('龔');
INSERT INTO `Ｔ４a` VALUES ('ｱ'),('ｶ'),('ｻ');
INSERT INTO `Ｔ４b` VALUES ('ｱ');
INSERT INTO `Ｔ５a` VALUES ('あ'),('か'),('さ');
INSERT INTO `Ｔ５b` VALUES ('あ');
INSERT INTO `Ｔ６a` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ６b` VALUES ('龔');
INSERT INTO `Ｔ７a` VALUES ('ｱ'),('ｶ'),('ｻ');
INSERT INTO `Ｔ７b` VALUES ('ｱ');
INSERT INTO `Ｔ８a` VALUES ('あ'),('か'),('さ');
INSERT INTO `Ｔ８b` VALUES ('あ');
INSERT INTO `Ｔ９a` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ９b` VALUES ('龔');
INSERT INTO `Ｔ１０a` VALUES ('ｱ'),('ｶ'),('ｻ');
INSERT INTO `Ｔ１０b` VALUES ('ｱ');
INSERT INTO `Ｔ１１a` VALUES ('あ'),('か'),('さ');
INSERT INTO `Ｔ１１b` VALUES ('あ');
INSERT INTO `Ｔ１２a` VALUES ('龔'),('龖'),('龗');
INSERT INTO `Ｔ１２b` VALUES ('龔');
SELECT * FROM `Ｔ１a` JOIN `Ｔ１b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１a` JOIN `Ｔ１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ１a` CROSS JOIN `Ｔ１b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ２a` JOIN `Ｔ２b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ２a` JOIN `Ｔ２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ２a` CROSS JOIN `Ｔ２b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ３a` JOIN `Ｔ３b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ３a` JOIN `Ｔ３b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ３a` CROSS JOIN `Ｔ３b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ４a` JOIN `Ｔ４b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ４a` JOIN `Ｔ４b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ４a` CROSS JOIN `Ｔ４b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ５a` JOIN `Ｔ５b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ５a` JOIN `Ｔ５b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ５a` CROSS JOIN `Ｔ５b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ６a` JOIN `Ｔ６b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ６a` JOIN `Ｔ６b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ６a` CROSS JOIN `Ｔ６b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ７a` JOIN `Ｔ７b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ７a` JOIN `Ｔ７b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ７a` CROSS JOIN `Ｔ７b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ８a` JOIN `Ｔ８b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ８a` JOIN `Ｔ８b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ８a` CROSS JOIN `Ｔ８b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ９a` JOIN `Ｔ９b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ９a` JOIN `Ｔ９b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ９a` CROSS JOIN `Ｔ９b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ１０a` JOIN `Ｔ１０b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１０a` INNER JOIN `Ｔ１０b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１０a` JOIN `Ｔ１０b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ１０a` INNER JOIN `Ｔ１０b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
SELECT * FROM `Ｔ１０a` CROSS JOIN `Ｔ１０b`;
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	ｱ
ｻ	ｱ
SELECT * FROM `Ｔ１０a` LEFT JOIN `Ｔ１０b` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ１０a` LEFT JOIN `Ｔ１０b` ON (`Ｔ１０a`.`Ｃ１` = `Ｔ１０b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
ｶ	NULL
ｻ	NULL
SELECT * FROM `Ｔ１０b` RIGHT JOIN `Ｔ１０a` USING (`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ１０b` RIGHT JOIN `Ｔ１０a` ON (`Ｔ１０a`.`Ｃ１` = `Ｔ１０b`.`Ｃ１`);
Ｃ１	Ｃ１
ｱ	ｱ
NULL	ｶ
NULL	ｻ
SELECT * FROM `Ｔ１１a` JOIN `Ｔ１１b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ１１a` INNER JOIN `Ｔ１１b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ１１a` JOIN `Ｔ１１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ１１a` INNER JOIN `Ｔ１１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
SELECT * FROM `Ｔ１１a` CROSS JOIN `Ｔ１１b`;
Ｃ１	Ｃ１
あ	あ
か	あ
さ	あ
SELECT * FROM `Ｔ１１a` LEFT JOIN `Ｔ１１b` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ１１a` LEFT JOIN `Ｔ１１b` ON (`Ｔ１１a`.`Ｃ１` = `Ｔ１１b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
か	NULL
さ	NULL
SELECT * FROM `Ｔ１１b` RIGHT JOIN `Ｔ１１a` USING (`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ１１b` RIGHT JOIN `Ｔ１１a` ON (`Ｔ１１a`.`Ｃ１` = `Ｔ１１b`.`Ｃ１`);
Ｃ１	Ｃ１
あ	あ
NULL	か
NULL	さ
SELECT * FROM `Ｔ１２a` JOIN `Ｔ１２b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ１２a` INNER JOIN `Ｔ１２b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ１２a` JOIN `Ｔ１２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ１２a` INNER JOIN `Ｔ１２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
SELECT * FROM `Ｔ１２a` CROSS JOIN `Ｔ１２b`;
Ｃ１	Ｃ１
龔	龔
龖	龔
龗	龔
SELECT * FROM `Ｔ１２a` LEFT JOIN `Ｔ１２b` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ１２a` LEFT JOIN `Ｔ１２b` ON (`Ｔ１２a`.`Ｃ１` = `Ｔ１２b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
龖	NULL
龗	NULL
SELECT * FROM `Ｔ１２b` RIGHT JOIN `Ｔ１２a` USING (`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
SELECT * FROM `Ｔ１２b` RIGHT JOIN `Ｔ１２a` ON (`Ｔ１２a`.`Ｃ１` = `Ｔ１２b`.`Ｃ１`);
Ｃ１	Ｃ１
龔	龔
NULL	龖
NULL	龗
DROP TABLE `Ｔ１a`;
DROP TABLE `Ｔ１b`;
DROP TABLE `Ｔ２a`;
DROP TABLE `Ｔ２b`;
DROP TABLE `Ｔ３a`;
DROP TABLE `Ｔ３b`;
DROP TABLE `Ｔ４a`;
DROP TABLE `Ｔ４b`;
DROP TABLE `Ｔ５a`;
DROP TABLE `Ｔ５b`;
DROP TABLE `Ｔ６a`;
DROP TABLE `Ｔ６b`;
DROP TABLE `Ｔ７a`;
DROP TABLE `Ｔ７b`;
DROP TABLE `Ｔ８a`;
DROP TABLE `Ｔ８b`;
DROP TABLE `Ｔ９a`;
DROP TABLE `Ｔ９b`;
DROP TABLE `Ｔ１０a`;
DROP TABLE `Ｔ１０b`;
DROP TABLE `Ｔ１１a`;
DROP TABLE `Ｔ１１b`;
DROP TABLE `Ｔ１２a`;
DROP TABLE `Ｔ１２b`;

1 by brian clean slate	1	drop table if exists `Ｔ１`;
	2	drop table if exists `Ｔ２`;
	3	drop table if exists `Ｔ３`;
	4	drop table if exists `Ｔ４`;
	5	drop table if exists `Ｔ５`;
	6	drop table if exists `Ｔ６`;
	7	drop table if exists `Ｔ７`;
	8	drop table if exists `Ｔ８`;
	9	drop table if exists `Ｔ９`;
	10	drop table if exists `Ｔ１０`;
	11	drop table if exists `Ｔ１１`;
	12	drop table if exists `Ｔ１２`;
	13	SET NAMES utf8;
	14	SET character_set_database = utf8;
	15	CREATE TABLE `Ｔ１a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	16	CREATE TABLE `Ｔ１b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	17	CREATE TABLE `Ｔ２a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	18	CREATE TABLE `Ｔ２b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	19	CREATE TABLE `Ｔ３a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	20	CREATE TABLE `Ｔ３b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	21	CREATE TABLE `Ｔ４a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	22	CREATE TABLE `Ｔ４b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	23	CREATE TABLE `Ｔ５a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	24	CREATE TABLE `Ｔ５b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	25	CREATE TABLE `Ｔ６a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	26	CREATE TABLE `Ｔ６b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	27	CREATE TABLE `Ｔ７a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	28	CREATE TABLE `Ｔ７b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	29	CREATE TABLE `Ｔ８a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	30	CREATE TABLE `Ｔ８b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	31	CREATE TABLE `Ｔ９a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	32	CREATE TABLE `Ｔ９b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	33	CREATE TABLE `Ｔ１０a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	34	CREATE TABLE `Ｔ１０b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	35	CREATE TABLE `Ｔ１１a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	36	CREATE TABLE `Ｔ１１b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	37	CREATE TABLE `Ｔ１２a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	38	CREATE TABLE `Ｔ１２b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb;
	39	INSERT INTO `Ｔ１a` VALUES ('ｱ'),('ｶ'),('ｻ');
	40	INSERT INTO `Ｔ１b` VALUES ('ｱ');
	41	INSERT INTO `Ｔ２a` VALUES ('あ'),('か'),('さ');
	42	INSERT INTO `Ｔ２b` VALUES ('あ');
	43	INSERT INTO `Ｔ３a` VALUES ('龔'),('龖'),('龗');
	44	INSERT INTO `Ｔ３b` VALUES ('龔');
	45	INSERT INTO `Ｔ４a` VALUES ('ｱ'),('ｶ'),('ｻ');
	46	INSERT INTO `Ｔ４b` VALUES ('ｱ');
	47	INSERT INTO `Ｔ５a` VALUES ('あ'),('か'),('さ');
	48	INSERT INTO `Ｔ５b` VALUES ('あ');
	49	INSERT INTO `Ｔ６a` VALUES ('龔'),('龖'),('龗');
	50	INSERT INTO `Ｔ６b` VALUES ('龔');
	51	INSERT INTO `Ｔ７a` VALUES ('ｱ'),('ｶ'),('ｻ');
	52	INSERT INTO `Ｔ７b` VALUES ('ｱ');
	53	INSERT INTO `Ｔ８a` VALUES ('あ'),('か'),('さ');
	54	INSERT INTO `Ｔ８b` VALUES ('あ');
	55	INSERT INTO `Ｔ９a` VALUES ('龔'),('龖'),('龗');
	56	INSERT INTO `Ｔ９b` VALUES ('龔');
	57	INSERT INTO `Ｔ１０a` VALUES ('ｱ'),('ｶ'),('ｻ');
	58	INSERT INTO `Ｔ１０b` VALUES ('ｱ');
	59	INSERT INTO `Ｔ１１a` VALUES ('あ'),('か'),('さ');
	60	INSERT INTO `Ｔ１１b` VALUES ('あ');
	61	INSERT INTO `Ｔ１２a` VALUES ('龔'),('龖'),('龗');
	62	INSERT INTO `Ｔ１２b` VALUES ('龔');
	63	SELECT * FROM `Ｔ１a` JOIN `Ｔ１b`;
	64	Ｃ１Ｃ１
65	ｱｱ
66	ｶｱ
67	ｻｱ
68	SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b`;
69	Ｃ１Ｃ１
70	ｱｱ
71	ｶｱ
72	ｻｱ
73	SELECT * FROM `Ｔ１a` JOIN `Ｔ１b` USING (`Ｃ１`);
74	Ｃ１Ｃ１
75	ｱｱ
76	SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b` USING (`Ｃ１`);
77	Ｃ１Ｃ１
78	ｱｱ
79	SELECT * FROM `Ｔ１a` CROSS JOIN `Ｔ１b`;
80	Ｃ１Ｃ１
81	ｱｱ
82	ｶｱ
83	ｻｱ
84	SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` USING (`Ｃ１`);
85	Ｃ１Ｃ１
86	ｱｱ
87	ｶ NULL
88	ｻ NULL
89	SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`);
90	Ｃ１Ｃ１
91	ｱｱ
92	ｶ NULL
93	ｻ NULL
94	SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` USING (`Ｃ１`);
95	Ｃ１Ｃ１
96	ｱｱ
97	NULL ｶ
98	NULL ｻ
99	SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`);
100	Ｃ１Ｃ１
101	ｱｱ
102	NULL ｶ
103	NULL ｻ
104	SELECT * FROM `Ｔ２a` JOIN `Ｔ２b`;
105	Ｃ１Ｃ１
106	ああ
107	かあ
108	さあ
109	SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b`;
110	Ｃ１Ｃ１
111	ああ
112	かあ
113	さあ
114	SELECT * FROM `Ｔ２a` JOIN `Ｔ２b` USING (`Ｃ１`);
115	Ｃ１Ｃ１
116	ああ
117	SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b` USING (`Ｃ１`);
118	Ｃ１Ｃ１
119	ああ
120	SELECT * FROM `Ｔ２a` CROSS JOIN `Ｔ２b`;
121	Ｃ１Ｃ１
122	ああ
123	かあ
124	さあ
125	SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` USING (`Ｃ１`);
126	Ｃ１Ｃ１
127	ああ
128	か NULL
129	さ NULL
130	SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`);
131	Ｃ１Ｃ１
132	ああ
133	か NULL
134	さ NULL
135	SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` USING (`Ｃ１`);
136	Ｃ１Ｃ１
137	ああ
138	NULL か
139	NULL さ
140	SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`);
141	Ｃ１Ｃ１
142	ああ
143	NULL か
144	NULL さ
145	SELECT * FROM `Ｔ３a` JOIN `Ｔ３b`;
146	Ｃ１Ｃ１
147	龔龔
148	龖龔
149	龗龔
150	SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b`;
151	Ｃ１Ｃ１
152	龔龔
153	龖龔
154	龗龔
155	SELECT * FROM `Ｔ３a` JOIN `Ｔ３b` USING (`Ｃ１`);
156	Ｃ１Ｃ１
157	龔龔
158	SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b` USING (`Ｃ１`);
159	Ｃ１Ｃ１
160	龔龔
161	SELECT * FROM `Ｔ３a` CROSS JOIN `Ｔ３b`;
162	Ｃ１Ｃ１
163	龔龔
164	龖龔
165	龗龔
166	SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` USING (`Ｃ１`);
167	Ｃ１Ｃ１
168	龔龔
169	龖 NULL
170	龗 NULL
171	SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`);
172	Ｃ１Ｃ１
173	龔龔
174	龖 NULL
175	龗 NULL
176	SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` USING (`Ｃ１`);
177	Ｃ１Ｃ１
178	龔龔
179	NULL 龖
180	NULL 龗
181	SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`);
182	Ｃ１Ｃ１
183	龔龔
184	NULL 龖
185	NULL 龗
186	SELECT * FROM `Ｔ４a` JOIN `Ｔ４b`;
187	Ｃ１Ｃ１
188	ｱｱ
189	ｶｱ
190	ｻｱ
191	SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b`;
192	Ｃ１Ｃ１
193	ｱｱ
194	ｶｱ
195	ｻｱ
196	SELECT * FROM `Ｔ４a` JOIN `Ｔ４b` USING (`Ｃ１`);
197	Ｃ１Ｃ１
198	ｱｱ
199	SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b` USING (`Ｃ１`);
200	Ｃ１Ｃ１
201	ｱｱ
202	SELECT * FROM `Ｔ４a` CROSS JOIN `Ｔ４b`;
203	Ｃ１Ｃ１
204	ｱｱ
205	ｶｱ
206	ｻｱ
207	SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` USING (`Ｃ１`);
208	Ｃ１Ｃ１
209	ｱｱ
210	ｶ NULL
211	ｻ NULL
212	SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`);
213	Ｃ１Ｃ１
214	ｱｱ
215	ｶ NULL
216	ｻ NULL
217	SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` USING (`Ｃ１`);
218	Ｃ１Ｃ１
219	ｱｱ
220	NULL ｶ
221	NULL ｻ
222	SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`);
223	Ｃ１Ｃ１
224	ｱｱ
225	NULL ｶ
226	NULL ｻ
227	SELECT * FROM `Ｔ５a` JOIN `Ｔ５b`;
228	Ｃ１Ｃ１
229	ああ
230	かあ
231	さあ
232	SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b`;
233	Ｃ１Ｃ１
234	ああ
235	かあ
236	さあ
237	SELECT * FROM `Ｔ５a` JOIN `Ｔ５b` USING (`Ｃ１`);
238	Ｃ１Ｃ１
239	ああ
240	SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b` USING (`Ｃ１`);
241	Ｃ１Ｃ１
242	ああ
243	SELECT * FROM `Ｔ５a` CROSS JOIN `Ｔ５b`;
244	Ｃ１Ｃ１
245	ああ
246	かあ
247	さあ
248	SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` USING (`Ｃ１`);
249	Ｃ１Ｃ１
250	ああ
251	か NULL
252	さ NULL
253	SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`);
254	Ｃ１Ｃ１
255	ああ
256	か NULL
257	さ NULL
258	SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` USING (`Ｃ１`);
259	Ｃ１Ｃ１
260	ああ
261	NULL か
262	NULL さ
263	SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`);
264	Ｃ１Ｃ１
265	ああ
266	NULL か
267	NULL さ
268	SELECT * FROM `Ｔ６a` JOIN `Ｔ６b`;
269	Ｃ１Ｃ１
270	龔龔
271	龖龔
272	龗龔
273	SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b`;
274	Ｃ１Ｃ１
275	龔龔
276	龖龔
277	龗龔
278	SELECT * FROM `Ｔ６a` JOIN `Ｔ６b` USING (`Ｃ１`);
279	Ｃ１Ｃ１
280	龔龔
281	SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b` USING (`Ｃ１`);
282	Ｃ１Ｃ１
283	龔龔
284	SELECT * FROM `Ｔ６a` CROSS JOIN `Ｔ６b`;
285	Ｃ１Ｃ１
286	龔龔
287	龖龔
288	龗龔
289	SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` USING (`Ｃ１`);
290	Ｃ１Ｃ１
291	龔龔
292	龖 NULL
293	龗 NULL
294	SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`);
295	Ｃ１Ｃ１
296	龔龔
297	龖 NULL
298	龗 NULL
299	SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` USING (`Ｃ１`);
300	Ｃ１Ｃ１
301	龔龔
302	NULL 龖
303	NULL 龗
304	SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`);
305	Ｃ１Ｃ１
306	龔龔
307	NULL 龖
308	NULL 龗
309	SELECT * FROM `Ｔ７a` JOIN `Ｔ７b`;
310	Ｃ１Ｃ１
311	ｱｱ
312	ｶｱ
313	ｻｱ
314	SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b`;
315	Ｃ１Ｃ１
316	ｱｱ
317	ｶｱ
318	ｻｱ
319	SELECT * FROM `Ｔ７a` JOIN `Ｔ７b` USING (`Ｃ１`);
320	Ｃ１Ｃ１
321	ｱｱ
322	SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b` USING (`Ｃ１`);
323	Ｃ１Ｃ１
324	ｱｱ
325	SELECT * FROM `Ｔ７a` CROSS JOIN `Ｔ７b`;
326	Ｃ１Ｃ１
327	ｱｱ
328	ｶｱ
329	ｻｱ
330	SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` USING (`Ｃ１`);
331	Ｃ１Ｃ１
332	ｱｱ
333	ｶ NULL
334	ｻ NULL
335	SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`);
336	Ｃ１Ｃ１
337	ｱｱ
338	ｶ NULL
339	ｻ NULL
340	SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` USING (`Ｃ１`);
341	Ｃ１Ｃ１
342	ｱｱ
343	NULL ｶ
344	NULL ｻ
345	SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`);
346	Ｃ１Ｃ１
347	ｱｱ
348	NULL ｶ
349	NULL ｻ
350	SELECT * FROM `Ｔ８a` JOIN `Ｔ８b`;
351	Ｃ１Ｃ１
352	ああ
353	かあ
354	さあ
355	SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b`;
356	Ｃ１Ｃ１
357	ああ
358	かあ
359	さあ
360	SELECT * FROM `Ｔ８a` JOIN `Ｔ８b` USING (`Ｃ１`);
361	Ｃ１Ｃ１
362	ああ
363	SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b` USING (`Ｃ１`);
364	Ｃ１Ｃ１
365	ああ
366	SELECT * FROM `Ｔ８a` CROSS JOIN `Ｔ８b`;
367	Ｃ１Ｃ１
368	ああ
369	かあ
370	さあ
371	SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` USING (`Ｃ１`);
372	Ｃ１Ｃ１
373	ああ
374	か NULL
375	さ NULL
376	SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`);
377	Ｃ１Ｃ１
378	ああ
379	か NULL
380	さ NULL
381	SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` USING (`Ｃ１`);
382	Ｃ１Ｃ１
383	ああ
384	NULL か
385	NULL さ
386	SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`);
387	Ｃ１Ｃ１
388	ああ
389	NULL か
390	NULL さ
391	SELECT * FROM `Ｔ９a` JOIN `Ｔ９b`;
392	Ｃ１Ｃ１
393	龔龔
394	龖龔
395	龗龔
396	SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b`;
397	Ｃ１Ｃ１
398	龔龔
399	龖龔
400	龗龔
401	SELECT * FROM `Ｔ９a` JOIN `Ｔ９b` USING (`Ｃ１`);
402	Ｃ１Ｃ１
403	龔龔
404	SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b` USING (`Ｃ１`);
405	Ｃ１Ｃ１
406	龔龔
407	SELECT * FROM `Ｔ９a` CROSS JOIN `Ｔ９b`;
408	Ｃ１Ｃ１
409	龔龔
410	龖龔
411	龗龔
412	SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` USING (`Ｃ１`);
413	Ｃ１Ｃ１
414	龔龔
415	龖 NULL
416	龗 NULL
417	SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`);
418	Ｃ１Ｃ１
419	龔龔
420	龖 NULL
421	龗 NULL
422	SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` USING (`Ｃ１`);
423	Ｃ１Ｃ１
424	龔龔
425	NULL 龖
426	NULL 龗
427	SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`);
428	Ｃ１Ｃ１
429	龔龔
430	NULL 龖
431	NULL 龗
432	SELECT * FROM `Ｔ１０a` JOIN `Ｔ１０b`;
433	Ｃ１Ｃ１
434	ｱｱ
435	ｶｱ
436	ｻｱ
437	SELECT * FROM `Ｔ１０a` INNER JOIN `Ｔ１０b`;
438	Ｃ１Ｃ１
439	ｱｱ
440	ｶｱ
441	ｻｱ
442	SELECT * FROM `Ｔ１０a` JOIN `Ｔ１０b` USING (`Ｃ１`);
443	Ｃ１Ｃ１
444	ｱｱ
445	SELECT * FROM `Ｔ１０a` INNER JOIN `Ｔ１０b` USING (`Ｃ１`);
446	Ｃ１Ｃ１
447	ｱｱ
448	SELECT * FROM `Ｔ１０a` CROSS JOIN `Ｔ１０b`;
449	Ｃ１Ｃ１
450	ｱｱ
451	ｶｱ
452	ｻｱ
453	SELECT * FROM `Ｔ１０a` LEFT JOIN `Ｔ１０b` USING (`Ｃ１`);
454	Ｃ１Ｃ１
455	ｱｱ
456	ｶ NULL
457	ｻ NULL
458	SELECT * FROM `Ｔ１０a` LEFT JOIN `Ｔ１０b` ON (`Ｔ１０a`.`Ｃ１` = `Ｔ１０b`.`Ｃ１`);
459	Ｃ１Ｃ１
460	ｱｱ
461	ｶ NULL
462	ｻ NULL
463	SELECT * FROM `Ｔ１０b` RIGHT JOIN `Ｔ１０a` USING (`Ｃ１`);
464	Ｃ１Ｃ１
465	ｱｱ
466	NULL ｶ
467	NULL ｻ
468	SELECT * FROM `Ｔ１０b` RIGHT JOIN `Ｔ１０a` ON (`Ｔ１０a`.`Ｃ１` = `Ｔ１０b`.`Ｃ１`);
469	Ｃ１Ｃ１
470	ｱｱ
471	NULL ｶ
472	NULL ｻ
473	SELECT * FROM `Ｔ１１a` JOIN `Ｔ１１b`;
474	Ｃ１Ｃ１
475	ああ
476	かあ
477	さあ
478	SELECT * FROM `Ｔ１１a` INNER JOIN `Ｔ１１b`;
479	Ｃ１Ｃ１
480	ああ
481	かあ
482	さあ
483	SELECT * FROM `Ｔ１１a` JOIN `Ｔ１１b` USING (`Ｃ１`);
484	Ｃ１Ｃ１
485	ああ
486	SELECT * FROM `Ｔ１１a` INNER JOIN `Ｔ１１b` USING (`Ｃ１`);
487	Ｃ１Ｃ１
488	ああ
489	SELECT * FROM `Ｔ１１a` CROSS JOIN `Ｔ１１b`;
490	Ｃ１Ｃ１
491	ああ
492	かあ
493	さあ
494	SELECT * FROM `Ｔ１１a` LEFT JOIN `Ｔ１１b` USING (`Ｃ１`);
495	Ｃ１Ｃ１
496	ああ
497	か NULL
498	さ NULL
499	SELECT * FROM `Ｔ１１a` LEFT JOIN `Ｔ１１b` ON (`Ｔ１１a`.`Ｃ１` = `Ｔ１１b`.`Ｃ１`);
500	Ｃ１Ｃ１
501	ああ
502	か NULL
503	さ NULL
504	SELECT * FROM `Ｔ１１b` RIGHT JOIN `Ｔ１１a` USING (`Ｃ１`);
505	Ｃ１Ｃ１
506	ああ
507	NULL か
508	NULL さ
509	SELECT * FROM `Ｔ１１b` RIGHT JOIN `Ｔ１１a` ON (`Ｔ１１a`.`Ｃ１` = `Ｔ１１b`.`Ｃ１`);
510	Ｃ１Ｃ１
511	ああ
512	NULL か
513	NULL さ
514	SELECT * FROM `Ｔ１２a` JOIN `Ｔ１２b`;
515	Ｃ１Ｃ１
516	龔龔
517	龖龔
518	龗龔
519	SELECT * FROM `Ｔ１２a` INNER JOIN `Ｔ１２b`;
520	Ｃ１Ｃ１
521	龔龔
522	龖龔
523	龗龔
524	SELECT * FROM `Ｔ１２a` JOIN `Ｔ１２b` USING (`Ｃ１`);
525	Ｃ１Ｃ１
526	龔龔
527	SELECT * FROM `Ｔ１２a` INNER JOIN `Ｔ１２b` USING (`Ｃ１`);
528	Ｃ１Ｃ１
529	龔龔
530	SELECT * FROM `Ｔ１２a` CROSS JOIN `Ｔ１２b`;
531	Ｃ１Ｃ１
532	龔龔
533	龖龔
534	龗龔
535	SELECT * FROM `Ｔ１２a` LEFT JOIN `Ｔ１２b` USING (`Ｃ１`);
536	Ｃ１Ｃ１
537	龔龔
538	龖 NULL
539	龗 NULL
540	SELECT * FROM `Ｔ１２a` LEFT JOIN `Ｔ１２b` ON (`Ｔ１２a`.`Ｃ１` = `Ｔ１２b`.`Ｃ１`);
541	Ｃ１Ｃ１
542	龔龔
543	龖 NULL
544	龗 NULL
545	SELECT * FROM `Ｔ１２b` RIGHT JOIN `Ｔ１２a` USING (`Ｃ１`);
546	Ｃ１Ｃ１
547	龔龔
548	NULL 龖
549	NULL 龗
550	SELECT * FROM `Ｔ１２b` RIGHT JOIN `Ｔ１２a` ON (`Ｔ１２a`.`Ｃ１` = `Ｔ１２b`.`Ｃ１`);
551	Ｃ１Ｃ１
552	龔龔
553	NULL 龖
554	NULL 龗
555	DROP TABLE `Ｔ１a`;
556	DROP TABLE `Ｔ１b`;
557	DROP TABLE `Ｔ２a`;
558	DROP TABLE `Ｔ２b`;
559	DROP TABLE `Ｔ３a`;
560	DROP TABLE `Ｔ３b`;
561	DROP TABLE `Ｔ４a`;
562	DROP TABLE `Ｔ４b`;
563	DROP TABLE `Ｔ５a`;
564	DROP TABLE `Ｔ５b`;
565	DROP TABLE `Ｔ６a`;
566	DROP TABLE `Ｔ６b`;
567	DROP TABLE `Ｔ７a`;
568	DROP TABLE `Ｔ７b`;
569	DROP TABLE `Ｔ８a`;
570	DROP TABLE `Ｔ８b`;
571	DROP TABLE `Ｔ９a`;
572	DROP TABLE `Ｔ９b`;
573	DROP TABLE `Ｔ１０a`;
574	DROP TABLE `Ｔ１０b`;
575	DROP TABLE `Ｔ１１a`;
576	DROP TABLE `Ｔ１１b`;
577	DROP TABLE `Ｔ１２a`;
578	DROP TABLE `Ｔ１２b`;