diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_join_utf8.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_join_utf8.test | 119 |
1 files changed, 40 insertions, 79 deletions
diff --git a/mysql-test/suite/jp/t/jp_join_utf8.test b/mysql-test/suite/jp/t/jp_join_utf8.test index 0b2f033f8bb..d4e25691866 100644 --- a/mysql-test/suite/jp/t/jp_join_utf8.test +++ b/mysql-test/suite/jp/t/jp_join_utf8.test @@ -1,16 +1,24 @@ +--source include/have_utf8.inc +--source include/have_innodb.inc --disable_warnings -drop table if exists `T1`; -drop table if exists `T2`; -drop table if exists `T3`; -drop table if exists `T4`; -drop table if exists `T5`; -drop table if exists `T6`; -drop table if exists `T7`; -drop table if exists `T8`; -drop table if exists `T9`; -drop table if exists `T10`; -drop table if exists `T11`; -drop table if exists `T12`; +drop table if exists `T1a`; +drop table if exists `T1b`; +drop table if exists `T2a`; +drop table if exists `T2b`; +drop table if exists `T3a`; +drop table if exists `T3b`; +drop table if exists `T4a`; +drop table if exists `T4b`; +drop table if exists `T5a`; +drop table if exists `T5b`; +drop table if exists `T6a`; +drop table if exists `T6b`; +drop table if exists `T7a`; +drop table if exists `T7b`; +drop table if exists `T8a`; +drop table if exists `T8b`; +drop table if exists `T9a`; +drop table if exists `T9b`; --enable_warnings # @@ -20,30 +28,24 @@ drop table if exists `T12`; SET NAMES utf8; SET character_set_database = utf8; -CREATE TABLE `T1a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T1b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T2a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T2b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T3a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T3b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T4a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T4b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T5a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T5b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T6a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T6b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T7a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T7b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T8a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T8b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T9a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T9b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T10a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T10b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T11a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T11b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T12a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; -CREATE TABLE `T12b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = innodb; +CREATE TABLE `T1a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T1b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T2a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T2b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T3a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T3b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = InnoDB; +CREATE TABLE `T4a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T4b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T5a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T5b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T6a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T6b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MyISAM; +CREATE TABLE `T7a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T7b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T8a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T8b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T9a` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T9b` (`C1` char(1) PRIMARY KEY) DEFAULT CHARSET = utf8 engine = MEMORY; #insert the following data in each table # jisx0201 hankaku-katakana data @@ -68,14 +70,8 @@ INSERT INTO `T8a` VALUES ('あ'),('か'),('さ'); INSERT INTO `T8b` VALUES ('あ'); INSERT INTO `T9a` VALUES ('龔'),('龖'),('龗'); INSERT INTO `T9b` VALUES ('龔'); -INSERT INTO `T10a` VALUES ('ア'),('カ'),('サ'); -INSERT INTO `T10b` VALUES ('ア'); -INSERT INTO `T11a` VALUES ('あ'),('か'),('さ'); -INSERT INTO `T11b` VALUES ('あ'); -INSERT INTO `T12a` VALUES ('龔'),('龖'),('龗'); -INSERT INTO `T12b` VALUES ('龔'); -#Test for innodb +#Test for InnoDB SELECT * FROM `T1a` JOIN `T1b`; SELECT * FROM `T1a` INNER JOIN `T1b`; SELECT * FROM `T1a` JOIN `T1b` USING (`C1`); @@ -133,7 +129,7 @@ SELECT * FROM `T6a` LEFT JOIN `T6b` ON (`T6a`.`C1` = `T6b`.` SELECT * FROM `T6b` RIGHT JOIN `T6a` USING (`C1`); SELECT * FROM `T6b` RIGHT JOIN `T6a` ON (`T6a`.`C1` = `T6b`.`C1`); -#Test for heap +#Test for MEMORY SELECT * FROM `T7a` JOIN `T7b`; SELECT * FROM `T7a` INNER JOIN `T7b`; SELECT * FROM `T7a` JOIN `T7b` USING (`C1`); @@ -162,35 +158,6 @@ SELECT * FROM `T9a` LEFT JOIN `T9b` ON (`T9a`.`C1` = `T9b`.` SELECT * FROM `T9b` RIGHT JOIN `T9a` USING (`C1`); SELECT * FROM `T9b` RIGHT JOIN `T9a` ON (`T9a`.`C1` = `T9b`.`C1`); -#Test for heap -SELECT * FROM `T10a` JOIN `T10b`; -SELECT * FROM `T10a` INNER JOIN `T10b`; -SELECT * FROM `T10a` JOIN `T10b` USING (`C1`); -SELECT * FROM `T10a` INNER JOIN `T10b` USING (`C1`); -SELECT * FROM `T10a` CROSS JOIN `T10b`; -SELECT * FROM `T10a` LEFT JOIN `T10b` USING (`C1`); -SELECT * FROM `T10a` LEFT JOIN `T10b` ON (`T10a`.`C1` = `T10b`.`C1`); -SELECT * FROM `T10b` RIGHT JOIN `T10a` USING (`C1`); -SELECT * FROM `T10b` RIGHT JOIN `T10a` ON (`T10a`.`C1` = `T10b`.`C1`); -SELECT * FROM `T11a` JOIN `T11b`; -SELECT * FROM `T11a` INNER JOIN `T11b`; -SELECT * FROM `T11a` JOIN `T11b` USING (`C1`); -SELECT * FROM `T11a` INNER JOIN `T11b` USING (`C1`); -SELECT * FROM `T11a` CROSS JOIN `T11b`; -SELECT * FROM `T11a` LEFT JOIN `T11b` USING (`C1`); -SELECT * FROM `T11a` LEFT JOIN `T11b` ON (`T11a`.`C1` = `T11b`.`C1`); -SELECT * FROM `T11b` RIGHT JOIN `T11a` USING (`C1`); -SELECT * FROM `T11b` RIGHT JOIN `T11a` ON (`T11a`.`C1` = `T11b`.`C1`); -SELECT * FROM `T12a` JOIN `T12b`; -SELECT * FROM `T12a` INNER JOIN `T12b`; -SELECT * FROM `T12a` JOIN `T12b` USING (`C1`); -SELECT * FROM `T12a` INNER JOIN `T12b` USING (`C1`); -SELECT * FROM `T12a` CROSS JOIN `T12b`; -SELECT * FROM `T12a` LEFT JOIN `T12b` USING (`C1`); -SELECT * FROM `T12a` LEFT JOIN `T12b` ON (`T12a`.`C1` = `T12b`.`C1`); -SELECT * FROM `T12b` RIGHT JOIN `T12a` USING (`C1`); -SELECT * FROM `T12b` RIGHT JOIN `T12a` ON (`T12a`.`C1` = `T12b`.`C1`); - DROP TABLE `T1a`; DROP TABLE `T1b`; DROP TABLE `T2a`; @@ -209,9 +176,3 @@ DROP TABLE `T8a`; DROP TABLE `T8b`; DROP TABLE `T9a`; DROP TABLE `T9b`; -DROP TABLE `T10a`; -DROP TABLE `T10b`; -DROP TABLE `T11a`; -DROP TABLE `T11b`; -DROP TABLE `T12a`; -DROP TABLE `T12b`; |