polardbxengine/mysql-test/suite/jp/r/jp_join_sjis.result

446 lines
9.3 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

DROP TABLE IF EXISTS `sPa`;
DROP TABLE IF EXISTS `sPb`;
DROP TABLE IF EXISTS `sQa`;
DROP TABLE IF EXISTS `sQb`;
DROP TABLE IF EXISTS `sRa`;
DROP TABLE IF EXISTS `sRb`;
DROP TABLE IF EXISTS `sSa`;
DROP TABLE IF EXISTS `sSb`;
DROP TABLE IF EXISTS `sTa`;
DROP TABLE IF EXISTS `sTb`;
DROP TABLE IF EXISTS `sUa`;
DROP TABLE IF EXISTS `sUb`;
DROP TABLE IF EXISTS `sVa`;
DROP TABLE IF EXISTS `sVb`;
DROP TABLE IF EXISTS `sWa`;
DROP TABLE IF EXISTS `sWb`;
DROP TABLE IF EXISTS `sXa`;
DROP TABLE IF EXISTS `sXb`;
SET NAMES sjis;
SET character_set_database = sjis;
Warnings:
Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
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 ('ƒ\'),('<27>\'),('•\');
INSERT INTO `sRb` VALUES ('ƒ\');
INSERT INTO `sSa` VALUES ('±'),('¶'),('»');
INSERT INTO `sSb` VALUES ('±');
INSERT INTO `sTa` VALUES (' '),('‚©'),('‚³');
INSERT INTO `sTb` VALUES (' ');
INSERT INTO `sUa` VALUES ('ƒ\'),('<27>\'),('•\');
INSERT INTO `sUb` VALUES ('ƒ\');
INSERT INTO `sVa` VALUES ('±'),('¶'),('»');
INSERT INTO `sVb` VALUES ('±');
INSERT INTO `sWa` VALUES (' '),('‚©'),('‚³');
INSERT INTO `sWb` VALUES (' ');
INSERT INTO `sXa` VALUES ('ƒ\'),('<27>\'),('•\');
INSERT INTO `sXb` VALUES ('ƒ\');
SELECT * FROM `sPa` JOIN `sPb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sPa` INNER JOIN `sPb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sPa` JOIN `sPb` USING (`bP`);
bP
±
SELECT * FROM `sPa` INNER JOIN `sPb` USING (`bP`);
bP
±
SELECT * FROM `sPa` CROSS JOIN `sPb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sPa` LEFT JOIN `sPb` USING (`bP`);
bP
±
»
SELECT * FROM `sPa` LEFT JOIN `sPb` ON (`sPa`.`bP` = `sPb`.`bP`);
bP bP
± ±
¶ NULL
» NULL
SELECT * FROM `sPb` RIGHT JOIN `sPa` USING (`bP`);
bP
±
»
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
 
SELECT * FROM `sQa` INNER JOIN `sQb` USING (`bP`);
bP
 
SELECT * FROM `sQa` CROSS JOIN `sQb`;
bP bP
   
‚©  
‚³  
SELECT * FROM `sQa` LEFT JOIN `sQb` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sQa` LEFT JOIN `sQb` ON (`sQa`.`bP` = `sQb`.`bP`);
bP bP
   
‚© NULL
‚³ NULL
SELECT * FROM `sQb` RIGHT JOIN `sQa` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sQb` RIGHT JOIN `sQa` ON (`sQa`.`bP` = `sQb`.`bP`);
bP bP
   
NULL ‚©
NULL ‚³
SELECT * FROM `sRa` JOIN `sRb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sRa` INNER JOIN `sRb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sRa` JOIN `sRb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sRa` INNER JOIN `sRb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sRa` CROSS JOIN `sRb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sRa` LEFT JOIN `sRb` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sRa` LEFT JOIN `sRb` ON (`sRa`.`bP` = `sRb`.`bP`);
bP bP
ƒ\ ƒ\
<EFBFBD>\ NULL
•\ NULL
SELECT * FROM `sRb` RIGHT JOIN `sRa` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sRb` RIGHT JOIN `sRa` ON (`sRa`.`bP` = `sRb`.`bP`);
bP bP
ƒ\ ƒ\
NULL <09>\
NULL •\
SELECT * FROM `sSa` JOIN `sSb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sSa` INNER JOIN `sSb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sSa` JOIN `sSb` USING (`bP`);
bP
±
SELECT * FROM `sSa` INNER JOIN `sSb` USING (`bP`);
bP
±
SELECT * FROM `sSa` CROSS JOIN `sSb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sSa` LEFT JOIN `sSb` USING (`bP`);
bP
±
»
SELECT * FROM `sSa` LEFT JOIN `sSb` ON (`sSa`.`bP` = `sSb`.`bP`);
bP bP
± ±
¶ NULL
» NULL
SELECT * FROM `sSb` RIGHT JOIN `sSa` USING (`bP`);
bP
±
»
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
 
SELECT * FROM `sTa` INNER JOIN `sTb` USING (`bP`);
bP
 
SELECT * FROM `sTa` CROSS JOIN `sTb`;
bP bP
   
‚©  
‚³  
SELECT * FROM `sTa` LEFT JOIN `sTb` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sTa` LEFT JOIN `sTb` ON (`sTa`.`bP` = `sTb`.`bP`);
bP bP
   
‚© NULL
‚³ NULL
SELECT * FROM `sTb` RIGHT JOIN `sTa` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sTb` RIGHT JOIN `sTa` ON (`sTa`.`bP` = `sTb`.`bP`);
bP bP
   
NULL ‚©
NULL ‚³
SELECT * FROM `sUa` JOIN `sUb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sUa` INNER JOIN `sUb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sUa` JOIN `sUb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sUa` INNER JOIN `sUb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sUa` CROSS JOIN `sUb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sUa` LEFT JOIN `sUb` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sUa` LEFT JOIN `sUb` ON (`sUa`.`bP` = `sUb`.`bP`);
bP bP
ƒ\ ƒ\
<EFBFBD>\ NULL
•\ NULL
SELECT * FROM `sUb` RIGHT JOIN `sUa` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sUb` RIGHT JOIN `sUa` ON (`sUa`.`bP` = `sUb`.`bP`);
bP bP
ƒ\ ƒ\
NULL <09>\
NULL •\
SELECT * FROM `sVa` JOIN `sVb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sVa` INNER JOIN `sVb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sVa` JOIN `sVb` USING (`bP`);
bP
±
SELECT * FROM `sVa` INNER JOIN `sVb` USING (`bP`);
bP
±
SELECT * FROM `sVa` CROSS JOIN `sVb`;
bP bP
± ±
¶ ±
» ±
SELECT * FROM `sVa` LEFT JOIN `sVb` USING (`bP`);
bP
±
»
SELECT * FROM `sVa` LEFT JOIN `sVb` ON (`sVa`.`bP` = `sVb`.`bP`);
bP bP
± ±
¶ NULL
» NULL
SELECT * FROM `sVb` RIGHT JOIN `sVa` USING (`bP`);
bP
±
»
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
 
SELECT * FROM `sWa` INNER JOIN `sWb` USING (`bP`);
bP
 
SELECT * FROM `sWa` CROSS JOIN `sWb`;
bP bP
   
‚©  
‚³  
SELECT * FROM `sWa` LEFT JOIN `sWb` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sWa` LEFT JOIN `sWb` ON (`sWa`.`bP` = `sWb`.`bP`);
bP bP
   
‚© NULL
‚³ NULL
SELECT * FROM `sWb` RIGHT JOIN `sWa` USING (`bP`);
bP
 
‚©
‚³
SELECT * FROM `sWb` RIGHT JOIN `sWa` ON (`sWa`.`bP` = `sWb`.`bP`);
bP bP
   
NULL ‚©
NULL ‚³
SELECT * FROM `sXa` JOIN `sXb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sXa` INNER JOIN `sXb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sXa` JOIN `sXb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sXa` INNER JOIN `sXb` USING (`bP`);
bP
ƒ\
SELECT * FROM `sXa` CROSS JOIN `sXb`;
bP bP
ƒ\ ƒ\
<EFBFBD>\ ƒ\
•\ ƒ\
SELECT * FROM `sXa` LEFT JOIN `sXb` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sXa` LEFT JOIN `sXb` ON (`sXa`.`bP` = `sXb`.`bP`);
bP bP
ƒ\ ƒ\
<EFBFBD>\ NULL
•\ NULL
SELECT * FROM `sXb` RIGHT JOIN `sXa` USING (`bP`);
bP
ƒ\
<EFBFBD>\
•\
SELECT * FROM `sXb` RIGHT JOIN `sXa` ON (`sXa`.`bP` = `sXb`.`bP`);
bP bP
ƒ\ ƒ\
NULL <09>\
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`;