diff options
Diffstat (limited to 'mysql-test/r/rpl_alter.result')
-rw-r--r-- | mysql-test/r/rpl_alter.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_alter.result b/mysql-test/r/rpl_alter.result index 7883e725e3a..729c7df6808 100644 --- a/mysql-test/r/rpl_alter.result +++ b/mysql-test/r/rpl_alter.result @@ -1,4 +1,21 @@ +slave stop; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +slave start; +drop database if exists test_$1; +create database test_$1; +create table test_$1.t1 ( n int); +alter table test_$1.t1 add m int; +insert into test_$1.t1 values (1,2); +create table test_$1.t2 (n int); +insert into test_$1.t2 values (45); +rename table test_$1.t2 to test_$1.t3, test_$1.t1 to test_$1.t2; +select * from test_$1.t2; n m 1 2 +select * from test_$1.t3; n 45 +drop database test_$1; |