diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_subquery_ucs2.result')
-rw-r--r-- | mysql-test/suite/jp/r/jp_subquery_ucs2.result | 90 |
1 files changed, 24 insertions, 66 deletions
diff --git a/mysql-test/suite/jp/r/jp_subquery_ucs2.result b/mysql-test/suite/jp/r/jp_subquery_ucs2.result index 023100ecce3..1cafa1ae83b 100644 --- a/mysql-test/suite/jp/r/jp_subquery_ucs2.result +++ b/mysql-test/suite/jp/r/jp_subquery_ucs2.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 = ucs2; SET collation_connection = ucs2_general_ci; @@ -25,18 +31,12 @@ CREATE TABLE `」ヤ」オa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine 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; +CREATE TABLE `」ヤ」キa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `」ヤ」キb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `」ヤ」クa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `」ヤ」クb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `」ヤ」ケa` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `」ヤ」ケb` (`」テ」ア` char(1) PRIMARY KEY) DEFAULT CHARSET = ucs2 engine = MEMORY; INSERT INTO `」ヤ」アa` VALUES ('竺'),('叱'),('悉'); INSERT INTO `」ヤ」アb` VALUES ('竺'); INSERT INTO `」ヤ」イa` VALUES ('、「'),('、ォ'),('、オ'); @@ -55,12 +55,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` WHERE `」テ」ア` IN (SELECT `」テ」ア` FROM `」ヤ」アb`); 」テ」ア 竺 @@ -151,36 +145,6 @@ SELECT `」テ」ア` FROM `」ヤ」ケa` WHERE NOT EXISTS (SELECT `」テ」ア` FROM `」ヤ」ケb` WHERE `」 」テ」ア 常ン 常゙ -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`; @@ -199,9 +163,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`; |