10
10
drop table if exists `T10`;
11
11
drop table if exists `T11`;
12
12
drop table if exists `T12`;
14
SET character_set_database = utf8;
15
CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
16
CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
17
CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18
CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
19
CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
20
CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
21
CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
22
CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
23
CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
24
CREATE TABLE `T10` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
25
CREATE TABLE `T11` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
26
CREATE TABLE `T12` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = bdb;
13
CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = innodb;
14
CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = innodb;
15
CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = innodb;
16
CREATE TEMPORARY TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = myisam;
17
CREATE TEMPORARY TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = myisam;
18
CREATE TEMPORARY TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = myisam;
19
CREATE TEMPORARY TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) engine = MEMORY;
20
CREATE TEMPORARY TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) engine = MEMORY;
21
CREATE TEMPORARY TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) engine = MEMORY;
27
22
INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
28
23
INSERT INTO `T2` VALUES ('あ'),('い'),('う');
29
24
INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
99
76
SHOW CREATE TABLE `T1`;
100
77
Table Create Table
101
T1 CREATE TABLE `T1` (
102
`C1` enum('ア','イ','ウ') default NULL,
78
T1 CREATE TABLE `t1` (
79
`C1` enum('ア','イ','ウ') DEFAULT NULL,
104
) ENGINE=InnoDB DEFAULT CHARSET=utf8
105
82
SHOW CREATE TABLE `T2`;
106
83
Table Create Table
107
T2 CREATE TABLE `T2` (
108
`C1` enum('あ','い','う') default NULL,
84
T2 CREATE TABLE `t2` (
85
`C1` enum('あ','い','う') DEFAULT NULL,
110
) ENGINE=InnoDB DEFAULT CHARSET=utf8
111
88
SHOW CREATE TABLE `T3`;
112
89
Table Create Table
113
T3 CREATE TABLE `T3` (
114
`C1` enum('龔','龖','龗') default NULL,
90
T3 CREATE TABLE `t3` (
91
`C1` enum('龔','龖','龗') DEFAULT NULL,
116
) ENGINE=InnoDB DEFAULT CHARSET=utf8
117
94
SHOW CREATE TABLE `T4`;
118
95
Table Create Table
119
T4 CREATE TABLE `T4` (
120
`C1` enum('ア','イ','ウ') default NULL,
96
T4 CREATE TEMPORARY TABLE `t4` (
97
`C1` enum('ア','イ','ウ') DEFAULT NULL,
122
) ENGINE=MyISAM DEFAULT CHARSET=utf8
123
100
SHOW CREATE TABLE `T5`;
124
101
Table Create Table
125
T5 CREATE TABLE `T5` (
126
`C1` enum('あ','い','う') default NULL,
102
T5 CREATE TEMPORARY TABLE `t5` (
103
`C1` enum('あ','い','う') DEFAULT NULL,
128
) ENGINE=MyISAM DEFAULT CHARSET=utf8
129
106
SHOW CREATE TABLE `T6`;
130
107
Table Create Table
131
T6 CREATE TABLE `T6` (
132
`C1` enum('龔','龖','龗') default NULL,
108
T6 CREATE TEMPORARY TABLE `t6` (
109
`C1` enum('龔','龖','龗') DEFAULT NULL,
134
) ENGINE=MyISAM DEFAULT CHARSET=utf8
135
112
SHOW CREATE TABLE `T7`;
136
113
Table Create Table
137
T7 CREATE TABLE `T7` (
138
`C1` enum('ア','イ','ウ') default NULL,
114
T7 CREATE TEMPORARY TABLE `t7` (
115
`C1` enum('ア','イ','ウ') DEFAULT NULL,
140
) ENGINE=MEMORY DEFAULT CHARSET=utf8
141
118
SHOW CREATE TABLE `T8`;
142
119
Table Create Table
143
T8 CREATE TABLE `T8` (
144
`C1` enum('あ','い','う') default NULL,
120
T8 CREATE TEMPORARY TABLE `t8` (
121
`C1` enum('あ','い','う') DEFAULT NULL,
146
) ENGINE=MEMORY DEFAULT CHARSET=utf8
147
124
SHOW CREATE TABLE `T9`;
148
125
Table Create Table
149
T9 CREATE TABLE `T9` (
150
`C1` enum('龔','龖','龗') default NULL,
152
) ENGINE=MEMORY DEFAULT CHARSET=utf8
153
SHOW CREATE TABLE `T10`;
155
T10 CREATE TABLE `T10` (
156
`C1` enum('ア','イ','ウ') default NULL,
158
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
159
SHOW CREATE TABLE `T11`;
161
T11 CREATE TABLE `T11` (
162
`C1` enum('あ','い','う') default NULL,
164
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
165
SHOW CREATE TABLE `T12`;
167
T12 CREATE TABLE `T12` (
168
`C1` enum('龔','龖','龗') default NULL,
170
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
126
T9 CREATE TEMPORARY TABLE `t9` (
127
`C1` enum('龔','龖','龗') DEFAULT NULL,
172
131
Field Type Null Key Default Extra
173
132
C1 enum('ア','イ','ウ') YES MUL NULL
213
163
ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
214
164
ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
215
165
ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
216
ALTER TABLE `T10` ADD `C2` CHAR(1) NOT NULL FIRST;
217
ALTER TABLE `T11` ADD `C2` CHAR(1) NOT NULL FIRST;
218
ALTER TABLE `T12` ADD `C2` CHAR(1) NOT NULL FIRST;
219
166
SHOW CREATE TABLE `T1`;
220
167
Table Create Table
221
T1 CREATE TABLE `T1` (
222
`C2` char(1) NOT NULL default '',
223
`C1` enum('ア','イ','ウ') default NULL,
168
T1 CREATE TABLE `t1` (
169
`C2` varchar(1) NOT NULL,
170
`C1` enum('ア','イ','ウ') DEFAULT NULL,
225
) ENGINE=InnoDB DEFAULT CHARSET=utf8
226
173
SHOW CREATE TABLE `T2`;
227
174
Table Create Table
228
T2 CREATE TABLE `T2` (
229
`C2` char(1) NOT NULL default '',
230
`C1` enum('あ','い','う') default NULL,
175
T2 CREATE TABLE `t2` (
176
`C2` varchar(1) NOT NULL,
177
`C1` enum('あ','い','う') DEFAULT NULL,
232
) ENGINE=InnoDB DEFAULT CHARSET=utf8
233
180
SHOW CREATE TABLE `T3`;
234
181
Table Create Table
235
T3 CREATE TABLE `T3` (
236
`C2` char(1) NOT NULL default '',
237
`C1` enum('龔','龖','龗') default NULL,
182
T3 CREATE TABLE `t3` (
183
`C2` varchar(1) NOT NULL,
184
`C1` enum('龔','龖','龗') DEFAULT NULL,
239
) ENGINE=InnoDB DEFAULT CHARSET=utf8
240
187
SHOW CREATE TABLE `T4`;
241
188
Table Create Table
242
T4 CREATE TABLE `T4` (
243
`C2` char(1) NOT NULL default '',
244
`C1` enum('ア','イ','ウ') default NULL,
189
T4 CREATE TEMPORARY TABLE `t4` (
190
`C2` varchar(1) NOT NULL,
191
`C1` enum('ア','イ','ウ') DEFAULT NULL,
246
) ENGINE=MyISAM DEFAULT CHARSET=utf8
247
194
SHOW CREATE TABLE `T5`;
248
195
Table Create Table
249
T5 CREATE TABLE `T5` (
250
`C2` char(1) NOT NULL default '',
251
`C1` enum('あ','い','う') default NULL,
196
T5 CREATE TEMPORARY TABLE `t5` (
197
`C2` varchar(1) NOT NULL,
198
`C1` enum('あ','い','う') DEFAULT NULL,
253
) ENGINE=MyISAM DEFAULT CHARSET=utf8
254
201
SHOW CREATE TABLE `T6`;
255
202
Table Create Table
256
T6 CREATE TABLE `T6` (
257
`C2` char(1) NOT NULL default '',
258
`C1` enum('龔','龖','龗') default NULL,
203
T6 CREATE TEMPORARY TABLE `t6` (
204
`C2` varchar(1) NOT NULL,
205
`C1` enum('龔','龖','龗') DEFAULT NULL,
260
) ENGINE=MyISAM DEFAULT CHARSET=utf8
261
208
SHOW CREATE TABLE `T7`;
262
209
Table Create Table
263
T7 CREATE TABLE `T7` (
264
`C2` char(1) NOT NULL default '',
265
`C1` enum('ア','イ','ウ') default NULL,
210
T7 CREATE TEMPORARY TABLE `t7` (
211
`C2` varchar(1) NOT NULL,
212
`C1` enum('ア','イ','ウ') DEFAULT NULL,
267
) ENGINE=MEMORY DEFAULT CHARSET=utf8
268
215
SHOW CREATE TABLE `T8`;
269
216
Table Create Table
270
T8 CREATE TABLE `T8` (
271
`C2` char(1) NOT NULL default '',
272
`C1` enum('あ','い','う') default NULL,
217
T8 CREATE TEMPORARY TABLE `t8` (
218
`C2` varchar(1) NOT NULL,
219
`C1` enum('あ','い','う') DEFAULT NULL,
274
) ENGINE=MEMORY DEFAULT CHARSET=utf8
275
222
SHOW CREATE TABLE `T9`;
276
223
Table Create Table
277
T9 CREATE TABLE `T9` (
278
`C2` char(1) NOT NULL default '',
279
`C1` enum('龔','龖','龗') default NULL,
281
) ENGINE=MEMORY DEFAULT CHARSET=utf8
282
SHOW CREATE TABLE `T10`;
284
T10 CREATE TABLE `T10` (
285
`C2` char(1) NOT NULL default '',
286
`C1` enum('ア','イ','ウ') default NULL,
288
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
289
SHOW CREATE TABLE `T11`;
291
T11 CREATE TABLE `T11` (
292
`C2` char(1) NOT NULL default '',
293
`C1` enum('あ','い','う') default NULL,
295
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
296
SHOW CREATE TABLE `T12`;
298
T12 CREATE TABLE `T12` (
299
`C2` char(1) NOT NULL default '',
300
`C1` enum('龔','龖','龗') default NULL,
302
) ENGINE=BerkeleyDB DEFAULT CHARSET=utf8
224
T9 CREATE TEMPORARY TABLE `t9` (
225
`C2` varchar(1) NOT NULL,
226
`C1` enum('龔','龖','龗') DEFAULT NULL,
304
230
Field Type Null Key Default Extra
231
C2 varchar(1) NO NULL
306
232
C1 enum('ア','イ','ウ') YES MUL NULL
308
234
Field Type Null Key Default Extra
235
C2 varchar(1) NO NULL
310
236
C1 enum('あ','い','う') YES MUL NULL
312
238
Field Type Null Key Default Extra
239
C2 varchar(1) NO NULL
314
240
C1 enum('龔','龖','龗') YES MUL NULL
316
242
Field Type Null Key Default Extra
243
C2 varchar(1) NO NULL
318
244
C1 enum('ア','イ','ウ') YES MUL NULL
320
246
Field Type Null Key Default Extra
247
C2 varchar(1) NO NULL
322
248
C1 enum('あ','い','う') YES MUL NULL
324
250
Field Type Null Key Default Extra
251
C2 varchar(1) NO NULL
326
252
C1 enum('龔','龖','龗') YES MUL NULL
328
254
Field Type Null Key Default Extra
255
C2 varchar(1) NO NULL
330
256
C1 enum('ア','イ','ウ') YES MUL NULL
332
258
Field Type Null Key Default Extra
259
C2 varchar(1) NO NULL
334
260
C1 enum('あ','い','う') YES MUL NULL
336
262
Field Type Null Key Default Extra
338
C1 enum('龔','龖','龗') YES MUL NULL
340
Field Type Null Key Default Extra
342
C1 enum('ア','イ','ウ') YES MUL NULL
344
Field Type Null Key Default Extra
346
C1 enum('あ','い','う') YES MUL NULL
348
Field Type Null Key Default Extra
263
C2 varchar(1) NO NULL
350
264
C1 enum('龔','龖','龗') YES MUL NULL