2
drop table if exists `T1`;
3
drop table if exists `T2`;
4
drop table if exists `T3`;
5
drop table if exists `T4`;
6
drop table if exists `T5`;
7
drop table if exists `T6`;
8
drop table if exists `T7`;
9
drop table if exists `T8`;
10
drop table if exists `T9`;
11
drop table if exists `T10`;
12
drop table if exists `T11`;
13
drop table if exists `T12`;
17
# Test ENUM values with Japanese characters in utf8 encoding
20
CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = innodb;
21
CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = innodb;
22
CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = innodb;
23
CREATE TEMPORARY TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = myisam;
24
CREATE TEMPORARY TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = myisam;
25
CREATE TEMPORARY TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = myisam;
26
CREATE TEMPORARY TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = MEMORY;
27
CREATE TEMPORARY TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = MEMORY;
28
CREATE TEMPORARY TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = MEMORY;
30
INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
31
INSERT INTO `T2` VALUES ('あ'),('い'),('う');
32
INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
33
INSERT INTO `T4` VALUES ('ア'),('イ'),('ウ');
34
INSERT INTO `T5` VALUES ('あ'),('い'),('う');
35
INSERT INTO `T6` VALUES ('龔'),('龖'),('龗');
36
INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
37
INSERT INTO `T8` VALUES ('あ'),('い'),('う');
38
INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
50
SHOW CREATE TABLE `T1`;
51
SHOW CREATE TABLE `T2`;
52
SHOW CREATE TABLE `T3`;
53
SHOW CREATE TABLE `T4`;
54
SHOW CREATE TABLE `T5`;
55
SHOW CREATE TABLE `T6`;
56
SHOW CREATE TABLE `T7`;
57
SHOW CREATE TABLE `T8`;
58
SHOW CREATE TABLE `T9`;
71
# Test problem with enum values after the colum with NOT NULL restriction
74
ALTER TABLE `T1` ADD `C2` CHAR(1) NOT NULL FIRST;
75
ALTER TABLE `T2` ADD `C2` CHAR(1) NOT NULL FIRST;
76
ALTER TABLE `T3` ADD `C2` CHAR(1) NOT NULL FIRST;
77
ALTER TABLE `T4` ADD `C2` CHAR(1) NOT NULL FIRST;
78
ALTER TABLE `T5` ADD `C2` CHAR(1) NOT NULL FIRST;
79
ALTER TABLE `T6` ADD `C2` CHAR(1) NOT NULL FIRST;
80
ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
81
ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
82
ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
84
SHOW CREATE TABLE `T1`;
85
SHOW CREATE TABLE `T2`;
86
SHOW CREATE TABLE `T3`;
87
SHOW CREATE TABLE `T4`;
88
SHOW CREATE TABLE `T5`;
89
SHOW CREATE TABLE `T6`;
90
SHOW CREATE TABLE `T7`;
91
SHOW CREATE TABLE `T8`;
92
SHOW CREATE TABLE `T9`;