diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_instr_utf8.test')
| -rw-r--r-- | mysql-test/suite/jp/t/jp_instr_utf8.test | 40 |
1 files changed, 6 insertions, 34 deletions
diff --git a/mysql-test/suite/jp/t/jp_instr_utf8.test b/mysql-test/suite/jp/t/jp_instr_utf8.test index b25b72bc8d0..27c2cb24e6d 100644 --- a/mysql-test/suite/jp/t/jp_instr_utf8.test +++ b/mysql-test/suite/jp/t/jp_instr_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,7 +10,6 @@ drop table if exists `Ｔ６`; drop table if exists `Ｔ７`; drop table if exists `Ｔ８`; drop table if exists `Ｔ９`; -drop table if exists `Ｔ１０`; --enable_warnings # @@ -24,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 ('あいうえお'); @@ -40,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 INSTR(`Ｃ１`,'ｱ') from `Ｔ１`; @@ -84,7 +79,7 @@ SELECT INSTR(`Ｃ１`,'龞') from `Ｔ６`; SELECT INSTR(`Ｃ１`,'龡') from `Ｔ６`; SELECT INSTR(`Ｃ１`,'丂') from `Ｔ６`; -#HEAP +#MEMORY SELECT INSTR(`Ｃ１`,'ｱ') from `Ｔ７`; SELECT INSTR(`Ｃ１`,'ｲ') from `Ｔ７`; SELECT INSTR(`Ｃ１`,'ｳ') from `Ｔ７`; @@ -104,26 +99,6 @@ SELECT INSTR(`Ｃ１`,'龞') from `Ｔ９`; SELECT INSTR(`Ｃ１`,'龡') from `Ｔ９`; SELECT INSTR(`Ｃ１`,'丂') from `Ｔ９`; -#BDB -SELECT INSTR(`Ｃ１`,'ｱ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'ｲ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'ｳ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'ｴ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'ｵ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'ﾝ') from `Ｔ１０`; -SELECT INSTR(`Ｃ１`,'あ') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'い') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'う') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'え') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'お') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'ん') from `Ｔ１１`; -SELECT INSTR(`Ｃ１`,'龔') from `Ｔ１２`; -SELECT INSTR(`Ｃ１`,'龖') from `Ｔ１２`; -SELECT INSTR(`Ｃ１`,'龗') from `Ｔ１２`; -SELECT INSTR(`Ｃ１`,'龞') from `Ｔ１２`; -SELECT INSTR(`Ｃ１`,'龡') from `Ｔ１２`; -SELECT INSTR(`Ｃ１`,'丂') from `Ｔ１２`; - DROP TABLE `Ｔ１`; DROP TABLE `Ｔ２`; DROP TABLE `Ｔ３`; @@ -133,6 +108,3 @@ DROP TABLE `Ｔ６`; DROP TABLE `Ｔ７`; DROP TABLE `Ｔ８`; DROP TABLE `Ｔ９`; -DROP TABLE `Ｔ１０`; -DROP TABLE `Ｔ１１`; -DROP TABLE `Ｔ１２`; |