78
78
T1 CREATE TABLE `T1` (
79
79
`C1` ENUM('ア','イ','ウ') DEFAULT NULL,
80
KEY `C1` (`C1`) USING BTREE
81
81
) ENGINE=InnoDB COLLATE = utf8_general_ci
82
82
SHOW CREATE TABLE `T2`;
84
84
T2 CREATE TABLE `T2` (
85
85
`C1` ENUM('あ','い','う') DEFAULT NULL,
86
KEY `C1` (`C1`) USING BTREE
87
87
) ENGINE=InnoDB COLLATE = utf8_general_ci
88
88
SHOW CREATE TABLE `T3`;
90
90
T3 CREATE TABLE `T3` (
91
91
`C1` ENUM('龔','龖','龗') DEFAULT NULL,
92
KEY `C1` (`C1`) USING BTREE
93
93
) ENGINE=InnoDB COLLATE = utf8_general_ci
94
94
SHOW CREATE TABLE `T4`;
96
96
T4 CREATE TEMPORARY TABLE `T4` (
97
97
`C1` ENUM('ア','イ','ウ') DEFAULT NULL,
98
KEY `C1` (`C1`) USING BTREE
99
99
) ENGINE=MyISAM COLLATE = utf8_general_ci
100
100
SHOW CREATE TABLE `T5`;
101
101
Table Create Table
102
102
T5 CREATE TEMPORARY TABLE `T5` (
103
103
`C1` ENUM('あ','い','う') DEFAULT NULL,
104
KEY `C1` (`C1`) USING BTREE
105
105
) ENGINE=MyISAM COLLATE = utf8_general_ci
106
106
SHOW CREATE TABLE `T6`;
107
107
Table Create Table
108
108
T6 CREATE TEMPORARY TABLE `T6` (
109
109
`C1` ENUM('龔','龖','龗') DEFAULT NULL,
110
KEY `C1` (`C1`) USING BTREE
111
111
) ENGINE=MyISAM COLLATE = utf8_general_ci
112
112
SHOW CREATE TABLE `T7`;
113
113
Table Create Table
114
114
T7 CREATE TEMPORARY TABLE `T7` (
115
115
`C1` ENUM('ア','イ','ウ') DEFAULT NULL,
116
KEY `C1` (`C1`) USING HASH
117
117
) ENGINE=MEMORY COLLATE = utf8_general_ci
118
118
SHOW CREATE TABLE `T8`;
119
119
Table Create Table
120
120
T8 CREATE TEMPORARY TABLE `T8` (
121
121
`C1` ENUM('あ','い','う') DEFAULT NULL,
122
KEY `C1` (`C1`) USING HASH
123
123
) ENGINE=MEMORY COLLATE = utf8_general_ci
124
124
SHOW CREATE TABLE `T9`;
125
125
Table Create Table
126
126
T9 CREATE TEMPORARY TABLE `T9` (
127
127
`C1` ENUM('龔','龖','龗') DEFAULT NULL,
128
KEY `C1` (`C1`) USING HASH
129
129
) ENGINE=MEMORY COLLATE = utf8_general_ci
130
130
ALTER TABLE `T1` ADD `C2` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
131
131
ALTER TABLE `T2` ADD `C2` CHAR(1) DEFAULT "Y" NOT NULL FIRST;