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