Debian Codegraph @

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

raw
1 RESET MASTER;
2 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
3 connect master1,127.0.0.1,root,,test,$MASTER_MYPORT,;
4 create table foo (a int);
5 flush logs;
6 connection master;
7 create temporary table tmp1_foo like foo;
8 connection master1;
9 create temporary table tmp2_foo (a int);
10 connection master;
11 insert into tmp1_foo values (1), (2), (3), (4);
12 connection master1;
13 replace into tmp2_foo values (1), (2), (3), (4);
14 connection master;
15 update tmp1_foo set a=2*a-1;
16 connection master1;
17 update tmp2_foo set a=2*a;
18 connection master;
19 delete from tmp1_foo where a < 5;
20 connection master1;
21 delete from tmp2_foo where a < 5;
22 connection master;
23 insert into foo select * from tmp1_foo;
24 connection master1;
25 insert into foo select * from tmp2_foo;
26 connection master;
27 truncate table tmp1_foo;
28 connection master1;
29 truncate table tmp2_foo;
30 flush logs;
31 connection default;
32 select * from foo;
33 a
34 5
35 7
36 6
37 8
38 drop table foo;
39 create table foo (a int);
40 select * from foo;
41 a
42 5
43 7
44 6
45 8
46 drop table foo;
47 RESET MASTER;
48 connect con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK;
49 connect con2,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK;
50 connection con1;
51 create database b51226;
52 use b51226;
53 create temporary table t1(i int);
54 connection con2;
55 use b51226;
56 create temporary table t1(i int);
57 connection con1;
58 create temporary table t1(i int);
59 ERROR 42S01: Table 't1' already exists
60 disconnect con1;
61 connection default;
62 connection con2;
63 insert into t1 values(1);
64 disconnect con2;
65 connection default;
66 DROP DATABASE b51226;
67 FLUSH LOGS;