1--source include/have_stat_tables.inc 2--source include/have_binlog_format_row.inc 3--source include/master-slave.inc 4 5--echo # 6--echo # Bug mdev-485: unexpected failure with replication of DROP/ALTER table 7--echo # when RBR is on 8--echo # 9 10CREATE TABLE t1 ( a int, b int ) ENGINE=MyISAM; 11INSERT INTO t1 VALUES (2,20), (1,20), (3,30); 12ANALYZE TABLE t1; 13DROP TABLE t1; 14 15--sync_slave_with_master 16--connection master 17 18CREATE TABLE t1 ( a int, b int, INDEX idx1(b) ) ENGINE=MyISAM; 19INSERT INTO t1 VALUES (2,20), (1,20), (3,30); 20ANALYZE TABLE t1; 21DROP INDEX idx1 ON t1; 22 23--sync_slave_with_master 24--connection master 25 26DROP TABLE t1; 27 28CREATE TABLE t1 ( a int, b int, INDEX idx1(b) ) ENGINE=MyISAM; 29INSERT INTO t1 VALUES (2,20), (1,20), (3,30); 30ANALYZE TABLE t1; 31ALTER TABLE t1 DROP COLUMN b; 32 33--sync_slave_with_master 34--connection master 35 36DROP TABLE t1; 37 38CREATE TABLE t1 ( a int, b int, INDEX idx1(b) ) ENGINE=MyISAM; 39INSERT INTO t1 VALUES (2,20), (1,20), (3,30); 40ANALYZE TABLE t1; 41ALTER TABLE t1 RENAME to s; 42 43--sync_slave_with_master 44--connection master 45 46DROP TABLE s; 47 48CREATE TABLE t1 ( a int, b int, INDEX idx1(b) ) ENGINE=MyISAM; 49INSERT INTO t1 VALUES (2,20), (1,20), (3,30); 50ANALYZE TABLE t1; 51ALTER TABLE t1 CHANGE COLUMN b c int ; 52 53--sync_slave_with_master 54--connection master 55 56DROP TABLE t1; 57 58--source include/rpl_end.inc 59