Edit File: binlog_tmp_table.result
RESET MASTER; create table foo (a int); flush logs; create temporary table tmp1_foo like foo; create temporary table tmp2_foo (a int); insert into tmp1_foo values (1), (2), (3), (4); replace into tmp2_foo values (1), (2), (3), (4); update tmp1_foo set a=2*a-1; update tmp2_foo set a=2*a; delete from tmp1_foo where a < 5; delete from tmp2_foo where a < 5; insert into foo select * from tmp1_foo; insert into foo select * from tmp2_foo; truncate table tmp1_foo; truncate table tmp2_foo; flush logs; select * from foo; a 5 7 6 8 drop table foo; create table foo (a int); select * from foo; a 5 7 6 8 drop table foo; RESET MASTER; create database b51226; use b51226; create temporary table t1(i int); use b51226; create temporary table t1(i int); create temporary table t1(i int); ERROR 42S01: Table 't1' already exists insert into t1 values(1); DROP DATABASE b51226; FLUSH LOGS;
Back to File Manager