diff options
Diffstat (limited to 'mysql-test/r/rpl_temp_table.result')
-rw-r--r-- | mysql-test/r/rpl_temp_table.result | 48 |
1 files changed, 0 insertions, 48 deletions
diff --git a/mysql-test/r/rpl_temp_table.result b/mysql-test/r/rpl_temp_table.result deleted file mode 100644 index e4ca31d8908..00000000000 --- a/mysql-test/r/rpl_temp_table.result +++ /dev/null @@ -1,48 +0,0 @@ -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, PRIMARY KEY(n)); -create temporary table t1 (n int); -create temporary table t3 (n int not null); -insert into t1 values(1),(2),(3),(100),(25),(26),(200),(300); -insert into t2 select * from t1; -alter table t3 add primary key(n); -flush logs; -insert into t3 values (1010); -insert into t2 select * from t3; -drop table if exists t3; -insert into t2 values (1012); -create temporary table t1 (n int); -insert into t1 values (4),(5); -insert into t2 select * from t1; -insert into t2 values(61); -select * from t2; -n -1 -2 -3 -4 -5 -25 -26 -61 -100 -200 -300 -1010 -1012 -select count(*) from t2; -count(*) -13 -select sum(n) from t2; -sum(n) -2749 -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' |