diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_like_sjis.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_like_sjis.test | 46 |
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 `sP`; drop table if exists `sQ`; @@ -9,9 +10,6 @@ drop table if exists `sU`; drop table if exists `sV`; drop table if exists `sW`; drop table if exists `sX`; -drop table if exists `sPO`; -drop table if exists `sPP`; -drop table if exists `sPQ`; --enable_warnings # @@ -27,12 +25,9 @@ CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engi CREATE TABLE `sS` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sT` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sU` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam; -CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPO` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb; -CREATE TABLE `sPP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb; -CREATE TABLE `sPQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb; +CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) 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 `sU`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`; #InnoDB SELECT * FROM `sP` WHERE `bP` LIKE ' %'; @@ -103,7 +95,7 @@ SELECT * FROM `sU` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\ SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%'; SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\'; -#Heap +#MEMORY SELECT * FROM `sV` WHERE `bP` LIKE ' %'; SELECT * FROM `sV` WHERE `bP` LIKE '% %'; SELECT * FROM `sV` WHERE `bP` LIKE '% '; @@ -128,31 +120,6 @@ SELECT * FROM `sX` WHERE `bP` LIKE '%\'; SELECT * FROM `sX` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%'; SELECT * FROM `sX` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%'; SELECT * FROM `sX` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\'; -#BDB -SELECT * FROM `sPO` WHERE `bP` LIKE ' %'; -SELECT * FROM `sPO` WHERE `bP` LIKE '% %'; -SELECT * FROM `sPO` WHERE `bP` LIKE '% '; -SELECT * FROM `sPO` WHERE `bP` LIKE 'ภ%'; -SELECT * FROM `sPO` WHERE `bP` LIKE '%ืุ%'; -SELECT * FROM `sPO` WHERE `bP` LIKE '%ฟ'; -#SELECT * FROM `sPO` WHERE `bP` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%'; -#SELECT * FROM `sPO` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%'; -SELECT * FROM `sPO` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ'; -SELECT * FROM `sPP` WHERE `bP` LIKE '@%'; -SELECT * FROM `sPP` WHERE `bP` LIKE '%@%'; -SELECT * FROM `sPP` WHERE `bP` LIKE '%@'; -SELECT * FROM `sPP` WHERE `bP` LIKE 'ฦ%'; -SELECT * FROM `sPP` WHERE `bP` LIKE '% %'; -SELECT * FROM `sPP` WHERE `bP` LIKE '%ํ'; -#SELECT * FROM `sPP` WHERE `bP` LIKE 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; -#SELECT * FROM `sPP` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; -#SELECT * FROM `sPP` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; -SELECT * FROM `sPQ` WHERE `bP` LIKE '\%'; -SELECT * FROM `sPQ` WHERE `bP` LIKE '%\%'; -SELECT * FROM `sPQ` WHERE `bP` LIKE '%\'; -#SELECT * FROM `sPQ` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%'; -#SELECT * FROM `sPQ` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%'; -#SELECT * FROM `sPQ` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\'; DROP TABLE `sP`; DROP TABLE `sQ`; @@ -163,6 +130,3 @@ DROP TABLE `sU`; DROP TABLE `sV`; DROP TABLE `sW`; DROP TABLE `sX`; -DROP TABLE `sPO`; -DROP TABLE `sPP`; -DROP TABLE `sPQ`; |