summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_temp_table.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/rpl_temp_table.result')
-rw-r--r--mysql-test/r/rpl_temp_table.result48
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'