diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_convert_ucs2.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_convert_ucs2.test | 58 |
1 files changed, 8 insertions, 50 deletions
diff --git a/mysql-test/suite/jp/t/jp_convert_ucs2.test b/mysql-test/suite/jp/t/jp_convert_ucs2.test index 88b0d0c9cba..cf79622373c 100644 --- a/mysql-test/suite/jp/t/jp_convert_ucs2.test +++ b/mysql-test/suite/jp/t/jp_convert_ucs2.test @@ -1,4 +1,8 @@ +--source include/have_sjis.inc --source include/have_ucs2.inc +--source include/have_ujis.inc +--source include/have_utf8.inc +--source include/have_innodb.inc --disable_warnings drop table if exists `T1`; @@ -10,9 +14,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`; --enable_warnings # @@ -29,12 +30,9 @@ CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engi CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; -CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T10` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = bdb; -CREATE TABLE `T11` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = bdb; -CREATE TABLE `T12` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = bdb; +CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; #Insert the following data in each table # jisx0201 hankaku-katakana data @@ -116,31 +114,6 @@ INSERT INTO `T9` VALUES ,('鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖') ,('齗齘齚齝齞齨齩齭齮齯齰齱齳齵齺齽龏龐龑龒'); -INSERT INTO `T10` VALUES - ('PQRSTUVWXYZ[\\]^_') -,(' 。「」、・ヲァィゥェォャュョッ') -,('ーアイウエオカキクケコサシスセソ') -,('タチツテトナニヌネノハヒフヘホマ') -,('ミムメモヤユヨラリルレロワン゙゚'); - -INSERT INTO `T11` VALUES - ('ヾゝゞ〃仝々〆〇ー―‐/\〜‖|…‥‘’') -,('“”()〔〕[]{}〈〉《》「」『』【】') -,('・ぁあぃいぅうぇえぉおかがきぎくぐけげこ') -,('・ァアィイゥウェエォオカガキギクグケゲコ') -,('・亜唖娃阿哀愛挨姶逢葵茜穐悪握渥旭葦芦鯵') -,('・弌丐丕个丱丶丼丿乂乖乘亂亅豫亊舒弍于亞') -,('・鵝鵞鵤鵑鵐鵙鵲鶉鶇鶫鵯鵺鶚鶤鶩鶲鷄鷁鶻'); - -INSERT INTO `T12` VALUES - ('・˛˚~΄΅・・・・・・・・¡¦¿・・・') -,('乚乜乣乨乩乴乵乹乿亍亖亗亝亯亹仃仐仚仛仠') -,('仡仢仨仯仱仳仵份仾仿伀伂伃伈伋伌伒伕伖众') -,('伙伮伱你伳伵伷伹伻伾佀佂佈佉佋佌佒佔佖佘') -,('・黸黿鼂鼃鼉鼏鼐鼑鼒鼔鼖鼗鼙鼚鼛鼟鼢鼦鼪') -,('鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖') -,('齗齘齚齝齞齨齩齭齮齯齰齱齳齵齺齽龏龐龑龒'); - #InnoDB SELECT `C1`, CONVERT(`C1` using utf8) FROM `T1`; SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T1`; @@ -165,7 +138,7 @@ SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T6`; # The result will get garbled because jisx0212 is not included in sjis SELECT `C1`, CONVERT(`C1` using sjis) FROM `T6`; -#Heap +#MEMORY SELECT `C1`, CONVERT(`C1` using utf8) FROM `T7`; SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T7`; SELECT `C1`, CONVERT(`C1` using sjis) FROM `T7`; @@ -177,18 +150,6 @@ SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T9`; # The result will get garbled because jisx0212 is not included in sjis SELECT `C1`, CONVERT(`C1` using sjis) FROM `T9`; -#BDB -SELECT `C1`, CONVERT(`C1` using utf8) FROM `T10`; -SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T10`; -SELECT `C1`, CONVERT(`C1` using sjis) FROM `T10`; -SELECT `C1`, CONVERT(`C1` using utf8) FROM `T11`; -SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T11`; -SELECT `C1`, CONVERT(`C1` using sjis) FROM `T11`; -SELECT `C1`, CONVERT(`C1` using utf8) FROM `T12`; -SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T12`; -# The result will get garbled because jisx0212 is not included in sjis -SELECT `C1`, CONVERT(`C1` using sjis) FROM `T12`; - drop table `T1`; drop table `T2`; drop table `T3`; @@ -198,6 +159,3 @@ drop table `T6`; drop table `T7`; drop table `T8`; drop table `T9`; -drop table `T10`; -drop table `T11`; -drop table `T12`; |