1
# should work with embedded server after mysqltest is fixed
2
source include/have_innodb.inc;
3
source include/federated.inc;
6
DROP TABLE IF EXISTS federated.t1;
8
CREATE TABLE federated.t1 (
10
`name` varchar(32) NOT NULL default ''
12
DEFAULT CHARSET=latin1 ENGINE=innodb;
15
DROP TABLE IF EXISTS federated.t1;
16
# # correct connection, same named tables
17
--replace_result $SLAVE_MYPORT SLAVE_PORT
18
eval CREATE TABLE federated.t1 (
19
`id` int(20) NOT NULL,
20
`name` varchar(32) NOT NULL default ''
22
ENGINE="FEDERATED" DEFAULT CHARSET=latin1
23
CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';
26
INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
27
INSERT INTO federated.t1 (id, name) VALUES (2, 'fee');
29
INSERT INTO federated.t1 (id, name) VALUES (3, 'fie');
30
INSERT INTO federated.t1 (id, name) VALUES (4, 'fum');
33
INSERT INTO federated.t1 (id, name) VALUES (5, 'foe');
34
INSERT INTO federated.t1 (id, name) VALUES (6, 'fig');
36
SELECT * FROM federated.t1;
37
DELETE FROM federated.t1;
39
source include/federated_cleanup.inc;