1
--source include/have_ucs2.inc
2
--source include/have_innodb.inc
4
# half-with kana is not handled correctly in 4.1
6
# It will be fixed in 5.0
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 `�ԣ�`;
14
drop table if exists `�ԣ�`;
15
drop table if exists `�ԣ�`;
16
drop table if exists `�ԣ�`;
17
drop table if exists `�ԣ�`;
21
# Test ENUM values with Japanese characters in ucs2 encoding
25
SET character_set_database = ucs2;
26
SET collation_connection = ucs2_general_ci;
28
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
29
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
30
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = innodb;
31
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
32
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
33
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = myisam;
34
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
35
CREATE TABLE `�ԣ�` (`�ã�` ENUM('��','��','��'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
36
CREATE TABLE `�ԣ�` (`�ã�` ENUM('���','���','���'), INDEX(`�ã�`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
38
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
39
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
40
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
41
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
42
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
43
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
44
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
45
INSERT INTO `�ԣ�` VALUES ('��'),('��'),('��');
46
INSERT INTO `�ԣ�` VALUES ('���'),('���'),('���');
58
SHOW CREATE TABLE `�ԣ�`;
59
SHOW CREATE TABLE `�ԣ�`;
60
SHOW CREATE TABLE `�ԣ�`;
61
SHOW CREATE TABLE `�ԣ�`;
62
SHOW CREATE TABLE `�ԣ�`;
63
SHOW CREATE TABLE `�ԣ�`;
64
SHOW CREATE TABLE `�ԣ�`;
65
SHOW CREATE TABLE `�ԣ�`;
66
SHOW CREATE TABLE `�ԣ�`;
79
# Test problem with enum values after the colum with NOT NULL restriction
80
# Bug#7302 UCS2 data in ENUM field get truncated when new column is added
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;
86
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
87
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
88
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
89
ALTER TABLE `�ԣ�` ADD `�ã�` CHAR(1) NOT NULL FIRST;
91
SHOW CREATE TABLE `�ԣ�`;
92
SHOW CREATE TABLE `�ԣ�`;
93
SHOW CREATE TABLE `�ԣ�`;
94
SHOW CREATE TABLE `�ԣ�`;
95
SHOW CREATE TABLE `�ԣ�`;
96
SHOW CREATE TABLE `�ԣ�`;
97
SHOW CREATE TABLE `�ԣ�`;
98
SHOW CREATE TABLE `�ԣ�`;
99
SHOW CREATE TABLE `�ԣ�`;