diff options
Diffstat (limited to 'mysql-test/r/rpl000012.result')
-rw-r--r-- | mysql-test/r/rpl000012.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000012.result b/mysql-test/r/rpl000012.result index 9ce7037101e..9aa52a789c0 100644 --- a/mysql-test/r/rpl000012.result +++ b/mysql-test/r/rpl000012.result @@ -1,3 +1,25 @@ +slave stop; +reset master; +reset slave; +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; +slave start; +drop table if exists t1,t2,t3; +create table t2 (n int); +create temporary table t1 (n int); +insert into t1 values(1),(2),(3); +insert into t2 select * from t1; +drop table if exists test.t3; +create temporary table test.t3 (n int not null); +alter table test.t3 add primary key(n); +insert into t3 values (100); +insert into t2 select * from t3; +drop table if exists test.t3; +insert into t2 values (101); +create temporary table t1 (n int); +insert into t1 values (4),(5); +insert into t2 select * from t1; +insert into t2 values(6); +select * from t2; n 1 2 @@ -7,5 +29,7 @@ n 4 5 6 +show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0 +drop table if exists t1,t2; |