Debian Codegraph @

mysql-test/suite/federated/t/federated_archive.test

raw
1 source include/have_archive.inc;
2 source suite/federated/include/federated.inc;
3
4
5 connection slave;
6 --disable_warnings
7 DROP TABLE IF EXISTS federated.archive_table;
8 --enable_warnings
9
10 CREATE TABLE federated.archive_table (
11 `id` int(4) NOT NULL,
12 `name` varchar(54) default NULL
13 ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
14
15
16 connection master;
17 --disable_warnings
18 DROP TABLE IF EXISTS federated.t1;
19 --enable_warnings
20
21 --replace_result $SLAVE_MYPORT SLAVE_PORT
22 eval CREATE TABLE federated.t1 (
23 `id` int(4) NOT NULL,
24 `name` varchar(54) default NULL,
25 PRIMARY KEY (`id`)
26 )
27 ENGINE="FEDERATED" DEFAULT CHARSET=latin1
28 CONNECTION='mysql://[email protected]:$SLAVE_MYPORT/federated/archive_table';
29
30 INSERT INTO federated.t1 (id, name) VALUES (1, 'foo');
31 INSERT INTO federated.t1 (id, name) VALUES (2, 'bar');
32
33 SELECT * FROM federated.t1;
34
35 --error 1296
36 DELETE FROM federated.t1 WHERE id = 1;
37
38 SELECT * FROM federated.t1;
39
40
41 --error 1296
42 UPDATE federated.t1 SET name='baz' WHERE id = 1;
43
44 SELECT * FROM federated.t1;
45
46
47 # --error 1296
48 # TRUNCATE federated.t1;
49 #
50 # SELECT * from federated.t1;
51
52 DROP TABLE federated.t1;
53 connection slave;
54 DROP TABLE federated.archive_table;
55
56
57 source suite/federated/include/federated_cleanup.inc;
58