Edit File: rpl000013.result
stop slave; 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; start slave; create table t2(n int); create temporary table t1 (n int); insert into t1 values(1),(2),(3); insert into t2 select * from t1; create temporary table t1 (n int); insert into t1 values (4),(5); insert into t2 select * from t1 as t10; insert into t2 values(6); select * from t2; n 1 2 3 4 5 6 show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0 drop table if exists t1,t2; Warnings: Note 1051 Unknown table 't1'
Back to File Manager