summaryrefslogtreecommitdiff
path: root/mysql-test/suite/jp/t/jp_like_sjis.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/t/jp_like_sjis.test')
-rwxr-xr-xmysql-test/suite/jp/t/jp_like_sjis.test168
1 files changed, 168 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/t/jp_like_sjis.test b/mysql-test/suite/jp/t/jp_like_sjis.test
new file mode 100755
index 00000000000..5c41b9ff7ef
--- /dev/null
+++ b/mysql-test/suite/jp/t/jp_like_sjis.test
@@ -0,0 +1,168 @@
+--character_set sjis
+--disable_warnings
+drop table if exists `‚s‚P`;
+drop table if exists `‚s‚Q`;
+drop table if exists `‚s‚R`;
+drop table if exists `‚s‚S`;
+drop table if exists `‚s‚T`;
+drop table if exists `‚s‚U`;
+drop table if exists `‚s‚V`;
+drop table if exists `‚s‚W`;
+drop table if exists `‚s‚X`;
+drop table if exists `‚s‚P‚O`;
+drop table if exists `‚s‚P‚P`;
+drop table if exists `‚s‚P‚Q`;
+--enable_warnings
+
+#
+# Test LIKE pattern matching using Japanese characters in sjis encoding
+#
+
+SET NAMES sjis;
+SET character_set_database = sjis;
+
+CREATE TABLE `‚s‚P` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚Q` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚R` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
+CREATE TABLE `‚s‚S` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚T` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚U` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
+CREATE TABLE `‚s‚V` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚W` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚X` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = heap;
+CREATE TABLE `‚s‚P‚O` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+CREATE TABLE `‚s‚P‚P` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+CREATE TABLE `‚s‚P‚Q` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = bdb;
+
+#Load the following data in each table
+# jisx0201 hankaku-katakana data
+# jisx0208 data
+
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚Q`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚R`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚S`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚T`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚U`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚V`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚W`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚X`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `‚s‚P‚O`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `‚s‚P‚P`;
+LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `‚s‚P‚Q`;
+
+#InnoDB
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE ' %';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% %';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '% ';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE 'ภ%';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%ืุ%';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%ฟ';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚P` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '@%';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%@%';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%@';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '‚ฦ%';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚ %';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%‚ํ';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚Q` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\%';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%–\%';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ž\';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚R` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\';
+
+#MyISAM
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE ' %';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% %';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '% ';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE 'ภ%';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%ืุ%';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%ฟ';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚S` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '@%';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%@%';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%@';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '‚ฦ%';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚ %';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%‚ํ';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚T` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\%';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%–\%';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ž\';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚U` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\';
+
+#Heap
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE ' %';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% %';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% ';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE 'ภ%';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%ืุ%';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%ฟ';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '@%';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%@%';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%@';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '‚ฦ%';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚ %';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%‚ํ';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+SELECT * FROM `‚s‚W` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\%';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%–\%';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ž\';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+SELECT * FROM `‚s‚X` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\';
+#BDB
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE ' %';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '% %';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '% ';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE 'ภ%';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%ืุ%';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%ฟ';
+#SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%';
+#SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%';
+SELECT * FROM `‚s‚P‚O` WHERE `‚b‚P` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '@%';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%@%';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%@';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '‚ฦ%';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%‚ %';
+SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%‚ํ';
+#SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE 'E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+#SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ%';
+#SELECT * FROM `‚s‚P‚P` WHERE `‚b‚P` LIKE '%E‚Ÿ‚ ‚ก‚ข‚ฃ‚ค‚ฅ‚ฆ‚ง‚จ‚ฉ‚ช‚ซ‚ฌ‚ญ‚ฎ‚ฏ‚ฐ‚ฑ';
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE 'ƒ\%';
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%–\%';
+SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%ž\';
+#SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE 'ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+#SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\%';
+#SELECT * FROM `‚s‚P‚Q` WHERE `‚b‚P` LIKE '%ƒ\\•\—\\‰\Ž\\“\”\–\˜\‘\’\™\š\›\œ\\ž\';
+
+DROP TABLE `‚s‚P`;
+DROP TABLE `‚s‚Q`;
+DROP TABLE `‚s‚R`;
+DROP TABLE `‚s‚S`;
+DROP TABLE `‚s‚T`;
+DROP TABLE `‚s‚U`;
+DROP TABLE `‚s‚V`;
+DROP TABLE `‚s‚W`;
+DROP TABLE `‚s‚X`;
+DROP TABLE `‚s‚P‚O`;
+DROP TABLE `‚s‚P‚P`;
+DROP TABLE `‚s‚P‚Q`;