summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/ignored_index_innodb.result
blob: cc7af31ef97cfd29221b6d32cd2495480247ee2e (plain)
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;