1
source include/have_archive.inc;
7
DROP TABLE IF EXISTS federated.archive_table;
10
CREATE TABLE federated.archive_table (
12
`name` varchar(54) default NULL
13
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
18
DROP TABLE IF EXISTS federated.t1;
21
--replace_result $SLAVE_MYPORT SLAVE_PORT
22
eval CREATE TABLE federated.t1 (
24
`name` varchar(54) default NULL,
27
ENGINE="FEDERATED" DEFAULT CHARSET=latin1
28
CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/archive_table';
30
INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
31
INSERT INTO federated.t1 (id, name) VALUES (2, 'bar');
33
SELECT * FROM federated.t1;
36
DELETE FROM federated.t1 WHERE id = 1;
38
SELECT * FROM federated.t1;
42
UPDATE federated.t1 SET name='baz' WHERE id = 1;
44
SELECT * FROM federated.t1;
48
# TRUNCATE federated.t1;
50
# SELECT * from federated.t1;
52
DROP TABLE federated.t1;
54
DROP TABLE federated.archive_table;
57
source federated_cleanup.inc;