mariadb/mysql-test/main/ignored_index_innodb.result at st-10.11-julius - mirror/mariadb - May the force be without you: git.fucktheforce.de

mirror/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-10-31 19:06:14 +01:00

Sergei Petrunia c236f69d95 Rename IGNORED INDEX tests to match the SQL syntax

ignore_indexes -> ignored_index
ignore_indexes_innodb -> ignored_index_innodb

2021-03-17 13:45:45 +03:00

7 lines

255 B

Text

Raw Permalink Blame History

 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;