1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
--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 `｣ﾔ｣ｹ`;
|
