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')
-rw-r--r--mysql-test/suite/jp/t/jp_like_sjis.test46
1 files changed, 5 insertions, 41 deletions
diff --git a/mysql-test/suite/jp/t/jp_like_sjis.test b/mysql-test/suite/jp/t/jp_like_sjis.test
index 5c41b9ff7ef..6cb6092852a 100644
--- a/mysql-test/suite/jp/t/jp_like_sjis.test
+++ b/mysql-test/suite/jp/t/jp_like_sjis.test
@@ -1,4 +1,5 @@
--character_set sjis
+--source include/have_innodb.inc
--disable_warnings
drop table if exists `‚s‚P`;
drop table if exists `‚s‚Q`;
@@ -9,9 +10,6 @@ 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
#
@@ -27,12 +25,9 @@ CREATE TABLE `‚s‚R` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engi
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;
+CREATE TABLE `‚s‚V` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
+CREATE TABLE `‚s‚W` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
+CREATE TABLE `‚s‚X` (`‚b‚P` char(20), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
#Load the following data in each table
# jisx0201 hankaku-katakana data
@@ -47,9 +42,6 @@ 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 ' %';
@@ -103,7 +95,7 @@ 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
+#MEMORY
SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE ' %';
SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% %';
SELECT * FROM `‚s‚V` WHERE `‚b‚P` LIKE '% ';
@@ -128,31 +120,6 @@ 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`;
@@ -163,6 +130,3 @@ 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`;