1--character_set sjis 2--disable_warnings 3DROP TABLE IF EXISTS `�s�Pa`; 4DROP TABLE IF EXISTS `�s�Pb`; 5DROP TABLE IF EXISTS `�s�Qa`; 6DROP TABLE IF EXISTS `�s�Qb`; 7DROP TABLE IF EXISTS `�s�Ra`; 8DROP TABLE IF EXISTS `�s�Rb`; 9DROP TABLE IF EXISTS `�s�Sa`; 10DROP TABLE IF EXISTS `�s�Sb`; 11DROP TABLE IF EXISTS `�s�Ta`; 12DROP TABLE IF EXISTS `�s�Tb`; 13DROP TABLE IF EXISTS `�s�Ua`; 14DROP TABLE IF EXISTS `�s�Ub`; 15DROP TABLE IF EXISTS `�s�Va`; 16DROP TABLE IF EXISTS `�s�Vb`; 17DROP TABLE IF EXISTS `�s�Wa`; 18DROP TABLE IF EXISTS `�s�Wb`; 19DROP TABLE IF EXISTS `�s�Xa`; 20DROP TABLE IF EXISTS `�s�Xb`; 21--enable_warnings 22 23# 24# Test table JOIN using Japanese characters in sjis encoding 25# 26 27SET NAMES sjis; 28SET character_set_database = sjis; 29 30CREATE TABLE `�s�Pa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 31CREATE TABLE `�s�Pb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 32CREATE TABLE `�s�Qa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 33CREATE TABLE `�s�Qb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 34CREATE TABLE `�s�Ra` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 35CREATE TABLE `�s�Rb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; 36CREATE TABLE `�s�Sa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 37CREATE TABLE `�s�Sb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 38CREATE TABLE `�s�Ta` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 39CREATE TABLE `�s�Tb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 40CREATE TABLE `�s�Ua` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 41CREATE TABLE `�s�Ub` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; 42CREATE TABLE `�s�Va` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 43CREATE TABLE `�s�Vb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 44CREATE TABLE `�s�Wa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 45CREATE TABLE `�s�Wb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 46CREATE TABLE `�s�Xa` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 47CREATE TABLE `�s�Xb` (`�b�P` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; 48 49#insert the following data in each table 50# jisx0201 hankaku-katakana data 51# jisx0208 data 52# jisx0212 supplemental character data 53 54INSERT INTO `�s�Pa` VALUES ('�'),('�'),('�'); 55INSERT INTO `�s�Pb` VALUES ('�'); 56INSERT INTO `�s�Qa` VALUES ('��'),('��'),('��'); 57INSERT INTO `�s�Qb` VALUES ('��'); 58INSERT INTO `�s�Ra` VALUES ('�\'),('�\'),('�\'); 59INSERT INTO `�s�Rb` VALUES ('�\'); 60INSERT INTO `�s�Sa` VALUES ('�'),('�'),('�'); 61INSERT INTO `�s�Sb` VALUES ('�'); 62INSERT INTO `�s�Ta` VALUES ('��'),('��'),('��'); 63INSERT INTO `�s�Tb` VALUES ('��'); 64INSERT INTO `�s�Ua` VALUES ('�\'),('�\'),('�\'); 65INSERT INTO `�s�Ub` VALUES ('�\'); 66INSERT INTO `�s�Va` VALUES ('�'),('�'),('�'); 67INSERT INTO `�s�Vb` VALUES ('�'); 68INSERT INTO `�s�Wa` VALUES ('��'),('��'),('��'); 69INSERT INTO `�s�Wb` VALUES ('��'); 70INSERT INTO `�s�Xa` VALUES ('�\'),('�\'),('�\'); 71INSERT INTO `�s�Xb` VALUES ('�\'); 72 73#Test for innodb 74SELECT * FROM `�s�Pa` JOIN `�s�Pb`; 75SELECT * FROM `�s�Pa` INNER JOIN `�s�Pb`; 76SELECT * FROM `�s�Pa` JOIN `�s�Pb` USING (`�b�P`); 77SELECT * FROM `�s�Pa` INNER JOIN `�s�Pb` USING (`�b�P`); 78SELECT * FROM `�s�Pa` CROSS JOIN `�s�Pb`; 79SELECT * FROM `�s�Pa` LEFT JOIN `�s�Pb` USING (`�b�P`); 80SELECT * FROM `�s�Pa` LEFT JOIN `�s�Pb` ON (`�s�Pa`.`�b�P` = `�s�Pb`.`�b�P`); 81SELECT * FROM `�s�Pb` RIGHT JOIN `�s�Pa` USING (`�b�P`); 82SELECT * FROM `�s�Pb` RIGHT JOIN `�s�Pa` ON (`�s�Pa`.`�b�P` = `�s�Pb`.`�b�P`); 83SELECT * FROM `�s�Qa` JOIN `�s�Qb`; 84SELECT * FROM `�s�Qa` INNER JOIN `�s�Qb`; 85SELECT * FROM `�s�Qa` JOIN `�s�Qb` USING (`�b�P`); 86SELECT * FROM `�s�Qa` INNER JOIN `�s�Qb` USING (`�b�P`); 87SELECT * FROM `�s�Qa` CROSS JOIN `�s�Qb`; 88SELECT * FROM `�s�Qa` LEFT JOIN `�s�Qb` USING (`�b�P`); 89SELECT * FROM `�s�Qa` LEFT JOIN `�s�Qb` ON (`�s�Qa`.`�b�P` = `�s�Qb`.`�b�P`); 90SELECT * FROM `�s�Qb` RIGHT JOIN `�s�Qa` USING (`�b�P`); 91SELECT * FROM `�s�Qb` RIGHT JOIN `�s�Qa` ON (`�s�Qa`.`�b�P` = `�s�Qb`.`�b�P`); 92SELECT * FROM `�s�Ra` JOIN `�s�Rb`; 93SELECT * FROM `�s�Ra` INNER JOIN `�s�Rb`; 94SELECT * FROM `�s�Ra` JOIN `�s�Rb` USING (`�b�P`); 95SELECT * FROM `�s�Ra` INNER JOIN `�s�Rb` USING (`�b�P`); 96SELECT * FROM `�s�Ra` CROSS JOIN `�s�Rb`; 97SELECT * FROM `�s�Ra` LEFT JOIN `�s�Rb` USING (`�b�P`); 98SELECT * FROM `�s�Ra` LEFT JOIN `�s�Rb` ON (`�s�Ra`.`�b�P` = `�s�Rb`.`�b�P`); 99SELECT * FROM `�s�Rb` RIGHT JOIN `�s�Ra` USING (`�b�P`); 100SELECT * FROM `�s�Rb` RIGHT JOIN `�s�Ra` ON (`�s�Ra`.`�b�P` = `�s�Rb`.`�b�P`); 101 102#Test for myisam 103SELECT * FROM `�s�Sa` JOIN `�s�Sb`; 104SELECT * FROM `�s�Sa` INNER JOIN `�s�Sb`; 105SELECT * FROM `�s�Sa` JOIN `�s�Sb` USING (`�b�P`); 106SELECT * FROM `�s�Sa` INNER JOIN `�s�Sb` USING (`�b�P`); 107SELECT * FROM `�s�Sa` CROSS JOIN `�s�Sb`; 108SELECT * FROM `�s�Sa` LEFT JOIN `�s�Sb` USING (`�b�P`); 109SELECT * FROM `�s�Sa` LEFT JOIN `�s�Sb` ON (`�s�Sa`.`�b�P` = `�s�Sb`.`�b�P`); 110SELECT * FROM `�s�Sb` RIGHT JOIN `�s�Sa` USING (`�b�P`); 111SELECT * FROM `�s�Sb` RIGHT JOIN `�s�Sa` ON (`�s�Sa`.`�b�P` = `�s�Sb`.`�b�P`); 112SELECT * FROM `�s�Ta` JOIN `�s�Tb`; 113SELECT * FROM `�s�Ta` INNER JOIN `�s�Tb`; 114SELECT * FROM `�s�Ta` JOIN `�s�Tb` USING (`�b�P`); 115SELECT * FROM `�s�Ta` INNER JOIN `�s�Tb` USING (`�b�P`); 116SELECT * FROM `�s�Ta` CROSS JOIN `�s�Tb`; 117SELECT * FROM `�s�Ta` LEFT JOIN `�s�Tb` USING (`�b�P`); 118SELECT * FROM `�s�Ta` LEFT JOIN `�s�Tb` ON (`�s�Ta`.`�b�P` = `�s�Tb`.`�b�P`); 119SELECT * FROM `�s�Tb` RIGHT JOIN `�s�Ta` USING (`�b�P`); 120SELECT * FROM `�s�Tb` RIGHT JOIN `�s�Ta` ON (`�s�Ta`.`�b�P` = `�s�Tb`.`�b�P`); 121SELECT * FROM `�s�Ua` JOIN `�s�Ub`; 122SELECT * FROM `�s�Ua` INNER JOIN `�s�Ub`; 123SELECT * FROM `�s�Ua` JOIN `�s�Ub` USING (`�b�P`); 124SELECT * FROM `�s�Ua` INNER JOIN `�s�Ub` USING (`�b�P`); 125SELECT * FROM `�s�Ua` CROSS JOIN `�s�Ub`; 126SELECT * FROM `�s�Ua` LEFT JOIN `�s�Ub` USING (`�b�P`); 127SELECT * FROM `�s�Ua` LEFT JOIN `�s�Ub` ON (`�s�Ua`.`�b�P` = `�s�Ub`.`�b�P`); 128SELECT * FROM `�s�Ub` RIGHT JOIN `�s�Ua` USING (`�b�P`); 129SELECT * FROM `�s�Ub` RIGHT JOIN `�s�Ua` ON (`�s�Ua`.`�b�P` = `�s�Ub`.`�b�P`); 130 131#Test for MEMORY 132SELECT * FROM `�s�Va` JOIN `�s�Vb`; 133SELECT * FROM `�s�Va` INNER JOIN `�s�Vb`; 134SELECT * FROM `�s�Va` JOIN `�s�Vb` USING (`�b�P`); 135SELECT * FROM `�s�Va` INNER JOIN `�s�Vb` USING (`�b�P`); 136SELECT * FROM `�s�Va` CROSS JOIN `�s�Vb`; 137SELECT * FROM `�s�Va` LEFT JOIN `�s�Vb` USING (`�b�P`); 138SELECT * FROM `�s�Va` LEFT JOIN `�s�Vb` ON (`�s�Va`.`�b�P` = `�s�Vb`.`�b�P`); 139SELECT * FROM `�s�Vb` RIGHT JOIN `�s�Va` USING (`�b�P`); 140SELECT * FROM `�s�Vb` RIGHT JOIN `�s�Va` ON (`�s�Va`.`�b�P` = `�s�Vb`.`�b�P`); 141SELECT * FROM `�s�Wa` JOIN `�s�Wb`; 142SELECT * FROM `�s�Wa` INNER JOIN `�s�Wb`; 143SELECT * FROM `�s�Wa` JOIN `�s�Wb` USING (`�b�P`); 144SELECT * FROM `�s�Wa` INNER JOIN `�s�Wb` USING (`�b�P`); 145SELECT * FROM `�s�Wa` CROSS JOIN `�s�Wb`; 146SELECT * FROM `�s�Wa` LEFT JOIN `�s�Wb` USING (`�b�P`); 147SELECT * FROM `�s�Wa` LEFT JOIN `�s�Wb` ON (`�s�Wa`.`�b�P` = `�s�Wb`.`�b�P`); 148SELECT * FROM `�s�Wb` RIGHT JOIN `�s�Wa` USING (`�b�P`); 149SELECT * FROM `�s�Wb` RIGHT JOIN `�s�Wa` ON (`�s�Wa`.`�b�P` = `�s�Wb`.`�b�P`); 150SELECT * FROM `�s�Xa` JOIN `�s�Xb`; 151SELECT * FROM `�s�Xa` INNER JOIN `�s�Xb`; 152SELECT * FROM `�s�Xa` JOIN `�s�Xb` USING (`�b�P`); 153SELECT * FROM `�s�Xa` INNER JOIN `�s�Xb` USING (`�b�P`); 154SELECT * FROM `�s�Xa` CROSS JOIN `�s�Xb`; 155SELECT * FROM `�s�Xa` LEFT JOIN `�s�Xb` USING (`�b�P`); 156SELECT * FROM `�s�Xa` LEFT JOIN `�s�Xb` ON (`�s�Xa`.`�b�P` = `�s�Xb`.`�b�P`); 157SELECT * FROM `�s�Xb` RIGHT JOIN `�s�Xa` USING (`�b�P`); 158SELECT * FROM `�s�Xb` RIGHT JOIN `�s�Xa` ON (`�s�Xa`.`�b�P` = `�s�Xb`.`�b�P`); 159 160DROP TABLE `�s�Pa`; 161DROP TABLE `�s�Pb`; 162DROP TABLE `�s�Qa`; 163DROP TABLE `�s�Qb`; 164DROP TABLE `�s�Ra`; 165DROP TABLE `�s�Rb`; 166DROP TABLE `�s�Sa`; 167DROP TABLE `�s�Sb`; 168DROP TABLE `�s�Ta`; 169DROP TABLE `�s�Tb`; 170DROP TABLE `�s�Ua`; 171DROP TABLE `�s�Ub`; 172DROP TABLE `�s�Va`; 173DROP TABLE `�s�Vb`; 174DROP TABLE `�s�Wa`; 175DROP TABLE `�s�Wb`; 176DROP TABLE `�s�Xa`; 177DROP TABLE `�s�Xb`; 178