Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_multi_update4.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 drop database if exists d1;
5 drop database if exists d2;
6 connection slave;
7 drop database if exists d2;
8 connection master;
9 create database d1;
10 create table d1.t0 (id int);
11 create database d2;
12 use d2;
13 create table t1 (id int);
14 create table t2 (id int);
15 insert into t1 values (1), (2), (3), (4), (5);
16 insert into t2 select id + 3 from t1;
17 update t1 join t2 using (id) set t1.id = 0;
18 insert into d1.t0 values (0);
19 connection slave;
20 use d1;
21 select * from t0 where id=0;
22 id
23 0
24 connection master;
25 drop database d1;
26 drop database d2;
27 connection slave;
28 include/rpl_end.inc