diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/rpl_alter.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/rpl_alter.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/t/rpl_alter.test b/mysql-test/suite/engines/funcs/t/rpl_alter.test new file mode 100644 index 00000000000..576376a0264 --- /dev/null +++ b/mysql-test/suite/engines/funcs/t/rpl_alter.test @@ -0,0 +1,24 @@ +source include/master-slave.inc; +--disable_warnings +drop database if exists mysqltest; +--enable_warnings +create database mysqltest; + +create table mysqltest.t1 ( n int); +alter table mysqltest.t1 add m int; +insert into mysqltest.t1 values (1,2); +create table mysqltest.t2 (n int); +insert into mysqltest.t2 values (45); +rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2; +save_master_pos; +connection slave; +sync_with_master; +select * from mysqltest.t2; +select * from mysqltest.t3; +connection master; +drop database mysqltest; +save_master_pos; +connection slave; +sync_with_master; + +# End of 4.1 tests |