1--source include/have_utf8.inc 2--source include/have_innodb.inc 3--disable_warnings 4drop table if exists `Ｔ１a`; 5drop table if exists `Ｔ１b`; 6drop table if exists `Ｔ２a`; 7drop table if exists `Ｔ２b`; 8drop table if exists `Ｔ３a`; 9drop table if exists `Ｔ３b`; 10drop table if exists `Ｔ４a`; 11drop table if exists `Ｔ４b`; 12drop table if exists `Ｔ５a`; 13drop table if exists `Ｔ５b`; 14drop table if exists `Ｔ６a`; 15drop table if exists `Ｔ６b`; 16drop table if exists `Ｔ７a`; 17drop table if exists `Ｔ７b`; 18drop table if exists `Ｔ８a`; 19drop table if exists `Ｔ８b`; 20drop table if exists `Ｔ９a`; 21drop table if exists `Ｔ９b`; 22--enable_warnings 23 24# 25# Test table JOIN using Japanese characters in utf8 26# 27 28SET NAMES utf8; 29SET character_set_database = utf8; 30 31CREATE TABLE `Ｔ１a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 32CREATE TABLE `Ｔ１b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 33CREATE TABLE `Ｔ２a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 34CREATE TABLE `Ｔ２b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 35CREATE TABLE `Ｔ３a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 36CREATE TABLE `Ｔ３b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; 37CREATE TABLE `Ｔ４a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 38CREATE TABLE `Ｔ４b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 39CREATE TABLE `Ｔ５a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 40CREATE TABLE `Ｔ５b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 41CREATE TABLE `Ｔ６a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 42CREATE TABLE `Ｔ６b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; 43CREATE TABLE `Ｔ７a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 44CREATE TABLE `Ｔ７b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 45CREATE TABLE `Ｔ８a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 46CREATE TABLE `Ｔ８b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 47CREATE TABLE `Ｔ９a` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 48CREATE TABLE `Ｔ９b` (`Ｃ１` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; 49 50#insert the following data in each table 51# jisx0201 hankaku-katakana data 52# jisx0208 data 53# jisx0212 supplemental character data 54 55INSERT INTO `Ｔ１a` VALUES ('ｱ'),('ｶ'),('ｻ'); 56INSERT INTO `Ｔ１b` VALUES ('ｱ'); 57INSERT INTO `Ｔ２a` VALUES ('あ'),('か'),('さ'); 58INSERT INTO `Ｔ２b` VALUES ('あ'); 59INSERT INTO `Ｔ３a` VALUES ('龔'),('龖'),('龗'); 60INSERT INTO `Ｔ３b` VALUES ('龔'); 61INSERT INTO `Ｔ４a` VALUES ('ｱ'),('ｶ'),('ｻ'); 62INSERT INTO `Ｔ４b` VALUES ('ｱ'); 63INSERT INTO `Ｔ５a` VALUES ('あ'),('か'),('さ'); 64INSERT INTO `Ｔ５b` VALUES ('あ'); 65INSERT INTO `Ｔ６a` VALUES ('龔'),('龖'),('龗'); 66INSERT INTO `Ｔ６b` VALUES ('龔'); 67INSERT INTO `Ｔ７a` VALUES ('ｱ'),('ｶ'),('ｻ'); 68INSERT INTO `Ｔ７b` VALUES ('ｱ'); 69INSERT INTO `Ｔ８a` VALUES ('あ'),('か'),('さ'); 70INSERT INTO `Ｔ８b` VALUES ('あ'); 71INSERT INTO `Ｔ９a` VALUES ('龔'),('龖'),('龗'); 72INSERT INTO `Ｔ９b` VALUES ('龔'); 73 74#Test for InnoDB 75SELECT * FROM `Ｔ１a` JOIN `Ｔ１b`; 76SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b`; 77SELECT * FROM `Ｔ１a` JOIN `Ｔ１b` USING (`Ｃ１`); 78SELECT * FROM `Ｔ１a` INNER JOIN `Ｔ１b` USING (`Ｃ１`); 79SELECT * FROM `Ｔ１a` CROSS JOIN `Ｔ１b`; 80SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` USING (`Ｃ１`); 81SELECT * FROM `Ｔ１a` LEFT JOIN `Ｔ１b` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`); 82SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` USING (`Ｃ１`); 83SELECT * FROM `Ｔ１b` RIGHT JOIN `Ｔ１a` ON (`Ｔ１a`.`Ｃ１` = `Ｔ１b`.`Ｃ１`); 84SELECT * FROM `Ｔ２a` JOIN `Ｔ２b`; 85SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b`; 86SELECT * FROM `Ｔ２a` JOIN `Ｔ２b` USING (`Ｃ１`); 87SELECT * FROM `Ｔ２a` INNER JOIN `Ｔ２b` USING (`Ｃ１`); 88SELECT * FROM `Ｔ２a` CROSS JOIN `Ｔ２b`; 89SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` USING (`Ｃ１`); 90SELECT * FROM `Ｔ２a` LEFT JOIN `Ｔ２b` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`); 91SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` USING (`Ｃ１`); 92SELECT * FROM `Ｔ２b` RIGHT JOIN `Ｔ２a` ON (`Ｔ２a`.`Ｃ１` = `Ｔ２b`.`Ｃ１`); 93SELECT * FROM `Ｔ３a` JOIN `Ｔ３b`; 94SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b`; 95SELECT * FROM `Ｔ３a` JOIN `Ｔ３b` USING (`Ｃ１`); 96SELECT * FROM `Ｔ３a` INNER JOIN `Ｔ３b` USING (`Ｃ１`); 97SELECT * FROM `Ｔ３a` CROSS JOIN `Ｔ３b`; 98SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` USING (`Ｃ１`); 99SELECT * FROM `Ｔ３a` LEFT JOIN `Ｔ３b` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`); 100SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` USING (`Ｃ１`); 101SELECT * FROM `Ｔ３b` RIGHT JOIN `Ｔ３a` ON (`Ｔ３a`.`Ｃ１` = `Ｔ３b`.`Ｃ１`); 102 103#Test for myisam 104SELECT * FROM `Ｔ４a` JOIN `Ｔ４b`; 105SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b`; 106SELECT * FROM `Ｔ４a` JOIN `Ｔ４b` USING (`Ｃ１`); 107SELECT * FROM `Ｔ４a` INNER JOIN `Ｔ４b` USING (`Ｃ１`); 108SELECT * FROM `Ｔ４a` CROSS JOIN `Ｔ４b`; 109SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` USING (`Ｃ１`); 110SELECT * FROM `Ｔ４a` LEFT JOIN `Ｔ４b` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`); 111SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` USING (`Ｃ１`); 112SELECT * FROM `Ｔ４b` RIGHT JOIN `Ｔ４a` ON (`Ｔ４a`.`Ｃ１` = `Ｔ４b`.`Ｃ１`); 113SELECT * FROM `Ｔ５a` JOIN `Ｔ５b`; 114SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b`; 115SELECT * FROM `Ｔ５a` JOIN `Ｔ５b` USING (`Ｃ１`); 116SELECT * FROM `Ｔ５a` INNER JOIN `Ｔ５b` USING (`Ｃ１`); 117SELECT * FROM `Ｔ５a` CROSS JOIN `Ｔ５b`; 118SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` USING (`Ｃ１`); 119SELECT * FROM `Ｔ５a` LEFT JOIN `Ｔ５b` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`); 120SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` USING (`Ｃ１`); 121SELECT * FROM `Ｔ５b` RIGHT JOIN `Ｔ５a` ON (`Ｔ５a`.`Ｃ１` = `Ｔ５b`.`Ｃ１`); 122SELECT * FROM `Ｔ６a` JOIN `Ｔ６b`; 123SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b`; 124SELECT * FROM `Ｔ６a` JOIN `Ｔ６b` USING (`Ｃ１`); 125SELECT * FROM `Ｔ６a` INNER JOIN `Ｔ６b` USING (`Ｃ１`); 126SELECT * FROM `Ｔ６a` CROSS JOIN `Ｔ６b`; 127SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` USING (`Ｃ１`); 128SELECT * FROM `Ｔ６a` LEFT JOIN `Ｔ６b` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`); 129SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` USING (`Ｃ１`); 130SELECT * FROM `Ｔ６b` RIGHT JOIN `Ｔ６a` ON (`Ｔ６a`.`Ｃ１` = `Ｔ６b`.`Ｃ１`); 131 132#Test for MEMORY 133SELECT * FROM `Ｔ７a` JOIN `Ｔ７b`; 134SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b`; 135SELECT * FROM `Ｔ７a` JOIN `Ｔ７b` USING (`Ｃ１`); 136SELECT * FROM `Ｔ７a` INNER JOIN `Ｔ７b` USING (`Ｃ１`); 137SELECT * FROM `Ｔ７a` CROSS JOIN `Ｔ７b`; 138SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` USING (`Ｃ１`); 139SELECT * FROM `Ｔ７a` LEFT JOIN `Ｔ７b` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`); 140SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` USING (`Ｃ１`); 141SELECT * FROM `Ｔ７b` RIGHT JOIN `Ｔ７a` ON (`Ｔ７a`.`Ｃ１` = `Ｔ７b`.`Ｃ１`); 142SELECT * FROM `Ｔ８a` JOIN `Ｔ８b`; 143SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b`; 144SELECT * FROM `Ｔ８a` JOIN `Ｔ８b` USING (`Ｃ１`); 145SELECT * FROM `Ｔ８a` INNER JOIN `Ｔ８b` USING (`Ｃ１`); 146SELECT * FROM `Ｔ８a` CROSS JOIN `Ｔ８b`; 147SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` USING (`Ｃ１`); 148SELECT * FROM `Ｔ８a` LEFT JOIN `Ｔ８b` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`); 149SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` USING (`Ｃ１`); 150SELECT * FROM `Ｔ８b` RIGHT JOIN `Ｔ８a` ON (`Ｔ８a`.`Ｃ１` = `Ｔ８b`.`Ｃ１`); 151SELECT * FROM `Ｔ９a` JOIN `Ｔ９b`; 152SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b`; 153SELECT * FROM `Ｔ９a` JOIN `Ｔ９b` USING (`Ｃ１`); 154SELECT * FROM `Ｔ９a` INNER JOIN `Ｔ９b` USING (`Ｃ１`); 155SELECT * FROM `Ｔ９a` CROSS JOIN `Ｔ９b`; 156SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` USING (`Ｃ１`); 157SELECT * FROM `Ｔ９a` LEFT JOIN `Ｔ９b` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`); 158SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` USING (`Ｃ１`); 159SELECT * FROM `Ｔ９b` RIGHT JOIN `Ｔ９a` ON (`Ｔ９a`.`Ｃ１` = `Ｔ９b`.`Ｃ１`); 160 161DROP TABLE `Ｔ１a`; 162DROP TABLE `Ｔ１b`; 163DROP TABLE `Ｔ２a`; 164DROP TABLE `Ｔ２b`; 165DROP TABLE `Ｔ３a`; 166DROP TABLE `Ｔ３b`; 167DROP TABLE `Ｔ４a`; 168DROP TABLE `Ｔ４b`; 169DROP TABLE `Ｔ５a`; 170DROP TABLE `Ｔ５b`; 171DROP TABLE `Ｔ６a`; 172DROP TABLE `Ｔ６b`; 173DROP TABLE `Ｔ７a`; 174DROP TABLE `Ｔ７b`; 175DROP TABLE `Ｔ８a`; 176DROP TABLE `Ｔ８b`; 177DROP TABLE `Ｔ９a`; 178DROP TABLE `Ｔ９b`; 179