Debian Codegraph @

mysql-test/suite/binlog/r/binlog_stm_tmp_table.result

raw
1 RESET MASTER;
2 create table foo (a int);
3 flush logs;
4 create temporary table tmp1_foo like foo;
5 create temporary table tmp2_foo (a int);
6 insert into tmp1_foo values (1), (2), (3), (4);
7 replace into tmp2_foo values (1), (2), (3), (4);
8 update tmp1_foo set a=2*a-1;
9 update tmp2_foo set a=2*a;
10 delete from tmp1_foo where a < 5;
11 delete from tmp2_foo where a < 5;
12 insert into foo select * from tmp1_foo;
13 insert into foo select * from tmp2_foo;
14 truncate table tmp1_foo;
15 truncate table tmp2_foo;
16 flush logs;
17 select * from foo;
18 a
19 5
20 7
21 6
22 8
23 drop table foo;
24 create table foo (a int);
25 RESET MASTER;
26 select * from foo;
27 a
28 5
29 7
30 6
31 8
32 drop table foo;
33 RESET MASTER;
34 create database b51226;
35 use b51226;
36 create temporary table t1(i int);
37 use b51226;
38 create temporary table t1(i int);
39 create temporary table t1(i int);
40 ERROR 42S01: Table 't1' already exists
41 insert into t1 values(1);
42 DROP DATABASE b51226;
43 FLUSH LOGS;
44 RESET MASTER;