diff options
Diffstat (limited to 'mysql-test/suite/jp/r/jp_insert_ucs2.result')
-rw-r--r-- | mysql-test/suite/jp/r/jp_insert_ucs2.result | 198 |
1 files changed, 3 insertions, 195 deletions
diff --git a/mysql-test/suite/jp/r/jp_insert_ucs2.result b/mysql-test/suite/jp/r/jp_insert_ucs2.result index 45487f65138..e382f38515c 100644 --- a/mysql-test/suite/jp/r/jp_insert_ucs2.result +++ b/mysql-test/suite/jp/r/jp_insert_ucs2.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 = ucs2; SET collation_connection = ucs2_general_ci; @@ -19,12 +16,9 @@ CREATE TABLE `T3` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = innodb; CREATE TABLE `T4` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = myisam; CREATE TABLE `T5` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = myisam; CREATE TABLE `T6` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = myisam; -CREATE TABLE `T7` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T8` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T9` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = heap; -CREATE TABLE `T10` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = bdb; -CREATE TABLE `T11` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = bdb; -CREATE TABLE `T12` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = bdb; +CREATE TABLE `T7` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T8` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T9` (`C1` char(5)) DEFAULT CHARSET = ucs2 engine = MEMORY; INSERT INTO `T1` VALUES ('アイウエオ'); INSERT INTO `T2` VALUES ('あいうえお'); INSERT INTO `T3` VALUES ('龔龖龗龞龡'); @@ -34,9 +28,6 @@ INSERT INTO `T6` VALUES ('龔龖龗龞龡'); INSERT INTO `T7` VALUES ('アイウエオ'); INSERT INTO `T8` VALUES ('あいうえお'); INSERT INTO `T9` VALUES ('龔龖龗龞龡'); -INSERT INTO `T10` VALUES ('アイウエオ'); -INSERT INTO `T11` VALUES ('あいうえお'); -INSERT INTO `T12` VALUES ('龔龖龗龞龡'); SELECT INSERT(`C1`,1,1,'カ') FROM `T1`; INSERT(`C1`,1,1,'カ') カイウエオ @@ -712,186 +703,6 @@ INSERT(`C1`,4,2,'丂丂' ) SELECT INSERT(`C1`,5,1,'丂') FROM `T9`; INSERT(`C1`,5,1,'丂') 龔龖龗龞丂 -SELECT INSERT(`C1`,1,1,'カ') FROM `T10`; -INSERT(`C1`,1,1,'カ') -カイウエオ -SELECT INSERT(`C1`,1,2,'カカ') FROM `T10`; -INSERT(`C1`,1,2,'カカ') -カカウエオ -SELECT INSERT(`C1`,1,3,'カカカ') FROM `T10`; -INSERT(`C1`,1,3,'カカカ') -カカカエオ -SELECT INSERT(`C1`,1,4,'カカカカ') FROM `T10`; -INSERT(`C1`,1,4,'カカカカ') -カカカカオ -SELECT INSERT(`C1`,1,5,'カカカカカ') FROM `T10`; -INSERT(`C1`,1,5,'カカカカカ') -カカカカカ -SELECT INSERT(`C1`,2,1,'カ') FROM `T10`; -INSERT(`C1`,2,1,'カ') -アカウエオ -SELECT INSERT(`C1`,2,2,'カカ') FROM `T10`; -INSERT(`C1`,2,2,'カカ') -アカカエオ -SELECT INSERT(`C1`,2,3,'カカカ') FROM `T10`; -INSERT(`C1`,2,3,'カカカ') -アカカカオ -SELECT INSERT(`C1`,2,4,'カカカカ') FROM `T10`; -INSERT(`C1`,2,4,'カカカカ') -アカカカカ -SELECT INSERT(`C1`,3,1,'カ') FROM `T10`; -INSERT(`C1`,3,1,'カ') -アイカエオ -SELECT INSERT(`C1`,3,2,'カカ') FROM `T10`; -INSERT(`C1`,3,2,'カカ') -アイカカオ -SELECT INSERT(`C1`,3,3,'カカカ') FROM `T10`; -INSERT(`C1`,3,3,'カカカ') -アイカカカ -SELECT INSERT(`C1`,4,1,'カ') FROM `T10`; -INSERT(`C1`,4,1,'カ') -アイウカオ -SELECT INSERT(`C1`,4,2,'カカ') FROM `T10`; -INSERT(`C1`,4,2,'カカ') -アイウカカ -SELECT INSERT(`C1`,5,1,'カ') FROM `T10`; -INSERT(`C1`,5,1,'カ') -アイウエカ -SELECT INSERT(`C1`,1,1,'か') FROM `T11`; -INSERT(`C1`,1,1,'か') -かいうえお -SELECT INSERT(`C1`,1,2,'かか') FROM `T11`; -INSERT(`C1`,1,2,'かか') -かかうえお -SELECT INSERT(`C1`,1,3,'かかか') FROM `T11`; -INSERT(`C1`,1,3,'かかか') -かかかえお -SELECT INSERT(`C1`,1,4,'かかかか') FROM `T11`; -INSERT(`C1`,1,4,'かかかか') -かかかかお -SELECT INSERT(`C1`,1,5,'かかかかか') FROM `T11`; -INSERT(`C1`,1,5,'かかかかか') -かかかかか -SELECT INSERT(`C1`,2,1,'か') FROM `T11`; -INSERT(`C1`,2,1,'か') -あかうえお -SELECT INSERT(`C1`,2,2,'かか') FROM `T11`; -INSERT(`C1`,2,2,'かか') -あかかえお -SELECT INSERT(`C1`,2,3,'かかか') FROM `T11`; -INSERT(`C1`,2,3,'かかか') -あかかかお -SELECT INSERT(`C1`,2,4,'かかかか') FROM `T11`; -INSERT(`C1`,2,4,'かかかか') -あかかかか -SELECT INSERT(`C1`,3,1,'か') FROM `T11`; -INSERT(`C1`,3,1,'か') -あいかえお -SELECT INSERT(`C1`,3,2,'かか') FROM `T11`; -INSERT(`C1`,3,2,'かか') -あいかかお -SELECT INSERT(`C1`,3,3,'かかか') FROM `T11`; -INSERT(`C1`,3,3,'かかか') -あいかかか -SELECT INSERT(`C1`,4,1,'か') FROM `T11`; -INSERT(`C1`,4,1,'か') -あいうかお -SELECT INSERT(`C1`,4,2,'かか') FROM `T11`; -INSERT(`C1`,4,2,'かか') -あいうかか -SELECT INSERT(`C1`,5,1,'か') FROM `T11`; -INSERT(`C1`,5,1,'か') -あいうえか -SELECT INSERT(`C1`,1,1,' ') FROM `T11`; -INSERT(`C1`,1,1,' ') - いうえお -SELECT INSERT(`C1`,1,2,' ') FROM `T11`; -INSERT(`C1`,1,2,' ') - うえお -SELECT INSERT(`C1`,1,3,' ') FROM `T11`; -INSERT(`C1`,1,3,' ') - えお -SELECT INSERT(`C1`,1,4,' ') FROM `T11`; -INSERT(`C1`,1,4,' ') - お -SELECT INSERT(`C1`,1,5,' ') FROM `T11`; -INSERT(`C1`,1,5,' ') - -SELECT INSERT(`C1`,2,1,' ') FROM `T11`; -INSERT(`C1`,2,1,' ') -あ うえお -SELECT INSERT(`C1`,2,2,' ') FROM `T11`; -INSERT(`C1`,2,2,' ') -あ えお -SELECT INSERT(`C1`,2,3,' ') FROM `T11`; -INSERT(`C1`,2,3,' ') -あ お -SELECT INSERT(`C1`,2,4,' ') FROM `T11`; -INSERT(`C1`,2,4,' ') -あ -SELECT INSERT(`C1`,3,1,' ') FROM `T11`; -INSERT(`C1`,3,1,' ') -あい えお -SELECT INSERT(`C1`,3,2,' ') FROM `T11`; -INSERT(`C1`,3,2,' ') -あい お -SELECT INSERT(`C1`,3,3,' ') FROM `T11`; -INSERT(`C1`,3,3,' ') -あい -SELECT INSERT(`C1`,4,1,' ') FROM `T11`; -INSERT(`C1`,4,1,' ') -あいう お -SELECT INSERT(`C1`,4,2,' ') FROM `T11`; -INSERT(`C1`,4,2,' ') -あいう -SELECT INSERT(`C1`,5,1,' ') FROM `T11`; -INSERT(`C1`,5,1,' ') -あいうえ -SELECT INSERT(`C1`,1,1,'丂') FROM `T12`; -INSERT(`C1`,1,1,'丂') -丂龖龗龞龡 -SELECT INSERT(`C1`,1,2,'丂丂') FROM `T12`; -INSERT(`C1`,1,2,'丂丂') -丂丂龗龞龡 -SELECT INSERT(`C1`,1,3,'丂丂丂') FROM `T12`; -INSERT(`C1`,1,3,'丂丂丂') -丂丂丂龞龡 -SELECT INSERT(`C1`,1,4,'丂丂丂丂') FROM `T12`; -INSERT(`C1`,1,4,'丂丂丂丂') -丂丂丂丂龡 -SELECT INSERT(`C1`,1,5,'丂丂丂丂丂') FROM `T12`; -INSERT(`C1`,1,5,'丂丂丂丂丂') -丂丂丂丂丂 -SELECT INSERT(`C1`,2,1,'丂') FROM `T12`; -INSERT(`C1`,2,1,'丂') -龔丂龗龞龡 -SELECT INSERT(`C1`,2,2,'丂丂') FROM `T12`; -INSERT(`C1`,2,2,'丂丂') -龔丂丂龞龡 -SELECT INSERT(`C1`,2,3,'丂丂丂') FROM `T12`; -INSERT(`C1`,2,3,'丂丂丂') -龔丂丂丂龡 -SELECT INSERT(`C1`,2,4,'丂丂丂丂') FROM `T12`; -INSERT(`C1`,2,4,'丂丂丂丂') -龔丂丂丂丂 -SELECT INSERT(`C1`,3,1,'丂') FROM `T12`; -INSERT(`C1`,3,1,'丂') -龔龖丂龞龡 -SELECT INSERT(`C1`,3,2,'丂丂') FROM `T12`; -INSERT(`C1`,3,2,'丂丂') -龔龖丂丂龡 -SELECT INSERT(`C1`,3,3,'丂丂丂') FROM `T12`; -INSERT(`C1`,3,3,'丂丂丂') -龔龖丂丂丂 -SELECT INSERT(`C1`,4,1,'丂') FROM `T12`; -INSERT(`C1`,4,1,'丂') -龔龖龗丂龡 -SELECT INSERT(`C1`,4,2,'丂丂') FROM `T12`; -INSERT(`C1`,4,2,'丂丂') -龔龖龗丂丂 -SELECT INSERT(`C1`,5,1,'丂') FROM `T12`; -INSERT(`C1`,5,1,'丂') -龔龖龗龞丂 DROP TABLE `T1`; DROP TABLE `T2`; DROP TABLE `T3`; @@ -901,6 +712,3 @@ DROP TABLE `T6`; DROP TABLE `T7`; DROP TABLE `T8`; DROP TABLE `T9`; -DROP TABLE `T10`; -DROP TABLE `T11`; -DROP TABLE `T12`; |