diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_subquery_sjis.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_subquery_sjis.test | 44 |
1 files changed, 8 insertions, 36 deletions
diff --git a/mysql-test/suite/jp/t/jp_subquery_sjis.test b/mysql-test/suite/jp/t/jp_subquery_sjis.test index 5292c7a2519..aaaa71b0d39 100644 --- a/mysql-test/suite/jp/t/jp_subquery_sjis.test +++ b/mysql-test/suite/jp/t/jp_subquery_sjis.test @@ -1,3 +1,5 @@ +--source include/have_sjis.inc +--source include/have_innodb.inc --character_set sjis --disable_warnings drop table if exists `sP`; @@ -9,9 +11,6 @@ drop table if exists `sU`; drop table if exists `sV`; drop table if exists `sW`; drop table if exists `sX`; -drop table if exists `sPO`; -drop table if exists `sPP`; -drop table if exists `sPQ`; --enable_warnings # @@ -33,18 +32,12 @@ CREATE TABLE `sTa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine CREATE TABLE `sTb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; -CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPOa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPOb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPPb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPQa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPQb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; +CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; #insert the following data in each table # jisx0201 hankaku-katakana data @@ -69,12 +62,6 @@ INSERT INTO `sWa` VALUES (''),(''),(''); INSERT INTO `sWb` VALUES (''); INSERT INTO `sXa` VALUES ('\'),('\'),('\'); INSERT INTO `sXb` VALUES ('\'); -INSERT INTO `sPOa` VALUES (''),(''),(''); -INSERT INTO `sPOb` VALUES (''); -INSERT INTO `sPPa` VALUES (''),(''),(''); -INSERT INTO `sPPb` VALUES (''); -INSERT INTO `sPQa` VALUES ('\'),('\'),('\'); -INSERT INTO `sPQb` VALUES ('\'); #Test for innodb SELECT `bP` FROM `sPa` WHERE `bP` IN (SELECT `bP` FROM `sPb`); @@ -104,15 +91,6 @@ SELECT `bP` FROM `sWa` WHERE NOT EXISTS (SELECT `bP` FROM `sWb` WHERE ` SELECT `bP` FROM `sXa` WHERE `bP` IN (SELECT `bP` FROM `sXb`); SELECT `bP` FROM `sXa` WHERE EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); SELECT `bP` FROM `sXa` WHERE NOT EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); -SELECT `bP` FROM `sPOa` WHERE `bP` IN (SELECT `bP` FROM `sPOb`); -SELECT `bP` FROM `sPOa` WHERE EXISTS (SELECT `bP` FROM `sPOb` WHERE `sPOa`.`bP` = `sPOb`.`bP`); -SELECT `bP` FROM `sPOa` WHERE NOT EXISTS (SELECT `bP` FROM `sPOb` WHERE `sPOa`.`bP` = `sPOb`.`bP`); -SELECT `bP` FROM `sPPa` WHERE `bP` IN (SELECT `bP` FROM `sPPb`); -SELECT `bP` FROM `sPPa` WHERE EXISTS (SELECT `bP` FROM `sPPb` WHERE `sPPa`.`bP` = `sPPb`.`bP`); -SELECT `bP` FROM `sPPa` WHERE NOT EXISTS (SELECT `bP` FROM `sPPb` WHERE `sPPa`.`bP` = `sPPb`.`bP`); -SELECT `bP` FROM `sPQa` WHERE `bP` IN (SELECT `bP` FROM `sPQb`); -SELECT `bP` FROM `sPQa` WHERE EXISTS (SELECT `bP` FROM `sPQb` WHERE `sPQa`.`bP` = `sPQb`.`bP`); -SELECT `bP` FROM `sPQa` WHERE NOT EXISTS (SELECT `bP` FROM `sPQb` WHERE `sPQa`.`bP` = `sPQb`.`bP`); DROP TABLE `sPa`; DROP TABLE `sPb`; @@ -132,9 +110,3 @@ DROP TABLE `sWa`; DROP TABLE `sWb`; DROP TABLE `sXa`; DROP TABLE `sXb`; -DROP TABLE `sPOa`; -DROP TABLE `sPOb`; -DROP TABLE `sPPa`; -DROP TABLE `sPPb`; -DROP TABLE `sPQa`; -DROP TABLE `sPQb`; |