Debian Codegraph @

mysql-test/suite/federated/federated_transactions.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.t1;
9 Warnings:
10 Note 1051 Unknown table 'federated.t1'
11 CREATE TABLE federated.t1 (
12 `id` int(20) NOT NULL,
13 `name` varchar(32) NOT NULL default ''
14 )
15 DEFAULT CHARSET=latin1 ENGINE=innodb;
16 connection master;
17 DROP TABLE IF EXISTS federated.t1;
18 Warnings:
19 Note 1051 Unknown table 'federated.t1'
20 CREATE TABLE federated.t1 (
21 `id` int(20) NOT NULL,
22 `name` varchar(32) NOT NULL default ''
23 )
24 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
25 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
26 set autocommit=0;
27 INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
28 INSERT INTO federated.t1 (id, name) VALUES (2, 'fee');
29 COMMIT;
30 INSERT INTO federated.t1 (id, name) VALUES (3, 'fie');
31 INSERT INTO federated.t1 (id, name) VALUES (4, 'fum');
32 ROLLBACK;
33 set autocommit=1;
34 INSERT INTO federated.t1 (id, name) VALUES (5, 'foe');
35 INSERT INTO federated.t1 (id, name) VALUES (6, 'fig');
36 SELECT * FROM federated.t1;
37 id name
38 1 foo
39 2 fee
40 5 foe
41 6 fig
42 DELETE FROM federated.t1;
43 connection master;
44 DROP TABLE IF EXISTS federated.t1;
45 DROP DATABASE IF EXISTS federated;
46 connection slave;
47 DROP TABLE IF EXISTS federated.t1;
48 DROP DATABASE IF EXISTS federated;