--source include/master-slave.inc

--echo [On Master]
--connection master

CREATE TABLE t1 (c1 INT, c2 INT);
insert into t1 (c1,c2) values (1,1);
insert into t1 (c1,c2) values (1,1);

select * from t1;

sync_slave_with_master;
--echo [On Slave]
--connection slave

select * from t1;
alter table t1 add column (c3 int);
SHOW CREATE TABLE t1;

--echo [On Master]
--connection master
insert into t1 (c1,c2) values (1,1);

--echo [On Slave]
--connection slave

select * from t1;
query_vertical show slave status;

alter table t1 modify column c3 int after c1;
SHOW CREATE TABLE t1;

--echo [On Master]
--connection master
insert into t1 (c1,c2) values (1,1);

sync_slave_with_master;
--echo [On Slave]
--connection slave

select * from t1;
query_vertical show slave status;