1 files changed, 119 insertions, 0 deletions

diff --git a/mysql-test/suite/jp/t/jp_enum_ujis.test b/mysql-test/suite/jp/t/jp_enum_ujis.test
new file mode 100644
index 00000000..10e8ad55
--- /dev/null
+++ b/mysql-test/suite/jp/t/jp_enum_ujis.test
@@ -0,0 +1,119 @@
+#Server variable option 'lower_case_table_names' sets '0' as default value
+#in case sensitive filesystem. Using 'lower_case_table_names=0' in case of
+#insensitive filsystem is not allowed.
+-- source include/have_case_sensitive_file_system.inc
+--source include/have_ujis.inc
+--source include/have_innodb.inc
+
+--disable_warnings
+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 `｣ﾔ｣ｷ`;
+drop table if exists `｣ﾔ｣ｸ`;
+drop table if exists `｣ﾔ｣ｹ`;
+--enable_warnings
+
+#
+# Test ENUM values with Japanese characters in ujis encoding
+#
+
+SET NAMES ujis;
+SET character_set_database = ujis;
+
+CREATE TABLE `｣ﾔ｣ｱ` (`｣ﾃ｣ｱ` ENUM('竺','軸','宍'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｲ` (`｣ﾃ｣ｱ` ENUM('､｢','､､','､ｦ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｳ` (`｣ﾃ｣ｱ` ENUM('常ﾜ','常ﾝ','常ﾞ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = innodb;
+CREATE TABLE `｣ﾔ｣ｴ` (`｣ﾃ｣ｱ` ENUM('竺','軸','宍'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｵ` (`｣ﾃ｣ｱ` ENUM('､｢','､､','､ｦ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｶ` (`｣ﾃ｣ｱ` ENUM('常ﾜ','常ﾝ','常ﾞ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = myisam;
+CREATE TABLE `｣ﾔ｣ｷ` (`｣ﾃ｣ｱ` ENUM('竺','軸','宍'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;
+CREATE TABLE `｣ﾔ｣ｸ` (`｣ﾃ｣ｱ` ENUM('､｢','､､','､ｦ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;
+CREATE TABLE `｣ﾔ｣ｹ` (`｣ﾃ｣ｱ` ENUM('常ﾜ','常ﾝ','常ﾞ'), INDEX(`｣ﾃ｣ｱ`)) DEFAULT CHARSET = ujis engine = MEMORY;
+
+INSERT INTO `｣ﾔ｣ｱ` VALUES ('竺'),('軸'),('宍');
+INSERT INTO `｣ﾔ｣ｲ` VALUES ('､｢'),('､､'),('､ｦ');
+INSERT INTO `｣ﾔ｣ｳ` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ');
+INSERT INTO `｣ﾔ｣ｴ` VALUES ('竺'),('軸'),('宍');
+INSERT INTO `｣ﾔ｣ｵ` VALUES ('､｢'),('､､'),('､ｦ');
+INSERT INTO `｣ﾔ｣ｶ` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ');
+INSERT INTO `｣ﾔ｣ｷ` VALUES ('竺'),('軸'),('宍');
+INSERT INTO `｣ﾔ｣ｸ` VALUES ('､｢'),('､､'),('､ｦ');
+INSERT INTO `｣ﾔ｣ｹ` VALUES ('常ﾜ'),('常ﾝ'),('常ﾞ');
+
+SELECT * FROM `｣ﾔ｣ｱ`;
+SELECT * FROM `｣ﾔ｣ｲ`;
+SELECT * FROM `｣ﾔ｣ｳ`;
+SELECT * FROM `｣ﾔ｣ｴ`;
+SELECT * FROM `｣ﾔ｣ｵ`;
+SELECT * FROM `｣ﾔ｣ｶ`;
+SELECT * FROM `｣ﾔ｣ｷ`;
+SELECT * FROM `｣ﾔ｣ｸ`;
+SELECT * FROM `｣ﾔ｣ｹ`;
+
+SHOW CREATE TABLE `｣ﾔ｣ｱ`;
+SHOW CREATE TABLE `｣ﾔ｣ｲ`;
+SHOW CREATE TABLE `｣ﾔ｣ｳ`;
+SHOW CREATE TABLE `｣ﾔ｣ｴ`;
+SHOW CREATE TABLE `｣ﾔ｣ｵ`;
+SHOW CREATE TABLE `｣ﾔ｣ｶ`;
+SHOW CREATE TABLE `｣ﾔ｣ｷ`;
+SHOW CREATE TABLE `｣ﾔ｣ｸ`;
+SHOW CREATE TABLE `｣ﾔ｣ｹ`;
+
+DESC `｣ﾔ｣ｱ`;
+DESC `｣ﾔ｣ｲ`;
+DESC `｣ﾔ｣ｳ`;
+DESC `｣ﾔ｣ｴ`;
+DESC `｣ﾔ｣ｵ`;
+DESC `｣ﾔ｣ｶ`;
+DESC `｣ﾔ｣ｷ`;
+DESC `｣ﾔ｣ｸ`;
+DESC `｣ﾔ｣ｹ`;
+
+#
+# Test problem with enum values after the colum with  NOT NULL restriction
+#
+
+ALTER TABLE `｣ﾔ｣ｱ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｲ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｳ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｴ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｵ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｶ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｷ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｸ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+ALTER TABLE `｣ﾔ｣ｹ` ADD `｣ﾃ｣ｲ` CHAR(1) NOT NULL FIRST;
+
+SHOW CREATE TABLE `｣ﾔ｣ｱ`;
+SHOW CREATE TABLE `｣ﾔ｣ｲ`;
+SHOW CREATE TABLE `｣ﾔ｣ｳ`;
+SHOW CREATE TABLE `｣ﾔ｣ｴ`;
+SHOW CREATE TABLE `｣ﾔ｣ｵ`;
+SHOW CREATE TABLE `｣ﾔ｣ｶ`;
+SHOW CREATE TABLE `｣ﾔ｣ｷ`;
+SHOW CREATE TABLE `｣ﾔ｣ｸ`;
+SHOW CREATE TABLE `｣ﾔ｣ｹ`;
+
+DESC `｣ﾔ｣ｱ`;
+DESC `｣ﾔ｣ｲ`;
+DESC `｣ﾔ｣ｳ`;
+DESC `｣ﾔ｣ｴ`;
+DESC `｣ﾔ｣ｵ`;
+DESC `｣ﾔ｣ｶ`;
+DESC `｣ﾔ｣ｷ`;
+DESC `｣ﾔ｣ｸ`;
+DESC `｣ﾔ｣ｹ`;
+
+DROP TABLE `｣ﾔ｣ｱ`;
+DROP TABLE `｣ﾔ｣ｲ`;
+DROP TABLE `｣ﾔ｣ｳ`;
+DROP TABLE `｣ﾔ｣ｴ`;
+DROP TABLE `｣ﾔ｣ｵ`;
+DROP TABLE `｣ﾔ｣ｶ`;
+DROP TABLE `｣ﾔ｣ｷ`;
+DROP TABLE `｣ﾔ｣ｸ`;
+DROP TABLE `｣ﾔ｣ｹ`;