1 source include/have_innodb.inc;
2 source suite/federated/include/federated.inc;
5 DROP TABLE IF EXISTS federated.t1;
7 CREATE TABLE federated.t1 (
9 `name` varchar(32) NOT NULL default ''
11 DEFAULT CHARSET=latin1 ENGINE=innodb;
14 DROP TABLE IF EXISTS federated.t1;
15 # # correct connection, same named tables
16 --replace_result $SLAVE_MYPORT SLAVE_PORT
17 eval CREATE TABLE federated.t1 (
18 `id` int(20) NOT NULL,
19 `name` varchar(32) NOT NULL default ''
21 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
22 CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';
25 INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
26 INSERT INTO federated.t1 (id, name) VALUES (2, 'fee');
28 INSERT INTO federated.t1 (id, name) VALUES (3, 'fie');
29 INSERT INTO federated.t1 (id, name) VALUES (4, 'fum');
32 INSERT INTO federated.t1 (id, name) VALUES (5, 'foe');
33 INSERT INTO federated.t1 (id, name) VALUES (6, 'fig');
35 SELECT * FROM federated.t1;
36 DELETE FROM federated.t1;
38 source suite/federated/include/federated_cleanup.inc;