diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_subquery_sjis.result')
-rw-r--r-- | mysql-test/suite/jp/r/jp_subquery_sjis.result | 155 |
1 files changed, 155 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_subquery_sjis.result b/mysql-test/suite/jp/r/jp_subquery_sjis.result new file mode 100644 index 00000000..d1dd688e --- /dev/null +++ b/mysql-test/suite/jp/r/jp_subquery_sjis.result @@ -0,0 +1,155 @@ +drop table if exists `sP`; +drop table if exists `sQ`; +drop table if exists `sR`; +drop table if exists `sS`; +drop table if exists `sT`; +drop table if exists `sU`; +drop table if exists `sV`; +drop table if exists `sW`; +drop table if exists `sX`; +SET NAMES sjis; +SET character_set_database = sjis; +CREATE TABLE `sPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sPb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sQa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sQb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sRa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sRb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sSa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; +CREATE TABLE `sSb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; +CREATE TABLE `sTa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; +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 = 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 INTO `sPa` VALUES (''),(''),(''); +INSERT INTO `sPb` VALUES (''); +INSERT INTO `sQa` VALUES (''),(''),(''); +INSERT INTO `sQb` VALUES (''); +INSERT INTO `sRa` VALUES ('\'),('\'),('\'); +INSERT INTO `sRb` VALUES ('\'); +INSERT INTO `sSa` VALUES (''),(''),(''); +INSERT INTO `sSb` VALUES (''); +INSERT INTO `sTa` VALUES (''),(''),(''); +INSERT INTO `sTb` VALUES (''); +INSERT INTO `sUa` VALUES ('\'),('\'),('\'); +INSERT INTO `sUb` VALUES ('\'); +INSERT INTO `sVa` VALUES (''),(''),(''); +INSERT INTO `sVb` VALUES (''); +INSERT INTO `sWa` VALUES (''),(''),(''); +INSERT INTO `sWb` VALUES (''); +INSERT INTO `sXa` VALUES ('\'),('\'),('\'); +INSERT INTO `sXb` VALUES ('\'); +SELECT `bP` FROM `sPa` WHERE `bP` IN (SELECT `bP` FROM `sPb`); +bP + +SELECT `bP` FROM `sPa` WHERE EXISTS (SELECT `bP` FROM `sPb` WHERE `sPa`.`bP` = `sPb`.`bP`); +bP + +SELECT `bP` FROM `sPa` WHERE NOT EXISTS (SELECT `bP` FROM `sPb` WHERE `sPa`.`bP` = `sPb`.`bP`); +bP + + +SELECT `bP` FROM `sQa` WHERE `bP` IN (SELECT `bP` FROM `sQb`); +bP + +SELECT `bP` FROM `sQa` WHERE EXISTS (SELECT `bP` FROM `sQb` WHERE `sQa`.`bP` = `sQb`.`bP`); +bP + +SELECT `bP` FROM `sQa` WHERE NOT EXISTS (SELECT `bP` FROM `sQb` WHERE `sQa`.`bP` = `sQb`.`bP`); +bP + + +SELECT `bP` FROM `sRa` WHERE `bP` IN (SELECT `bP` FROM `sRb`); +bP +\ +SELECT `bP` FROM `sRa` WHERE EXISTS (SELECT `bP` FROM `sRb` WHERE `sRa`.`bP` = `sRb`.`bP`); +bP +\ +SELECT `bP` FROM `sRa` WHERE NOT EXISTS (SELECT `bP` FROM `sRb` WHERE `sRa`.`bP` = `sRb`.`bP`); +bP +\ +\ +SELECT `bP` FROM `sSa` WHERE `bP` IN (SELECT `bP` FROM `sSb`); +bP + +SELECT `bP` FROM `sSa` WHERE EXISTS (SELECT `bP` FROM `sSb` WHERE `sSa`.`bP` = `sSb`.`bP`); +bP + +SELECT `bP` FROM `sSa` WHERE NOT EXISTS (SELECT `bP` FROM `sSb` WHERE `sSa`.`bP` = `sSb`.`bP`); +bP + + +SELECT `bP` FROM `sTa` WHERE `bP` IN (SELECT `bP` FROM `sTb`); +bP + +SELECT `bP` FROM `sTa` WHERE EXISTS (SELECT `bP` FROM `sTb` WHERE `sTa`.`bP` = `sTb`.`bP`); +bP + +SELECT `bP` FROM `sTa` WHERE NOT EXISTS (SELECT `bP` FROM `sTb` WHERE `sTa`.`bP` = `sTb`.`bP`); +bP + + +SELECT `bP` FROM `sUa` WHERE `bP` IN (SELECT `bP` FROM `sUb`); +bP +\ +SELECT `bP` FROM `sUa` WHERE EXISTS (SELECT `bP` FROM `sUb` WHERE `sUa`.`bP` = `sUb`.`bP`); +bP +\ +SELECT `bP` FROM `sUa` WHERE NOT EXISTS (SELECT `bP` FROM `sUb` WHERE `sUa`.`bP` = `sUb`.`bP`); +bP +\ +\ +SELECT `bP` FROM `sVa` WHERE `bP` IN (SELECT `bP` FROM `sVb`); +bP + +SELECT `bP` FROM `sVa` WHERE EXISTS (SELECT `bP` FROM `sVb` WHERE `sVa`.`bP` = `sVb`.`bP`); +bP + +SELECT `bP` FROM `sVa` WHERE NOT EXISTS (SELECT `bP` FROM `sVb` WHERE `sVa`.`bP` = `sVb`.`bP`); +bP + + +SELECT `bP` FROM `sWa` WHERE `bP` IN (SELECT `bP` FROM `sWb`); +bP + +SELECT `bP` FROM `sWa` WHERE EXISTS (SELECT `bP` FROM `sWb` WHERE `sWa`.`bP` = `sWb`.`bP`); +bP + +SELECT `bP` FROM `sWa` WHERE NOT EXISTS (SELECT `bP` FROM `sWb` WHERE `sWa`.`bP` = `sWb`.`bP`); +bP + + +SELECT `bP` FROM `sXa` WHERE `bP` IN (SELECT `bP` FROM `sXb`); +bP +\ +SELECT `bP` FROM `sXa` WHERE EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); +bP +\ +SELECT `bP` FROM `sXa` WHERE NOT EXISTS (SELECT `bP` FROM `sXb` WHERE `sXa`.`bP` = `sXb`.`bP`); +bP +\ +\ +DROP TABLE `sPa`; +DROP TABLE `sPb`; +DROP TABLE `sQa`; +DROP TABLE `sQb`; +DROP TABLE `sRa`; +DROP TABLE `sRb`; +DROP TABLE `sSa`; +DROP TABLE `sSb`; +DROP TABLE `sTa`; +DROP TABLE `sTb`; +DROP TABLE `sUa`; +DROP TABLE `sUb`; +DROP TABLE `sVa`; +DROP TABLE `sVb`; +DROP TABLE `sWa`; +DROP TABLE `sWb`; +DROP TABLE `sXa`; +DROP TABLE `sXb`; |