1
--source include/have_utf8.inc
2
--source include/have_innodb.inc
4
drop table if exists `T1`;
5
drop table if exists `T2`;
6
drop table if exists `T3`;
7
drop table if exists `T4`;
8
drop table if exists `T5`;
9
drop table if exists `T6`;
10
drop table if exists `T7`;
11
drop table if exists `T8`;
12
drop table if exists `T9`;
16
# Test ENUM values with Japanese characters in utf8 encoding
20
SET character_set_database = utf8;
22
CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
23
CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24
CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
25
CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
26
CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27
CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
28
CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
29
CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
30
CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
32
INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
33
INSERT INTO `T2` VALUES ('あ'),('い'),('う');
34
INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
35
INSERT INTO `T4` VALUES ('ア'),('イ'),('ウ');
36
INSERT INTO `T5` VALUES ('あ'),('い'),('う');
37
INSERT INTO `T6` VALUES ('龔'),('龖'),('龗');
38
INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
39
INSERT INTO `T8` VALUES ('あ'),('い'),('う');
40
INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
52
SHOW CREATE TABLE `T1`;
53
SHOW CREATE TABLE `T2`;
54
SHOW CREATE TABLE `T3`;
55
SHOW CREATE TABLE `T4`;
56
SHOW CREATE TABLE `T5`;
57
SHOW CREATE TABLE `T6`;
58
SHOW CREATE TABLE `T7`;
59
SHOW CREATE TABLE `T8`;
60
SHOW CREATE TABLE `T9`;
73
# Test problem with enum values after the colum with NOT NULL restriction
76
ALTER TABLE `T1` ADD `C2` CHAR(1) NOT NULL FIRST;
77
ALTER TABLE `T2` ADD `C2` CHAR(1) NOT NULL FIRST;
78
ALTER TABLE `T3` ADD `C2` CHAR(1) NOT NULL FIRST;
79
ALTER TABLE `T4` ADD `C2` CHAR(1) NOT NULL FIRST;
80
ALTER TABLE `T5` ADD `C2` CHAR(1) NOT NULL FIRST;
81
ALTER TABLE `T6` ADD `C2` CHAR(1) NOT NULL FIRST;
82
ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
83
ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
84
ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
86
SHOW CREATE TABLE `T1`;
87
SHOW CREATE TABLE `T2`;
88
SHOW CREATE TABLE `T3`;
89
SHOW CREATE TABLE `T4`;
90
SHOW CREATE TABLE `T5`;
91
SHOW CREATE TABLE `T6`;
92
SHOW CREATE TABLE `T7`;
93
SHOW CREATE TABLE `T8`;
94
SHOW CREATE TABLE `T9`;