1 files changed, 87 insertions, 0 deletions

diff --git a/mysql-test/suite/jp/t/jp_where_ujis.test b/mysql-test/suite/jp/t/jp_where_ujis.test
new file mode 100755
index 00000000000..e96404fbb17
--- /dev/null
+++ b/mysql-test/suite/jp/t/jp_where_ujis.test
@@ -0,0 +1,87 @@
+--source include/have_ujis.inc
+
+--disable_warnings
+drop table if exists `｣ﾔ｣ｱ`;
+drop table if exists `｣ﾔ｣ｲ`;
+drop table if exists `｣ﾔ｣ｳ`;
+drop table if exists `｣ﾔ｣ｴ`;
+drop table if exists `｣ﾔ｣ｵ`;
+drop table if exists `｣ﾔ｣ｶ`;
+drop table if exists `｣ﾔ｣ｷ`;
+drop table if exists `｣ﾔ｣ｸ`;
+drop table if exists `｣ﾔ｣ｹ`;
+drop table if exists `｣ﾔ｣ｱ｣ｰ`;
+drop table if exists `｣ﾔ｣ｱ｣ｱ`;
+drop table if exists `｣ﾔ｣ｱ｣ｲ`;
+--enable_warnings
+
+#
+# Test Displaying Japanese charact using WHERE condtion in ujis encoding
+#
+
+SET NAMES ujis;
+SET character_set_database = ujis;
+
+CREATE TABLE `｣ﾔ｣ｱ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｲ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｳ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｴ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｵ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｶ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｷ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = heap;
+CREATE TABLE `｣ﾔ｣ｸ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = heap;
+CREATE TABLE `｣ﾔ｣ｹ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = heap;
+CREATE TABLE `｣ﾔ｣ｱ｣ｰ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = bdb;
+CREATE TABLE `｣ﾔ｣ｱ｣ｱ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = bdb;
+CREATE TABLE `｣ﾔ｣ｱ｣ｲ` (`｣ﾃ｣ｱ` char(20), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = bdb;
+
+#Load the following data in each table
+# jisx0201 hankaku-katakana data
+# jisx0208 data
+# jisx0212 supplemental character data
+
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｱ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｲ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｳ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｴ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｵ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｶ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｷ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｸ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｹ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `｣ﾔ｣ｱ｣ｰ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `｣ﾔ｣ｱ｣ｱ`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `｣ﾔ｣ｱ｣ｲ`;
+
+#InnoDB
+SELECT * FROM `｣ﾔ｣ｱ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
+SELECT * FROM `｣ﾔ｣ｲ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
+SELECT * FROM `｣ﾔ｣ｳ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';
+
+#MyISAM
+SELECT * FROM `｣ﾔ｣ｴ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
+SELECT * FROM `｣ﾔ｣ｵ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
+SELECT * FROM `｣ﾔ｣ｶ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';
+
+#Heap
+SELECT * FROM `｣ﾔ｣ｷ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
+SELECT * FROM `｣ﾔ｣ｸ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
+SELECT * FROM `｣ﾔ｣ｹ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';
+
+#BDB
+SELECT * FROM `｣ﾔ｣ｱ｣ｰ` WHERE `｣ﾃ｣ｱ` = '鴫竺軸宍雫七叱執失嫉室悉湿漆疾質';
+SELECT * FROM `｣ﾔ｣ｱ｣ｱ` WHERE `｣ﾃ｣ｱ` = '｡ｦ､｡､｢､｣､､､･､ｦ､ｧ､ｨ､ｩ､ｪ､ｫ､ｬ､ｭ､ｮ､ｯ､ｰ､ｱ､ｲ､ｳ';
+SELECT * FROM `｣ﾔ｣ｱ｣ｲ` WHERE `｣ﾃ｣ｱ` = '常ｴ常ｵ常ｶ常ｷ常ｸ常ｹ常ｺ常ｻ常ｼ常ｽ常ｾ常ｿ常ﾀ常ﾁ常ﾂ常ﾃ常ﾄ常ﾅ常ﾆ常ﾇ';
+
+DROP TABLE `｣ﾔ｣ｱ`;
+DROP TABLE `｣ﾔ｣ｲ`;
+DROP TABLE `｣ﾔ｣ｳ`;
+DROP TABLE `｣ﾔ｣ｴ`;
+DROP TABLE `｣ﾔ｣ｵ`;
+DROP TABLE `｣ﾔ｣ｶ`;
+DROP TABLE `｣ﾔ｣ｷ`;
+DROP TABLE `｣ﾔ｣ｸ`;
+DROP TABLE `｣ﾔ｣ｹ`;
+DROP TABLE `｣ﾔ｣ｱ｣ｰ`;
+DROP TABLE `｣ﾔ｣ｱ｣ｱ`;
+DROP TABLE `｣ﾔ｣ｱ｣ｲ`;