1 --source include/have_sjis.inc
2 --source include/have_innodb.inc
5 drop table if exists `‚s‚P`;
6 drop table if exists `‚s‚Q`;
7 drop table if exists `‚s‚R`;
8 drop table if exists `‚s‚S`;
9 drop table if exists `‚s‚T`;
10 drop table if exists `‚s‚U`;
11 drop table if exists `‚s‚V`;
12 drop table if exists `‚s‚W`;
13 drop table if exists `‚s‚X`;
14 drop table if exists t1;
18 # Test ENUM values with Japanese characters in sjis encoding
22 SET character_set_database = sjis;
24 CREATE TABLE `‚s‚P` (`‚b‚P` ENUM('±','²','³'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
25 CREATE TABLE `‚s‚Q` (`‚b‚P` ENUM('‚ ','‚¢','‚¤'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
26 CREATE TABLE `‚s‚R` (`‚b‚P` ENUM('ƒ\','�\','•\'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
27 CREATE TABLE `‚s‚S` (`‚b‚P` ENUM('±','²','³'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
28 CREATE TABLE `‚s‚T` (`‚b‚P` ENUM('‚ ','‚¢','‚¤'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
29 CREATE TABLE `‚s‚U` (`‚b‚P` ENUM('ƒ\','�\','•\'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
30 CREATE TABLE `‚s‚V` (`‚b‚P` ENUM('±','²','³'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
31 CREATE TABLE `‚s‚W` (`‚b‚P` ENUM('‚ ','‚¢','‚¤'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
32 CREATE TABLE `‚s‚X` (`‚b‚P` ENUM('ƒ\','�\','•\'), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
34 INSERT INTO `‚s‚P` VALUES ('±'),('²'),('³');
35 INSERT INTO `‚s‚Q` VALUES ('‚ '),('‚¢'),('‚¤');
36 INSERT INTO `‚s‚R` VALUES ('ƒ\'),('�\'),('•\');
37 INSERT INTO `‚s‚S` VALUES ('±'),('²'),('³');
38 INSERT INTO `‚s‚T` VALUES ('‚ '),('‚¢'),('‚¤');
39 INSERT INTO `‚s‚U` VALUES ('ƒ\'),('�\'),('•\');
40 INSERT INTO `‚s‚V` VALUES ('±'),('²'),('³');
41 INSERT INTO `‚s‚W` VALUES ('‚ '),('‚¢'),('‚¤');
42 INSERT INTO `‚s‚X` VALUES ('ƒ\'),('�\'),('•\');
54 SHOW CREATE TABLE `‚s‚P`;
55 SHOW CREATE TABLE `‚s‚Q`;
56 SHOW CREATE TABLE `‚s‚R`;
57 SHOW CREATE TABLE `‚s‚S`;
58 SHOW CREATE TABLE `‚s‚T`;
59 SHOW CREATE TABLE `‚s‚U`;
60 SHOW CREATE TABLE `‚s‚V`;
61 SHOW CREATE TABLE `‚s‚W`;
62 SHOW CREATE TABLE `‚s‚X`;
75 # Test problem with enum values after the colum with NOT NULL restriction
78 ALTER TABLE `‚s‚P` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
79 ALTER TABLE `‚s‚Q` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
80 ALTER TABLE `‚s‚R` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
81 ALTER TABLE `‚s‚S` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
82 ALTER TABLE `‚s‚T` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
83 ALTER TABLE `‚s‚U` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
84 ALTER TABLE `‚s‚V` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
85 ALTER TABLE `‚s‚W` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
86 ALTER TABLE `‚s‚X` ADD `‚b‚Q` CHAR(1) NOT NULL FIRST;
88 SHOW CREATE TABLE `‚s‚P`;
89 SHOW CREATE TABLE `‚s‚Q`;
90 SHOW CREATE TABLE `‚s‚R`;
91 SHOW CREATE TABLE `‚s‚S`;
92 SHOW CREATE TABLE `‚s‚T`;
93 SHOW CREATE TABLE `‚s‚U`;
94 SHOW CREATE TABLE `‚s‚V`;
95 SHOW CREATE TABLE `‚s‚W`;
96 SHOW CREATE TABLE `‚s‚X`;
99 # Test to distinguish 0x9353 and 0x9373
100 # Bug#6206 ENUMs are not case sensitive even if declared BINARY
103 CREATE TABLE t1(c1 enum('“S','“s')) default character set = sjis;
104 INSERT INTO t1 VALUES('“S'),('“s');
105 SELECT * FROM t1 WHERE c1 LIKE '“S';