--source include/force_myisam_default.inc
--source include/have_myisam.inc
--source include/master-slave.inc
--echo [Connection Master]
--connection master

--echo # Creation of invisible indexes on MyISAM tables

CREATE TABLE t1  (i INT, KEY(i) INVISIBLE) ENGINE=MYISAM;
INSERT INTO t1 VALUES (2),(3),(5),(7),(11);
ANALYZE TABLE t1;
--source include/sync_slave_sql_with_master.inc
--echo [Connection Slave]
SHOW INDEXES FROM t1;
EXPLAIN SELECT i FROM t1;
--echo [Connection Master]
--connection master
--echo # Make index visible
ALTER TABLE t1 ALTER INDEX i INVISIBLE, ALTER INDEX i VISIBLE, ALTER INDEX i VISIBLE;
ANALYZE TABLE t1;
--source include/sync_slave_sql_with_master.inc
--echo [Connection Slave]
SHOW INDEXES FROM t1;
EXPLAIN SELECT i FROM t1;
--echo [Connection Master]
--connection master
--echo # Clean up

DROP TABLE t1;

--source include/sync_slave_sql_with_master.inc
--source include/rpl_end.inc