Debian Codegraph @

mysql-test/suite/federated/federated_bug_13118.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 DROP TABLE IF EXISTS federated.bug_13118_table;
9 CREATE TABLE federated.bug_13118_table (
10 `foo` integer,
11 `bar` integer
12 );
13 connection master;
14 DROP TABLE IF EXISTS federated.t1;
15 CREATE TABLE federated.t1 (
16 `foo` integer,
17 `bar` integer
18 ) ENGINE="FEDERATED"
19 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/bug_13118_table';
20 SELECT * from federated.t1;
21 foo bar
22 INSERT INTO federated.t1 VALUES (1,1);
23 SELECT * FROM federated.t1;
24 foo bar
25 1 1
26 INSERT INTO federated.t1 VALUES (1,1);
27 SELECT * FROM federated.t1;
28 foo bar
29 1 1
30 1 1
31 DROP TABLE federated.t1;
32 connection slave;
33 DROP TABLE federated.bug_13118_table;
34 connection master;
35 DROP TABLE IF EXISTS federated.t1;
36 DROP DATABASE IF EXISTS federated;
37 connection slave;
38 DROP TABLE IF EXISTS federated.t1;
39 DROP DATABASE IF EXISTS federated;