Debian Codegraph @

mysql-test/suite/federated/federated_innodb.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 create table federated.t1 (a int primary key, b varchar(64))
9 engine=myisam;
10 connection master;
11 create table federated.t1 (a int primary key, b varchar(64))
12 engine=federated
13 connection='mysql://[email protected]:SLAVE_PORT/federated/t1';
14 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
15 ERROR 23000: Can't write; duplicate key in table 't1'
16 select * from federated.t1;
17 a b
18 1 Larry
19 2 Curly
20 connection slave;
21 truncate federated.t1;
22 alter table federated.t1 engine=innodb;
23 connection master;
24 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
25 ERROR 23000: Can't write; duplicate key in table 't1'
26 select * from federated.t1;
27 a b
28 drop table federated.t1;
29 connection slave;
30 drop table federated.t1;
31 connection master;
32 DROP TABLE IF EXISTS federated.t1;
33 DROP DATABASE IF EXISTS federated;
34 connection slave;
35 DROP TABLE IF EXISTS federated.t1;
36 DROP DATABASE IF EXISTS federated;