1
--source include/have_ujis.inc
2
--source include/have_innodb.inc
5
drop table if exists `�ԣ�`;
6
drop table if exists `�ԣ�`;
7
drop table if exists `�ԣ�`;
8
drop table if exists `�ԣ�`;
9
drop table if exists `�ԣ�`;
10
drop table if exists `�ԣ�`;
11
drop table if exists `�ԣ�`;
12
drop table if exists `�ԣ�`;
13
drop table if exists `�ԣ�`;
17
# Test ENUM values with Japanese characters in ujis encoding
21
SET character_set_database = ujis;
23
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
24
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
25
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb;
26
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
27
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
28
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam;
29
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
30
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
31
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY;
33
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
34
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
35
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
36
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
37
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
38
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
39
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
40
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
41
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
53
SHOW CREATE TABLE `�ԣ�`;
54
SHOW CREATE TABLE `�ԣ�`;
55
SHOW CREATE TABLE `�ԣ�`;
56
SHOW CREATE TABLE `�ԣ�`;
57
SHOW CREATE TABLE `�ԣ�`;
58
SHOW CREATE TABLE `�ԣ�`;
59
SHOW CREATE TABLE `�ԣ�`;
60
SHOW CREATE TABLE `�ԣ�`;
61
SHOW CREATE TABLE `�ԣ�`;
74
# Test problem with enum values after the colum with NOT NULL restriction
77
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
78
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
79
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
80
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
81
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
82
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
83
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
84
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
85
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
87
SHOW CREATE TABLE `�ԣ�`;
88
SHOW CREATE TABLE `�ԣ�`;
89
SHOW CREATE TABLE `�ԣ�`;
90
SHOW CREATE TABLE `�ԣ�`;
91
SHOW CREATE TABLE `�ԣ�`;
92
SHOW CREATE TABLE `�ԣ�`;
93
SHOW CREATE TABLE `�ԣ�`;
94
SHOW CREATE TABLE `�ԣ�`;
95
SHOW CREATE TABLE `�ԣ�`;