diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_like_ujis.result')
-rw-r--r-- | mysql-test/suite/jp/r/jp_like_ujis.result | 68 |
1 files changed, 3 insertions, 65 deletions
diff --git a/mysql-test/suite/jp/r/jp_like_ujis.result b/mysql-test/suite/jp/r/jp_like_ujis.result index 5d623df0384..a0cf0264dfb 100644 --- a/mysql-test/suite/jp/r/jp_like_ujis.result +++ b/mysql-test/suite/jp/r/jp_like_ujis.result @@ -7,9 +7,6 @@ drop table if exists `T6`; drop table if exists `T7`; drop table if exists `T8`; drop table if exists `T9`; -drop table if exists `T10`; -drop table if exists `T11`; -drop table if exists `T12`; SET NAMES ujis; SET character_set_database = ujis; CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = innodb; @@ -18,12 +15,9 @@ CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engi CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam; -CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap; -CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap; -CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap; -CREATE TABLE `T10` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb; -CREATE TABLE `T11` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb; -CREATE TABLE `T12` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb; +CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = MEMORY; +CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = MEMORY; +CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = MEMORY; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `T1`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `T2`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `T3`; @@ -33,9 +27,6 @@ LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `T6`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `T7`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `T8`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `T9`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `T10`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `T11`; -LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `T12`; SELECT * FROM `T1` WHERE `C1` LIKE ' %'; C1 !"#$%&'()*+,-./ @@ -258,56 +249,6 @@ SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃 SELECT * FROM `T9` WHERE `C1` LIKE '%鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖'; C1 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖 -SELECT * FROM `T10` WHERE `C1` LIKE ' %'; -C1 - !"#$%&'()*+,-./ - 。「」、・ヲァィゥェォャュョッ -SELECT * FROM `T10` WHERE `C1` LIKE '% %'; -C1 - !"#$%&'()*+,-./ - 。「」、・ヲァィゥェォャュョッ -SELECT * FROM `T10` WHERE `C1` LIKE '% '; -C1 -SELECT * FROM `T10` WHERE `C1` LIKE 'タ%'; -C1 -タチツテトナニヌネノハヒフヘホマ -SELECT * FROM `T10` WHERE `C1` LIKE '%ラリ%'; -C1 -ミムメモヤユヨラリルレロワン゙゚ -SELECT * FROM `T10` WHERE `C1` LIKE '%ソ'; -C1 -ーアイウエオカキクケコサシスセソ -SELECT * FROM `T10` WHERE `C1` LIKE '%ーアイウエオカキクケコサシスセソ'; -C1 -ーアイウエオカキクケコサシスセソ -SELECT * FROM `T11` WHERE `C1` LIKE ' %'; -C1 - 、。,.・:;?!゛゜´`¨^ ̄_ヽ -SELECT * FROM `T11` WHERE `C1` LIKE '% %'; -C1 - 、。,.・:;?!゛゜´`¨^ ̄_ヽ -・・ʼn♯♭♪†‡¶・・・・◯・・・・ -SELECT * FROM `T11` WHERE `C1` LIKE '% '; -C1 -・・ʼn♯♭♪†‡¶・・・・◯・・・・ -SELECT * FROM `T11` WHERE `C1` LIKE 'と%'; -C1 -とどなにぬねのはばぱひびぴふぶぷへべぺほ -SELECT * FROM `T11` WHERE `C1` LIKE '%あ%'; -C1 -・ぁあぃいぅうぇえぉおかがきぎくぐけげこ -SELECT * FROM `T11` WHERE `C1` LIKE '%わ'; -C1 -ぼぽまみむめもゃやゅゆょよらりるれろゎわ -SELECT * FROM `T12` WHERE `C1` LIKE '鼫%'; -C1 -鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖 -SELECT * FROM `T12` WHERE `C1` LIKE '%鼺%'; -C1 -鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖 -SELECT * FROM `T12` WHERE `C1` LIKE '%齖'; -C1 -鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖 DROP TABLE `T1`; DROP TABLE `T2`; DROP TABLE `T3`; @@ -317,6 +258,3 @@ DROP TABLE `T6`; DROP TABLE `T7`; DROP TABLE `T8`; DROP TABLE `T9`; -DROP TABLE `T10`; -DROP TABLE `T11`; -DROP TABLE `T12`; |