diff options
author | unknown <shuichi@mysql.com> | 2005-01-07 00:40:29 -0800 |
---|---|---|
committer | unknown <shuichi@mysql.com> | 2005-01-07 00:40:29 -0800 |
commit | 187ff7c6fcae8d37e6a9ca8c9d5e0d1f7f4a167b (patch) | |
tree | 851937fa66ea5d237f59a554ba3ce6d15f229e80 /mysql-test/suite/jp | |
parent | 647906259c457314eb8cedb2e336aeda1b2a0ada (diff) | |
download | mariadb-git-187ff7c6fcae8d37e6a9ca8c9d5e0d1f7f4a167b.tar.gz |
Added test case files
Diffstat (limited to 'mysql-test/suite/jp')
-rwxr-xr-x | mysql-test/suite/jp/t/jp_subquery_ucs2.test | 143 |
1 files changed, 143 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/t/jp_subquery_ucs2.test b/mysql-test/suite/jp/t/jp_subquery_ucs2.test new file mode 100755 index 00000000000..311433438f4 --- /dev/null +++ b/mysql-test/suite/jp/t/jp_subquery_ucs2.test @@ -0,0 +1,143 @@ +--source include/have_ucs2.inc + +--disable_warnings +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 `」ヤ」ア」イ`; +--enable_warnings + +# +# Test subquery using Japanese characters in ucs2 encoding +# + +SET NAMES ujis; +SET character_set_database = ucs2; +SET collation_connection = ucs2_general_ci; + +CREATE TABLE `」ヤ」アa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」アb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」イa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」イb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」ウa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」ウb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `」ヤ」エa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」エb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」オa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」オb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」カa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」カb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `」ヤ」キa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」キb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」クa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」クb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ケa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ケb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」ーa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」ーb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」アa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」アb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」イa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; +CREATE TABLE `」ヤ」ア」イb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = heap; + +#insert the following data in each table +# jisx0201 hankaku-katakana data +# jisx0208 data +# jisx0212 supplemental character data + +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 ('常ワ'); + +#Test for innodb +SELECT `」テ」ア` FROM `」ヤ」アa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」アb`); +SELECT `」テ」ア` FROM `」ヤ」アa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」アb` WHERE `」ヤ」アa`.`」テ」ア` = `」ヤ」アb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」アa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」アb` WHERE `」ヤ」アa`.`」テ」ア` = `」ヤ」アb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」イa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」イb`); +SELECT `」テ」ア` FROM `」ヤ」イa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」イb` WHERE `」ヤ」イa`.`」テ」ア` = `」ヤ」イb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」イa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」イb` WHERE `」ヤ」イa`.`」テ」ア` = `」ヤ」イb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ウa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」ウb`); +SELECT `」テ」ア` FROM `」ヤ」ウa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」ウb` WHERE `」ヤ」ウa`.`」テ」ア` = `」ヤ」ウb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ウa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ウb` WHERE `」ヤ」ウa`.`」テ」ア` = `」ヤ」ウb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」エa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」エb`); +SELECT `」テ」ア` FROM `」ヤ」エa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」エb` WHERE `」ヤ」エa`.`」テ」ア` = `」ヤ」エb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」エa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」エb` WHERE `」ヤ」エa`.`」テ」ア` = `」ヤ」エb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」オa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」オb`); +SELECT `」テ」ア` FROM `」ヤ」オa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」オb` WHERE `」ヤ」オa`.`」テ」ア` = `」ヤ」オb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」オa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」オb` WHERE `」ヤ」オa`.`」テ」ア` = `」ヤ」オb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」カa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」カb`); +SELECT `」テ」ア` FROM `」ヤ」カa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」カb` WHERE `」ヤ」カa`.`」テ」ア` = `」ヤ」カb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」カa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」カb` WHERE `」ヤ」カa`.`」テ」ア` = `」ヤ」カb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」キa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」キb`); +SELECT `」テ」ア` FROM `」ヤ」キa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」キb` WHERE `」ヤ」キa`.`」テ」ア` = `」ヤ」キb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」キa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」キb` WHERE `」ヤ」キa`.`」テ」ア` = `」ヤ」キb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」クa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」クb`); +SELECT `」テ」ア` FROM `」ヤ」クa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」クb` WHERE `」ヤ」クa`.`」テ」ア` = `」ヤ」クb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」クa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」クb` WHERE `」ヤ」クa`.`」テ」ア` = `」ヤ」クb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ケa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」ケb`); +SELECT `」テ」ア` FROM `」ヤ」ケa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」ケb` WHERE `」ヤ」ケa`.`」テ」ア` = `」ヤ」ケb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ケa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ケb` WHERE `」ヤ」ケa`.`」テ」ア` = `」ヤ」ケb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」ーa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」ア」ーb`); +SELECT `」テ」ア` FROM `」ヤ」ア」ーa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」ーb` WHERE `」ヤ」ア」ーa`.`」テ」ア` = `」ヤ」ア」ーb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」ーa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」ーb` WHERE `」ヤ」ア」ーa`.`」テ」ア` = `」ヤ」ア」ーb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」アa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」ア」アb`); +SELECT `」テ」ア` FROM `」ヤ」ア」アa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」アb` WHERE `」ヤ」ア」アa`.`」テ」ア` = `」ヤ」ア」アb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」アa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」アb` WHERE `」ヤ」ア」アa`.`」テ」ア` = `」ヤ」ア」アb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」イa` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」ア」イb`); +SELECT `」テ」ア` FROM `」ヤ」ア」イa` WHERE EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」イb` WHERE `」ヤ」ア」イa`.`」テ」ア` = `」ヤ」ア」イb`.`」テ」ア`); +SELECT `」テ」ア` FROM `」ヤ」ア」イa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ア」イb` WHERE `」ヤ」ア」イa`.`」テ」ア` = `」ヤ」ア」イ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`; +DROP TABLE `」ヤ」ア」イa`; +DROP TABLE `」ヤ」ア」イb`; + |