Debian Codegraph @

mysql-test/suite/rpl/t/rpl_invisible_indexes_myisam.test

raw
1 --source include/force_myisam_default.inc
2 --source include/have_myisam.inc
3 --source include/master-slave.inc
4 --echo [Connection Master]
5 --connection master
6
7 --echo # Creation of invisible indexes on MyISAM tables
8
9 CREATE TABLE t1 (i INT, KEY(i) INVISIBLE) ENGINE=MYISAM;
10 INSERT INTO t1 VALUES (2),(3),(5),(7),(11);
11 ANALYZE TABLE t1;
12 --source include/sync_slave_sql_with_master.inc
13 --echo [Connection Slave]
14 SHOW INDEXES FROM t1;
15 EXPLAIN SELECT i FROM t1;
16 --echo [Connection Master]
17 --connection master
18 --echo # Make index visible
19 ALTER TABLE t1 ALTER INDEX i INVISIBLE, ALTER INDEX i VISIBLE, ALTER INDEX i VISIBLE;
20 ANALYZE TABLE t1;
21 --source include/sync_slave_sql_with_master.inc
22 --echo [Connection Slave]
23 SHOW INDEXES FROM t1;
24 EXPLAIN SELECT i FROM t1;
25 --echo [Connection Master]
26 --connection master
27 --echo # Clean up
28
29 DROP TABLE t1;
30
31 --source include/sync_slave_sql_with_master.inc
32 --source include/rpl_end.inc