Debian Codegraph @

mysql-test/suite/rpl/r/rpl_000013.result

raw
1 include/master-slave.inc
2 [connection master]
3 create table t2(n int);
4 create temporary table t1 (n int);
5 insert into t1 values(1),(2),(3);
6 insert into t2 select * from t1;
7 connection master1;
8 create temporary table t1 (n int);
9 insert into t1 values (4),(5);
10 insert into t2 select * from t1 as t10;
11 disconnect master;
12 connection slave;
13 connection master1;
14 insert into t2 values(6);
15 disconnect master1;
16 connection slave;
17 select * from t2;
18 n
19 1
20 2
21 3
22 4
23 5
24 6
25 show status like 'Slave_open_temp_tables';
26 Variable_name Value
27 Slave_open_temp_tables 0
28 connect master2,localhost,root,,;
29 connection master2;
30 drop table if exists t1,t2;
31 Warnings:
32 Note 1051 Unknown table 'test.t1'
33 include/rpl_end.inc