120 lines
6.1 KiB
Plaintext
120 lines
6.1 KiB
Plaintext
--character_set ujis
|
||
--disable_warnings
|
||
DROP TABLE IF EXISTS `£Ô£±a`;
|
||
DROP TABLE IF EXISTS `£Ô£±b`;
|
||
DROP TABLE IF EXISTS `£Ô£²a`;
|
||
DROP TABLE IF EXISTS `£Ô£²b`;
|
||
DROP TABLE IF EXISTS `£Ô£³a`;
|
||
DROP TABLE IF EXISTS `£Ô£³b`;
|
||
DROP TABLE IF EXISTS `£Ô£´a`;
|
||
DROP TABLE IF EXISTS `£Ô£´b`;
|
||
DROP TABLE IF EXISTS `£Ô£µa`;
|
||
DROP TABLE IF EXISTS `£Ô£µb`;
|
||
DROP TABLE IF EXISTS `£Ô£¶a`;
|
||
DROP TABLE IF EXISTS `£Ô£¶b`;
|
||
DROP TABLE IF EXISTS `£Ô£·a`;
|
||
DROP TABLE IF EXISTS `£Ô£·b`;
|
||
DROP TABLE IF EXISTS `£Ô£¸a`;
|
||
DROP TABLE IF EXISTS `£Ô£¸b`;
|
||
DROP TABLE IF EXISTS `£Ô£¹a`;
|
||
DROP TABLE IF EXISTS `£Ô£¹b`;
|
||
--enable_warnings
|
||
|
||
#
|
||
# Test subquery using Japanese characters in ujis encoding
|
||
#
|
||
|
||
SET NAMES ujis;
|
||
SET character_set_database = ujis;
|
||
|
||
CREATE TABLE `£Ô£±a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£±b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£²a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£²b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£³a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£³b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = innodb;
|
||
CREATE TABLE `£Ô£´a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£´b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£µa` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£µb` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£¶a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£¶b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = myisam;
|
||
CREATE TABLE `£Ô£·a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£·b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¸a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¸b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¹a` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
CREATE TABLE `£Ô£¹b` (`£Ã£±` char(1) PRIMARY KEY) DEFAULT CHARSET = ujis engine = MEMORY;
|
||
|
||
#insert the following data in each table
|
||
# jisx0201 hankaku-katakana data
|
||
# jisx0208 data
|
||
# jisx0212 supplemental character data
|
||
|
||
INSERT INTO `£Ô£±a` VALUES ('Ž±'),('Ž¶'),('Ž»');
|
||
INSERT INTO `£Ô£±b` VALUES ('Ž±');
|
||
INSERT INTO `£Ô£²a` VALUES ('¤¢'),('¤«'),('¤µ');
|
||
INSERT INTO `£Ô£²b` VALUES ('¤¢');
|
||
INSERT INTO `£Ô£³a` VALUES ('<27>íÜ'),('<27>íÝ'),('<27>íÞ');
|
||
INSERT INTO `£Ô£³b` VALUES ('<27>íÜ');
|
||
INSERT INTO `£Ô£´a` VALUES ('Ž±'),('Ž¶'),('Ž»');
|
||
INSERT INTO `£Ô£´b` VALUES ('Ž±');
|
||
INSERT INTO `£Ô£µa` VALUES ('¤¢'),('¤«'),('¤µ');
|
||
INSERT INTO `£Ô£µb` VALUES ('¤¢');
|
||
INSERT INTO `£Ô£¶a` VALUES ('<27>íÜ'),('<27>íÝ'),('<27>íÞ');
|
||
INSERT INTO `£Ô£¶b` VALUES ('<27>íÜ');
|
||
INSERT INTO `£Ô£·a` VALUES ('Ž±'),('Ž¶'),('Ž»');
|
||
INSERT INTO `£Ô£·b` VALUES ('Ž±');
|
||
INSERT INTO `£Ô£¸a` VALUES ('¤¢'),('¤«'),('¤µ');
|
||
INSERT INTO `£Ô£¸b` VALUES ('¤¢');
|
||
INSERT INTO `£Ô£¹a` VALUES ('<27>íÜ'),('<27>íÝ'),('<27>íÞ');
|
||
INSERT INTO `£Ô£¹b` VALUES ('<27>íÜ');
|
||
|
||
#Test for innodb
|
||
SELECT `£Ã£±` FROM `£Ô£±a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£±b`);
|
||
SELECT `£Ã£±` FROM `£Ô£±a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£±a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£±b` WHERE `£Ô£±a`.`£Ã£±` = `£Ô£±b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£²a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£²b`);
|
||
SELECT `£Ã£±` FROM `£Ô£²a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£²a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£²b` WHERE `£Ô£²a`.`£Ã£±` = `£Ô£²b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£³a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£³b`);
|
||
SELECT `£Ã£±` FROM `£Ô£³a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£³a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£³b` WHERE `£Ô£³a`.`£Ã£±` = `£Ô£³b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£´a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£´b`);
|
||
SELECT `£Ã£±` FROM `£Ô£´a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£´b` WHERE `£Ô£´a`.`£Ã£±` = `£Ô£´b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£´a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£´b` WHERE `£Ô£´a`.`£Ã£±` = `£Ô£´b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£µa` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£µb`);
|
||
SELECT `£Ã£±` FROM `£Ô£µa` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£µa` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£µb` WHERE `£Ô£µa`.`£Ã£±` = `£Ô£µb`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¶b`);
|
||
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¶a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¶b` WHERE `£Ô£¶a`.`£Ã£±` = `£Ô£¶b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£·a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£·b`);
|
||
SELECT `£Ã£±` FROM `£Ô£·a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£·a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£·b` WHERE `£Ô£·a`.`£Ã£±` = `£Ô£·b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¸a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¸b`);
|
||
SELECT `£Ã£±` FROM `£Ô£¸a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¸b` WHERE `£Ô£¸a`.`£Ã£±` = `£Ô£¸b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¸a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¸b` WHERE `£Ô£¸a`.`£Ã£±` = `£Ô£¸b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE `£Ã£±` IN (SELECT `£Ã£±` FROM `£Ô£¹b`);
|
||
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
|
||
SELECT `£Ã£±` FROM `£Ô£¹a` WHERE NOT EXISTS (SELECT `£Ã£±` FROM `£Ô£¹b` WHERE `£Ô£¹a`.`£Ã£±` = `£Ô£¹b`.`£Ã£±`);
|
||
|
||
DROP TABLE `£Ô£±a`;
|
||
DROP TABLE `£Ô£±b`;
|
||
DROP TABLE `£Ô£²a`;
|
||
DROP TABLE `£Ô£²b`;
|
||
DROP TABLE `£Ô£³a`;
|
||
DROP TABLE `£Ô£³b`;
|
||
DROP TABLE `£Ô£´a`;
|
||
DROP TABLE `£Ô£´b`;
|
||
DROP TABLE `£Ô£µa`;
|
||
DROP TABLE `£Ô£µb`;
|
||
DROP TABLE `£Ô£¶a`;
|
||
DROP TABLE `£Ô£¶b`;
|
||
DROP TABLE `£Ô£·a`;
|
||
DROP TABLE `£Ô£·b`;
|
||
DROP TABLE `£Ô£¸a`;
|
||
DROP TABLE `£Ô£¸b`;
|
||
DROP TABLE `£Ô£¹a`;
|
||
DROP TABLE `£Ô£¹b`;
|