diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_like_sjis.test')
-rwxr-xr-x | mysql-test/suite/jp/t/jp_like_sjis.test | 168 |
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 `sP`; +drop table if exists `sQ`; +drop table if exists `sR`; +drop table if exists `sS`; +drop table if exists `sT`; +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 + +# +# Test LIKE pattern matching using Japanese characters in sjis encoding +# + +SET NAMES sjis; +SET character_set_database = sjis; + +CREATE TABLE `sP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb; +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; + +#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 `sP`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`; +LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`; +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 ' %'; +SELECT * FROM `sP` WHERE `bP` LIKE '% %'; +SELECT * FROM `sP` WHERE `bP` LIKE '% '; +SELECT * FROM `sP` WHERE `bP` LIKE 'ภ%'; +SELECT * FROM `sP` WHERE `bP` LIKE '%ืุ%'; +SELECT * FROM `sP` WHERE `bP` LIKE '%ฟ'; +SELECT * FROM `sP` WHERE `bP` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sP` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sP` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ'; +SELECT * FROM `sQ` WHERE `bP` LIKE '@%'; +SELECT * FROM `sQ` WHERE `bP` LIKE '%@%'; +SELECT * FROM `sQ` WHERE `bP` LIKE '%@'; +SELECT * FROM `sQ` WHERE `bP` LIKE 'ฦ%'; +SELECT * FROM `sQ` WHERE `bP` LIKE '% %'; +SELECT * FROM `sQ` WHERE `bP` LIKE '%ํ'; +SELECT * FROM `sQ` WHERE `bP` LIKE 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sQ` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sQ` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +SELECT * FROM `sR` WHERE `bP` LIKE '\%'; +SELECT * FROM `sR` WHERE `bP` LIKE '%\%'; +SELECT * FROM `sR` WHERE `bP` LIKE '%\'; +SELECT * FROM `sR` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%'; +SELECT * FROM `sR` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%'; +SELECT * FROM `sR` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\'; + +#MyISAM +SELECT * FROM `sS` WHERE `bP` LIKE ' %'; +SELECT * FROM `sS` WHERE `bP` LIKE '% %'; +SELECT * FROM `sS` WHERE `bP` LIKE '% '; +SELECT * FROM `sS` WHERE `bP` LIKE 'ภ%'; +SELECT * FROM `sS` WHERE `bP` LIKE '%ืุ%'; +SELECT * FROM `sS` WHERE `bP` LIKE '%ฟ'; +SELECT * FROM `sS` WHERE `bP` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sS` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sS` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ'; +SELECT * FROM `sT` WHERE `bP` LIKE '@%'; +SELECT * FROM `sT` WHERE `bP` LIKE '%@%'; +SELECT * FROM `sT` WHERE `bP` LIKE '%@'; +SELECT * FROM `sT` WHERE `bP` LIKE 'ฦ%'; +SELECT * FROM `sT` WHERE `bP` LIKE '% %'; +SELECT * FROM `sT` WHERE `bP` LIKE '%ํ'; +SELECT * FROM `sT` WHERE `bP` LIKE 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sT` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sT` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +SELECT * FROM `sU` WHERE `bP` LIKE '\%'; +SELECT * FROM `sU` WHERE `bP` LIKE '%\%'; +SELECT * FROM `sU` WHERE `bP` LIKE '%\'; +SELECT * FROM `sU` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%'; +SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%'; +SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\'; + +#Heap +SELECT * FROM `sV` WHERE `bP` LIKE ' %'; +SELECT * FROM `sV` WHERE `bP` LIKE '% %'; +SELECT * FROM `sV` WHERE `bP` LIKE '% '; +SELECT * FROM `sV` WHERE `bP` LIKE 'ภ%'; +SELECT * FROM `sV` WHERE `bP` LIKE '%ืุ%'; +SELECT * FROM `sV` WHERE `bP` LIKE '%ฟ'; +SELECT * FROM `sV` WHERE `bP` LIKE 'ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sV` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ%'; +SELECT * FROM `sV` WHERE `bP` LIKE '%ฐฑฒณดตถทธนบปผฝพฟ'; +SELECT * FROM `sW` WHERE `bP` LIKE '@%'; +SELECT * FROM `sW` WHERE `bP` LIKE '%@%'; +SELECT * FROM `sW` WHERE `bP` LIKE '%@'; +SELECT * FROM `sW` WHERE `bP` LIKE 'ฦ%'; +SELECT * FROM `sW` WHERE `bP` LIKE '% %'; +SELECT * FROM `sW` WHERE `bP` LIKE '%ํ'; +SELECT * FROM `sW` WHERE `bP` LIKE 'E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sW` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ%'; +SELECT * FROM `sW` WHERE `bP` LIKE '%E กขฃคฅฆงจฉชซฌญฎฏฐฑ'; +SELECT * FROM `sX` WHERE `bP` LIKE '\%'; +SELECT * FROM `sX` WHERE `bP` LIKE '%\%'; +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`; +DROP TABLE `sR`; +DROP TABLE `sS`; +DROP TABLE `sT`; +DROP TABLE `sU`; +DROP TABLE `sV`; +DROP TABLE `sW`; +DROP TABLE `sX`; +DROP TABLE `sPO`; +DROP TABLE `sPP`; +DROP TABLE `sPQ`; |