summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/jp/r/jp_subquery_sjis.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/r/jp_subquery_sjis.result')
-rw-r--r--mysql-test/suite/jp/r/jp_subquery_sjis.result155
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`;