1 files changed, 138 insertions, 273 deletions

diff --git a/mysql-test/suite/jp/r/jp_join_ujis.result b/mysql-test/suite/jp/r/jp_join_ujis.result
index ac430cd9b5e..13de9dae9ca 100644
--- a/mysql-test/suite/jp/r/jp_join_ujis.result
+++ b/mysql-test/suite/jp/r/jp_join_ujis.result
@@ -1,15 +1,21 @@
-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 `｣ﾔ｣ｱ｣ｲ`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｱa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｱb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｲa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｲb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｳa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｳb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｴa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｴb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｵa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｵb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｶa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｶb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｷa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｷb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｸa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｸb`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｹa`;
+DROP TABLE IF EXISTS `｣ﾔ｣ｹb`;
 SET NAMES ujis;
 SET character_set_database = ujis;
 CREATE TABLE `｣ﾔ｣ｱa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
@@ -18,24 +24,18 @@ CREATE TABLE `｣ﾔ｣ｲa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine
 CREATE TABLE `｣ﾔ｣ｲb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
 CREATE TABLE `｣ﾔ｣ｳa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
 CREATE TABLE `｣ﾔ｣ｳb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｴa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｴb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｵa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｵb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｶa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｶb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｷa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｷb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｸa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｸb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｹa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｹb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｰa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｰb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｱa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｱb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｲa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
-CREATE TABLE `｣ﾔ｣ｱ｣ｲb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｴa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｴb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｵa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｵb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｶa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｶb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｷa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
+CREATE TABLE `｣ﾔ｣ｷb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
+CREATE TABLE `｣ﾔ｣ｸa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
+CREATE TABLE `｣ﾔ｣ｸb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
+CREATE TABLE `｣ﾔ｣ｹa` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
+CREATE TABLE `｣ﾔ｣ｹb` (`｣ﾃ｣ｱ` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = memory;
 INSERT INTO `｣ﾔ｣ｱa` VALUES ('竺'),('叱'),('悉');
 INSERT INTO `｣ﾔ｣ｱb` VALUES ('竺');
 INSERT INTO `｣ﾔ｣ｲa` VALUES ('､｢'),('､ｫ'),('､ｵ');
@@ -54,12 +54,6 @@ 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`;
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 竺	竺
@@ -71,31 +65,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 竺	竺
@@ -112,31 +106,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 ､｢	､｢
@@ -153,31 +147,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 常ﾜ	常ﾜ
@@ -194,31 +188,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 竺	竺
@@ -235,31 +229,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 ､｢	､｢
@@ -276,31 +270,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 常ﾜ	常ﾜ
@@ -317,31 +311,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 竺	竺
@@ -358,31 +352,31 @@ 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`.`｣ﾃ｣ｱ`);
 ｣ﾃ｣ｱ	｣ﾃ｣ｱ
 ､｢	､｢
@@ -399,159 +393,36 @@ 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`;
@@ -570,9 +441,3 @@ 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`;