diff options
Diffstat (limited to 'mysql-test/t/rpl_alter.test')
-rw-r--r-- | mysql-test/t/rpl_alter.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_alter.test b/mysql-test/t/rpl_alter.test new file mode 100644 index 00000000000..710dd2d09d6 --- /dev/null +++ b/mysql-test/t/rpl_alter.test @@ -0,0 +1,19 @@ +source include/master-slave.inc; +drop database if exists d1; +create database d1; +create table d1.t1 ( n int); +alter table d1.t1 add m int; +insert into d1.t1 values (1,2); +create table d1.t2 (n int); +insert into d1.t2 values (45); +rename table d1.t2 to d1.t3, d1.t1 to d1.t2; +save_master_pos; +connection slave; +sync_with_master; +select * from d1.t2; +select * from d1.t3; +connection master; +drop database d1; +save_master_pos; +connection slave; +sync_with_master; |