jp_enum_ujis.result 10.4 KB
Newer Older
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 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
drop table if exists `T1`;
drop table if exists `T2`;
drop table if exists `T3`;
drop table if exists `T4`;
drop table if exists `T5`;
drop table if exists `T6`;
drop table if exists `T7`;
drop table if exists `T8`;
drop table if exists `T9`;
drop table if exists `T10`;
drop table if exists `T11`;
drop table if exists `T12`;
SET NAMES ujis;
SET character_set_database = ujis;
CREATE TABLE `T1` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `T2` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `T3` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `T4` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `T5` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `T6` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `T7` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `T8` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `T9` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = heap;
CREATE TABLE `T10` (`C1` ENUM('ア','イ','ウ'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb;
CREATE TABLE `T11` (`C1` ENUM('あ','い','う'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb;
CREATE TABLE `T12` (`C1` ENUM('龔','龖','龗'), INDEX(`C1`)) DEFAULT CHARSET = ujis engine = bdb;
INSERT INTO `T1` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `T2` VALUES ('あ'),('い'),('う');
INSERT INTO `T3` VALUES ('龔'),('龖'),('龗');
INSERT INTO `T4` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `T5` VALUES ('あ'),('い'),('う');
INSERT INTO `T6` VALUES ('龔'),('龖'),('龗');
INSERT INTO `T7` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `T8` VALUES ('あ'),('い'),('う');
INSERT INTO `T9` VALUES ('龔'),('龖'),('龗');
INSERT INTO `T10` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `T11` VALUES ('あ'),('い'),('う');
INSERT INTO `T12` VALUES ('龔'),('龖'),('龗');
SELECT * FROM `T1`;
C1



SELECT * FROM `T2`;
C1



SELECT * FROM `T3`;
C1



SELECT * FROM `T4`;
C1



SELECT * FROM `T5`;
C1



SELECT * FROM `T6`;
C1



SELECT * FROM `T7`;
C1



SELECT * FROM `T8`;
C1



SELECT * FROM `T9`;
C1



SELECT * FROM `T10`;
C1



SELECT * FROM `T11`;
C1



SELECT * FROM `T12`;
C1



SHOW CREATE TABLE `T1`;
Table	Create Table
T1	CREATE TABLE `T1` (
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T2`;
Table	Create Table
T2	CREATE TABLE `T2` (
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T3`;
Table	Create Table
T3	CREATE TABLE `T3` (
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T4`;
Table	Create Table
T4	CREATE TABLE `T4` (
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T5`;
Table	Create Table
T5	CREATE TABLE `T5` (
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T6`;
Table	Create Table
T6	CREATE TABLE `T6` (
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T7`;
Table	Create Table
T7	CREATE TABLE `T7` (
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
140
) ENGINE=MEMORY DEFAULT CHARSET=ujis
141 142 143 144 145
SHOW CREATE TABLE `T8`;
Table	Create Table
T8	CREATE TABLE `T8` (
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
146
) ENGINE=MEMORY DEFAULT CHARSET=ujis
147 148 149 150 151
SHOW CREATE TABLE `T9`;
Table	Create Table
T9	CREATE TABLE `T9` (
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
152
) ENGINE=MEMORY DEFAULT CHARSET=ujis
153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221
SHOW CREATE TABLE `T10`;
Table	Create Table
T10	CREATE TABLE `T10` (
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T11`;
Table	Create Table
T11	CREATE TABLE `T11` (
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T12`;
Table	Create Table
T12	CREATE TABLE `T12` (
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
DESC `T1`;
Field	Type	Null	Key	Default	Extra
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T2`;
Field	Type	Null	Key	Default	Extra
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T3`;
Field	Type	Null	Key	Default	Extra
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T4`;
Field	Type	Null	Key	Default	Extra
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T5`;
Field	Type	Null	Key	Default	Extra
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T6`;
Field	Type	Null	Key	Default	Extra
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T7`;
Field	Type	Null	Key	Default	Extra
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T8`;
Field	Type	Null	Key	Default	Extra
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T9`;
Field	Type	Null	Key	Default	Extra
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T10`;
Field	Type	Null	Key	Default	Extra
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T11`;
Field	Type	Null	Key	Default	Extra
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T12`;
Field	Type	Null	Key	Default	Extra
C1	enum('龔','龖','龗')	YES	MUL	NULL	
ALTER TABLE `T1` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T2` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T3` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T4` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T5` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T6` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T7` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T8` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T9` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T10` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T11` ADD `C2` CHAR(1) NOT NULL FIRST;
ALTER TABLE `T12` ADD `C2` CHAR(1) NOT NULL FIRST;
SHOW CREATE TABLE `T1`;
Table	Create Table
T1	CREATE TABLE `T1` (
222
  `C2` char(1) NOT NULL,
223 224 225 226 227 228
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T2`;
Table	Create Table
T2	CREATE TABLE `T2` (
229
  `C2` char(1) NOT NULL,
230 231 232 233 234 235
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T3`;
Table	Create Table
T3	CREATE TABLE `T3` (
236
  `C2` char(1) NOT NULL,
237 238 239 240 241 242
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=InnoDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T4`;
Table	Create Table
T4	CREATE TABLE `T4` (
243
  `C2` char(1) NOT NULL,
244 245 246 247 248 249
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T5`;
Table	Create Table
T5	CREATE TABLE `T5` (
250
  `C2` char(1) NOT NULL,
251 252 253 254 255 256
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T6`;
Table	Create Table
T6	CREATE TABLE `T6` (
257
  `C2` char(1) NOT NULL,
258 259 260 261 262 263
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=MyISAM DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T7`;
Table	Create Table
T7	CREATE TABLE `T7` (
264
  `C2` char(1) NOT NULL,
265 266
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
267
) ENGINE=MEMORY DEFAULT CHARSET=ujis
268 269 270
SHOW CREATE TABLE `T8`;
Table	Create Table
T8	CREATE TABLE `T8` (
271
  `C2` char(1) NOT NULL,
272 273
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
274
) ENGINE=MEMORY DEFAULT CHARSET=ujis
275 276 277
SHOW CREATE TABLE `T9`;
Table	Create Table
T9	CREATE TABLE `T9` (
278
  `C2` char(1) NOT NULL,
279 280
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
281
) ENGINE=MEMORY DEFAULT CHARSET=ujis
282 283 284
SHOW CREATE TABLE `T10`;
Table	Create Table
T10	CREATE TABLE `T10` (
285
  `C2` char(1) NOT NULL,
286 287 288 289 290 291
  `C1` enum('ア','イ','ウ') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T11`;
Table	Create Table
T11	CREATE TABLE `T11` (
292
  `C2` char(1) NOT NULL,
293 294 295 296 297 298
  `C1` enum('あ','い','う') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
SHOW CREATE TABLE `T12`;
Table	Create Table
T12	CREATE TABLE `T12` (
299
  `C2` char(1) NOT NULL,
300 301 302 303 304
  `C1` enum('龔','龖','龗') default NULL,
  KEY `C1` (`C1`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ujis
DESC `T1`;
Field	Type	Null	Key	Default	Extra
305
C2	char(1)	NO		NULL	
306 307 308
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T2`;
Field	Type	Null	Key	Default	Extra
309
C2	char(1)	NO		NULL	
310 311 312
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T3`;
Field	Type	Null	Key	Default	Extra
313
C2	char(1)	NO		NULL	
314 315 316
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T4`;
Field	Type	Null	Key	Default	Extra
317
C2	char(1)	NO		NULL	
318 319 320
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T5`;
Field	Type	Null	Key	Default	Extra
321
C2	char(1)	NO		NULL	
322 323 324
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T6`;
Field	Type	Null	Key	Default	Extra
325
C2	char(1)	NO		NULL	
326 327 328
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T7`;
Field	Type	Null	Key	Default	Extra
329
C2	char(1)	NO		NULL	
330 331 332
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T8`;
Field	Type	Null	Key	Default	Extra
333
C2	char(1)	NO		NULL	
334 335 336
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T9`;
Field	Type	Null	Key	Default	Extra
337
C2	char(1)	NO		NULL	
338 339 340
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DESC `T10`;
Field	Type	Null	Key	Default	Extra
341
C2	char(1)	NO		NULL	
342 343 344
C1	enum('ア','イ','ウ')	YES	MUL	NULL	
DESC `T11`;
Field	Type	Null	Key	Default	Extra
345
C2	char(1)	NO		NULL	
346 347 348
C1	enum('あ','い','う')	YES	MUL	NULL	
DESC `T12`;
Field	Type	Null	Key	Default	Extra
349
C2	char(1)	NO		NULL	
350 351 352 353 354 355 356 357 358 359 360 361 362
C1	enum('龔','龖','龗')	YES	MUL	NULL	
DROP TABLE `T1`;
DROP TABLE `T2`;
DROP TABLE `T3`;
DROP TABLE `T4`;
DROP TABLE `T5`;
DROP TABLE `T6`;
DROP TABLE `T7`;
DROP TABLE `T8`;
DROP TABLE `T9`;
DROP TABLE `T10`;
DROP TABLE `T11`;
DROP TABLE `T12`;