--source include/have_ujis.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 `�ԣ�`; 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 = heap; CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = heap; CREATE TABLE `�ԣ���` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb; CREATE TABLE `�ԣ���` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = bdb; 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 ('���'),('���'),('���'); 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 `�ԣ�`; 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 `�ԣ�`; SHOW CREATE TABLE `�ԣ���`; SHOW CREATE TABLE `�ԣ���`; SHOW CREATE TABLE `�ԣ���`; DESC `�ԣ�`; DESC `�ԣ�`; DESC `�ԣ�`; 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; 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 `�ԣ�`; SHOW CREATE TABLE `�ԣ���`; SHOW CREATE TABLE `�ԣ���`; SHOW CREATE TABLE `�ԣ���`; DESC `�ԣ�`; DESC `�ԣ�`; DESC `�ԣ�`; 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 `�ԣ�`; DROP TABLE `�ԣ���`; DROP TABLE `�ԣ���`; DROP TABLE `�ԣ���`;