mysql-test/main/ignored_index_innodb.result


1
2
3
4
5
6
7

create table t1 (a int, b int, key a1(a)) engine=innodb;
insert into t1 values (1,1),(2,2),(3,3);
set alter_algorithm='instant';
alter table t1 alter index a1 ignored;
alter table t1 alter index a1 not ignored;
set alter_algorithm=default;
drop table t1;