summaryrefslogtreecommitdiff
path: root/mysql-test/suite/jp/r/jp_join_sjis.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/r/jp_join_sjis.result')
-rwxr-xr-xmysql-test/suite/jp/r/jp_join_sjis.result578
1 files changed, 578 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/r/jp_join_sjis.result b/mysql-test/suite/jp/r/jp_join_sjis.result
new file mode 100755
index 00000000000..a5ccc58ae4c
--- /dev/null
+++ b/mysql-test/suite/jp/r/jp_join_sjis.result
@@ -0,0 +1,578 @@
+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`;
+drop table if exists `sPO`;
+drop table if exists `sPP`;
+drop table if exists `sPQ`;
+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 = 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;
+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 ('\');
+INSERT INTO `sPOa` VALUES (''),(''),('');
+INSERT INTO `sPOb` VALUES ('');
+INSERT INTO `sPPa` VALUES (''),(''),('');
+INSERT INTO `sPPb` VALUES ('');
+INSERT INTO `sPQa` VALUES ('\'),('\'),('\');
+INSERT INTO `sPQb` VALUES ('\');
+SELECT * FROM `sPa` JOIN `sPb`;
+bP bP
+
+
+
+SELECT * FROM `sPa` INNER JOIN `sPb`;
+bP bP
+
+
+
+SELECT * FROM `sPa` JOIN `sPb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPa` INNER JOIN `sPb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPa` CROSS JOIN `sPb`;
+bP bP
+
+
+
+SELECT * FROM `sPa` LEFT JOIN `sPb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPa` LEFT JOIN `sPb` ON (`sPa`.`bP` = `sPb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPb` RIGHT JOIN `sPa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sPb` RIGHT JOIN `sPa` ON (`sPa`.`bP` = `sPb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sQa` JOIN `sQb`;
+bP bP
+
+
+
+SELECT * FROM `sQa` INNER JOIN `sQb`;
+bP bP
+
+
+
+SELECT * FROM `sQa` JOIN `sQb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sQa` INNER JOIN `sQb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sQa` CROSS JOIN `sQb`;
+bP bP
+
+
+
+SELECT * FROM `sQa` LEFT JOIN `sQb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sQa` LEFT JOIN `sQb` ON (`sQa`.`bP` = `sQb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sQb` RIGHT JOIN `sQa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sQb` RIGHT JOIN `sQa` ON (`sQa`.`bP` = `sQb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sRa` JOIN `sRb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sRa` INNER JOIN `sRb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sRa` JOIN `sRb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sRa` INNER JOIN `sRb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sRa` CROSS JOIN `sRb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sRa` LEFT JOIN `sRb` USING (`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sRa` LEFT JOIN `sRb` ON (`sRa`.`bP` = `sRb`.`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sRb` RIGHT JOIN `sRa` USING (`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sRb` RIGHT JOIN `sRa` ON (`sRa`.`bP` = `sRb`.`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sSa` JOIN `sSb`;
+bP bP
+
+
+
+SELECT * FROM `sSa` INNER JOIN `sSb`;
+bP bP
+
+
+
+SELECT * FROM `sSa` JOIN `sSb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sSa` INNER JOIN `sSb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sSa` CROSS JOIN `sSb`;
+bP bP
+
+
+
+SELECT * FROM `sSa` LEFT JOIN `sSb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sSa` LEFT JOIN `sSb` ON (`sSa`.`bP` = `sSb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sSb` RIGHT JOIN `sSa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sSb` RIGHT JOIN `sSa` ON (`sSa`.`bP` = `sSb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sTa` JOIN `sTb`;
+bP bP
+
+
+
+SELECT * FROM `sTa` INNER JOIN `sTb`;
+bP bP
+
+
+
+SELECT * FROM `sTa` JOIN `sTb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sTa` INNER JOIN `sTb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sTa` CROSS JOIN `sTb`;
+bP bP
+
+
+
+SELECT * FROM `sTa` LEFT JOIN `sTb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sTa` LEFT JOIN `sTb` ON (`sTa`.`bP` = `sTb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sTb` RIGHT JOIN `sTa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sTb` RIGHT JOIN `sTa` ON (`sTa`.`bP` = `sTb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sUa` JOIN `sUb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sUa` INNER JOIN `sUb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sUa` JOIN `sUb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sUa` INNER JOIN `sUb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sUa` CROSS JOIN `sUb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sUa` LEFT JOIN `sUb` USING (`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sUa` LEFT JOIN `sUb` ON (`sUa`.`bP` = `sUb`.`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sUb` RIGHT JOIN `sUa` USING (`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sUb` RIGHT JOIN `sUa` ON (`sUa`.`bP` = `sUb`.`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sVa` JOIN `sVb`;
+bP bP
+
+
+
+SELECT * FROM `sVa` INNER JOIN `sVb`;
+bP bP
+
+
+
+SELECT * FROM `sVa` JOIN `sVb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sVa` INNER JOIN `sVb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sVa` CROSS JOIN `sVb`;
+bP bP
+
+
+
+SELECT * FROM `sVa` LEFT JOIN `sVb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sVa` LEFT JOIN `sVb` ON (`sVa`.`bP` = `sVb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sVb` RIGHT JOIN `sVa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sVb` RIGHT JOIN `sVa` ON (`sVa`.`bP` = `sVb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sWa` JOIN `sWb`;
+bP bP
+
+
+
+SELECT * FROM `sWa` INNER JOIN `sWb`;
+bP bP
+
+
+
+SELECT * FROM `sWa` JOIN `sWb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sWa` INNER JOIN `sWb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sWa` CROSS JOIN `sWb`;
+bP bP
+
+
+
+SELECT * FROM `sWa` LEFT JOIN `sWb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sWa` LEFT JOIN `sWb` ON (`sWa`.`bP` = `sWb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sWb` RIGHT JOIN `sWa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sWb` RIGHT JOIN `sWa` ON (`sWa`.`bP` = `sWb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sXa` JOIN `sXb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sXa` INNER JOIN `sXb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sXa` JOIN `sXb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sXa` INNER JOIN `sXb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sXa` CROSS JOIN `sXb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sXa` LEFT JOIN `sXb` USING (`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sXa` LEFT JOIN `sXb` ON (`sXa`.`bP` = `sXb`.`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sXb` RIGHT JOIN `sXa` USING (`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sXb` RIGHT JOIN `sXa` ON (`sXa`.`bP` = `sXb`.`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sPOa` JOIN `sPOb`;
+bP bP
+
+
+
+SELECT * FROM `sPOa` INNER JOIN `sPOb`;
+bP bP
+
+
+
+SELECT * FROM `sPOa` JOIN `sPOb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPOa` INNER JOIN `sPOb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPOa` CROSS JOIN `sPOb`;
+bP bP
+
+
+
+SELECT * FROM `sPOa` LEFT JOIN `sPOb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPOa` LEFT JOIN `sPOb` ON (`sPOa`.`bP` = `sPOb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPOb` RIGHT JOIN `sPOa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sPOb` RIGHT JOIN `sPOa` ON (`sPOa`.`bP` = `sPOb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sPPa` JOIN `sPPb`;
+bP bP
+
+
+
+SELECT * FROM `sPPa` INNER JOIN `sPPb`;
+bP bP
+
+
+
+SELECT * FROM `sPPa` JOIN `sPPb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPPa` INNER JOIN `sPPb` USING (`bP`);
+bP bP
+
+SELECT * FROM `sPPa` CROSS JOIN `sPPb`;
+bP bP
+
+
+
+SELECT * FROM `sPPa` LEFT JOIN `sPPb` USING (`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPPa` LEFT JOIN `sPPb` ON (`sPPa`.`bP` = `sPPb`.`bP`);
+bP bP
+
+ NULL
+ NULL
+SELECT * FROM `sPPb` RIGHT JOIN `sPPa` USING (`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sPPb` RIGHT JOIN `sPPa` ON (`sPPa`.`bP` = `sPPb`.`bP`);
+bP bP
+
+NULL
+NULL
+SELECT * FROM `sPQa` JOIN `sPQb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sPQa` INNER JOIN `sPQb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sPQa` JOIN `sPQb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sPQa` INNER JOIN `sPQb` USING (`bP`);
+bP bP
+\ \
+SELECT * FROM `sPQa` CROSS JOIN `sPQb`;
+bP bP
+\ \
+\ \
+\ \
+SELECT * FROM `sPQa` LEFT JOIN `sPQb` USING (`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sPQa` LEFT JOIN `sPQb` ON (`sPQa`.`bP` = `sPQb`.`bP`);
+bP bP
+\ \
+\ NULL
+\ NULL
+SELECT * FROM `sPQb` RIGHT JOIN `sPQa` USING (`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+SELECT * FROM `sPQb` RIGHT JOIN `sPQa` ON (`sPQa`.`bP` = `sPQb`.`bP`);
+bP bP
+\ \
+NULL \
+NULL \
+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`;
+DROP TABLE `sPOa`;
+DROP TABLE `sPOb`;
+DROP TABLE `sPPa`;
+DROP TABLE `sPPb`;
+DROP TABLE `sPQa`;
+DROP TABLE `sPQb`;
View Lorry Controller Status