210
210
t1 CREATE TEMPORARY TABLE `t1` (
211
211
`c` VARCHAR(30) COLLATE utf8_general_ci DEFAULT NULL,
212
212
`t` TEXT COLLATE utf8_general_ci,
213
UNIQUE KEY `c` (`c`(2)),
214
UNIQUE KEY `t` (`t`(3))
213
UNIQUE KEY `c` (`c`(2)) USING BTREE,
214
UNIQUE KEY `t` (`t`(3)) USING BTREE
215
215
) ENGINE=MyISAM COLLATE = utf8_general_ci
216
216
insert t1 values ('cccc', 'tttt'),
217
217
(0xD0B1212223D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1212223D0B1D0B1D0B1D0B1),
309
309
t1 CREATE TABLE `t1` (
310
310
`i1` INT NOT NULL,
311
311
`i2` INT NOT NULL,
312
UNIQUE KEY `i1idx` (`i1`),
313
UNIQUE KEY `i2idx` (`i2`)
312
UNIQUE KEY `i1idx` (`i1`) USING BTREE,
313
UNIQUE KEY `i2idx` (`i2`) USING BTREE
314
314
) ENGINE=InnoDB COLLATE = utf8_general_ci
316
316
create temporary table t1 (
336
336
t1 CREATE TABLE `t1` (
337
337
`a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
338
338
`b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
339
KEY `a` (`a`,`b`) USING BTREE
340
340
) ENGINE=InnoDB COLLATE = utf8_general_ci
341
341
alter table t1 modify b varchar(20);
342
342
show create table t1;
344
344
t1 CREATE TABLE `t1` (
345
345
`a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
346
346
`b` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
347
KEY `a` (`a`,`b`) USING BTREE
348
348
) ENGINE=InnoDB COLLATE = utf8_general_ci
349
349
alter table t1 modify a varchar(20);
350
350
show create table t1;
352
352
t1 CREATE TABLE `t1` (
353
353
`a` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
354
354
`b` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
355
KEY `a` (`a`,`b`) USING BTREE
356
356
) ENGINE=InnoDB COLLATE = utf8_general_ci
358
358
create table t1 (a int not null primary key, b varchar(20) not null unique);
400
400
`c2` VARCHAR(12) COLLATE utf8_general_ci NOT NULL,
401
401
`c3` VARCHAR(123) COLLATE utf8_general_ci NOT NULL,
402
402
`c4` TIMESTAMP NULL DEFAULT NULL,
403
PRIMARY KEY (`c2`,`c3`),
404
UNIQUE KEY `i4` (`c4`),
409
KEY `i5` (`c1`,`c2`,`c3`,`c4`),
403
PRIMARY KEY (`c2`,`c3`) USING BTREE,
404
UNIQUE KEY `i4` (`c4`) USING BTREE,
405
KEY `c1` (`c1`) USING BTREE,
406
KEY `i1` (`c1`) USING BTREE,
407
KEY `i2` (`c2`) USING BTREE,
408
KEY `i3` (`c3`) USING BTREE,
409
KEY `i5` (`c1`,`c2`,`c3`,`c4`) USING BTREE,
410
KEY `c2` (`c2`,`c4`) USING BTREE
411
411
) ENGINE=InnoDB COLLATE = utf8_general_ci
412
412
alter table t1 drop index c1;
413
413
alter table t1 add index (c1);
433
433
`c2` VARCHAR(12) COLLATE utf8_general_ci NOT NULL,
434
434
`c3` VARCHAR(123) COLLATE utf8_general_ci NOT NULL,
435
435
`c4` TIMESTAMP NULL DEFAULT NULL,
437
KEY `i5` (`c1`,`c2`,`c3`,`c4`),
443
KEY `c2` (`c2`(4),`c3`(7))
436
KEY `i1` (`c1`) USING BTREE,
437
KEY `i5` (`c1`,`c2`,`c3`,`c4`) USING BTREE,
438
KEY `c1` (`c1`) USING BTREE,
439
KEY `c1_2` (`c1`) USING BTREE,
440
KEY `i3` (`c3`) USING BTREE,
441
KEY `i2` (`c2`) USING BTREE,
442
KEY `i4` (`c4`) USING BTREE,
443
KEY `c2` (`c2`(4),`c3`(7)) USING BTREE
444
444
) ENGINE=InnoDB COLLATE = utf8_general_ci
445
445
insert into t1 values(1, 'a', 'a', NULL);
446
446
insert into t1 values(1, 'b', 'b', NULL);
503
503
`a` INT NOT NULL,
504
504
`b` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
505
505
`c` VARCHAR(4) COLLATE utf8_general_ci NOT NULL,
506
UNIQUE KEY `cc` (`c`),
507
UNIQUE KEY `bb` (`b`(1)),
506
UNIQUE KEY `cc` (`c`) USING BTREE,
507
UNIQUE KEY `bb` (`b`(1)) USING BTREE,
508
KEY `aa` (`a`) USING BTREE
509
509
) ENGINE=InnoDB COLLATE = utf8_general_ci
511
511
create table t1(a int not null, key aa(a),
528
528
`a` INT NOT NULL,
529
529
`b` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
530
530
`c` VARCHAR(4) COLLATE utf8_general_ci NOT NULL,
531
UNIQUE KEY `cc` (`c`),
532
UNIQUE KEY `bb` (`b`(1)),
531
UNIQUE KEY `cc` (`c`) USING BTREE,
532
UNIQUE KEY `bb` (`b`(1)) USING BTREE,
533
KEY `aa` (`a`) USING BTREE
534
534
) ENGINE=InnoDB COLLATE = utf8_general_ci