diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_left_utf8.test')
| -rw-r--r-- | mysql-test/suite/jp/t/jp_left_utf8.test | 42 |
1 files changed, 6 insertions, 36 deletions
diff --git a/mysql-test/suite/jp/t/jp_left_utf8.test b/mysql-test/suite/jp/t/jp_left_utf8.test index f9c99718e0f..0f77c1709d4 100644 --- a/mysql-test/suite/jp/t/jp_left_utf8.test +++ b/mysql-test/suite/jp/t/jp_left_utf8.test @@ -1,3 +1,5 @@ +--source include/have_utf8.inc +--source include/have_innodb.inc --disable_warnings drop table if exists `Ｔ１`; drop table if exists `Ｔ２`; @@ -8,9 +10,6 @@ drop table if exists `Ｔ６`; drop table if exists `Ｔ７`; drop table if exists `Ｔ８`; drop table if exists `Ｔ９`; -drop table if exists `Ｔ１０`; -drop table if exists `Ｔ１１`; -drop table if exists `Ｔ１２`; --enable_warnings # @@ -26,12 +25,9 @@ CREATE TABLE `Ｔ３` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 CREATE TABLE `Ｔ４` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam; CREATE TABLE `Ｔ５` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam; CREATE TABLE `Ｔ６` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam; -CREATE TABLE `Ｔ７` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `Ｔ８` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `Ｔ９` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap; -CREATE TABLE `Ｔ１０` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb; -CREATE TABLE `Ｔ１１` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb; -CREATE TABLE `Ｔ１２` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb; +CREATE TABLE `Ｔ７` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `Ｔ８` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY; +CREATE TABLE `Ｔ９` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY; INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),(''); INSERT INTO `Ｔ２` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),(''); @@ -42,9 +38,6 @@ INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),( INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),(''); INSERT INTO `Ｔ８` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),(''); INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),(''); -INSERT INTO `Ｔ１０` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),(''); -INSERT INTO `Ｔ１１` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),(''); -INSERT INTO `Ｔ１２` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),(''); #InnoDB SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ１`; @@ -86,7 +79,7 @@ SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ６`; SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ６`; SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ６`; -#HEAP +#MEMORY SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ７`; SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ７`; SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ７`; @@ -106,26 +99,6 @@ SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ９`; SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ９`; SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ９`; -#BDB -SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ１０`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ１１`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ１２`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ１２`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ１２`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ１２`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ１２`; -SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ１２`; - DROP TABLE `Ｔ１`; DROP TABLE `Ｔ２`; DROP TABLE `Ｔ３`; @@ -135,6 +108,3 @@ DROP TABLE `Ｔ６`; DROP TABLE `Ｔ７`; DROP TABLE `Ｔ８`; DROP TABLE `Ｔ９`; -DROP TABLE `Ｔ１０`; -DROP TABLE `Ｔ１１`; -DROP TABLE `Ｔ１２`; |