Debian Codegraph @

mysql-test/suite/federated/federated_maybe_16324629.result

raw
1 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
2 connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,;
3 connection master;
4 CREATE DATABASE federated;
5 connection slave;
6 CREATE DATABASE federated;
7 connection slave;
8 create table federated.t1 (a int, b int, unique key (a), key (b));
9 connection master;
10 create table t1 (a int, b int, unique key (a), key (b))
11 engine=federated CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
12 insert into t1 values (3, 3), (7, 7);
13 delete t1 from t1 where b = 3;
14 select * from t1;
15 a b
16 7 7
17 drop table t1;
18 connection slave;
19 connection default;
20 connection master;
21 DROP TABLE IF EXISTS federated.t1;
22 DROP DATABASE IF EXISTS federated;
23 connection slave;
24 DROP TABLE IF EXISTS federated.t1;
25 DROP DATABASE IF EXISTS federated;