diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_charset_utf8.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_charset_utf8.test | 43 |
1 files changed, 10 insertions, 33 deletions
diff --git a/mysql-test/suite/jp/t/jp_charset_utf8.test b/mysql-test/suite/jp/t/jp_charset_utf8.test index 2d73daba42a..e02c035fb33 100644 --- a/mysql-test/suite/jp/t/jp_charset_utf8.test +++ b/mysql-test/suite/jp/t/jp_charset_utf8.test @@ -1,3 +1,9 @@ +--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`; drop table if exists `T2`; @@ -8,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 # @@ -26,12 +29,9 @@ CREATE TABLE `T3` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb CREATE TABLE `T4` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam; CREATE TABLE `T5` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam; CREATE TABLE `T6` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam; -CREATE TABLE `T7` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `T8` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `T9` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `T10` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = bdb; -CREATE TABLE `T11` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = bdb; -CREATE TABLE `T12` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = bdb; +CREATE TABLE `T7` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T8` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `T9` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY; #Load the following data in each table # jisx0201 hankaku-katakana data @@ -47,9 +47,6 @@ CREATE TABLE `T12` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = bdb LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`; LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`; - LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T10`; - LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T11`; - LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T12`; #InnoDB SELECT DISTINCT CHARSET(`C1`) FROM `T1`; @@ -85,7 +82,7 @@ SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T6`; SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T6`; SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T6`; -#Heap +#MEMORY SELECT DISTINCT CHARSET(`C1`) FROM `T7`; SELECT DISTINCT CHARSET(`C1`) FROM `T8`; SELECT DISTINCT CHARSET(`C1`) FROM `T9`; @@ -102,23 +99,6 @@ SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T9`; SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T9`; SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T9`; -#BDB -SELECT DISTINCT CHARSET(`C1`) FROM `T10`; -SELECT DISTINCT CHARSET(`C1`) FROM `T11`; -SELECT DISTINCT CHARSET(`C1`) FROM `T12`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T10`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T10`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T10`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T10`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T11`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T11`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T11`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T11`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T12`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T12`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T12`; -SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T12`; - drop table `T1`; drop table `T2`; drop table `T3`; @@ -128,6 +108,3 @@ drop table `T6`; drop table `T7`; drop table `T8`; drop table `T9`; -drop table `T10`; -drop table `T11`; -drop table `T12`; |