Debian Codegraph @

mysql-test/suite/federated/federated_archive.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.archive_table;
9 CREATE TABLE federated.archive_table (
10 `id` int(4) NOT NULL,
11 `name` varchar(54) default NULL
12 ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
13 connection master;
14 DROP TABLE IF EXISTS federated.t1;
15 CREATE TABLE federated.t1 (
16 `id` int(4) NOT NULL,
17 `name` varchar(54) default NULL,
18 PRIMARY KEY (`id`)
19 )
20 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
21 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/archive_table';
22 INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
23 INSERT INTO federated.t1 (id, name) VALUES (2, 'bar');
24 SELECT * FROM federated.t1;
25 id name
26 1 foo
27 2 bar
28 DELETE FROM federated.t1 WHERE id = 1;
29 ERROR HY000: Got error 10000 'Error on remote system: 1031: Storage engine ARCHIVE of the table `federated`.`archive_table` doesn't have this option' from FEDERATED
30 SELECT * FROM federated.t1;
31 id name
32 1 foo
33 2 bar
34 UPDATE federated.t1 SET name='baz' WHERE id = 1;
35 ERROR HY000: Got error 10000 'Error on remote system: 1031: Storage engine ARCHIVE of the table `federated`.`archive_table` doesn't have this option' from FEDERATED
36 SELECT * FROM federated.t1;
37 id name
38 1 foo
39 2 bar
40 DROP TABLE federated.t1;
41 connection slave;
42 DROP TABLE federated.archive_table;
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;