Debian Codegraph @

mysql-test/suite/federated/r/federated_innodb.result

raw
1 CREATE DATABASE federated;
2 CREATE DATABASE federated;
3 create table federated.t1 (a int primary key, b varchar(64))
4 engine=myisam;
5 create table federated.t1 (a int primary key, b varchar(64))
6 engine=federated
7 connection='mysql://[email protected]:SLAVE_PORT/federated/t1';
8 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
9 ERROR 23000: Can't write; duplicate key in table 't1'
10 select * from federated.t1;
11 a b
12 1 Larry
13 2 Curly
14 truncate federated.t1;
15 alter table federated.t1 engine=innodb;
16 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
17 ERROR 23000: Can't write; duplicate key in table 't1'
18 select * from federated.t1;
19 a b
20 drop table federated.t1;
21 drop table federated.t1;
22 DROP TABLE IF EXISTS federated.t1;
23 DROP DATABASE federated;
24 DROP TABLE IF EXISTS federated.t1;
25 DROP DATABASE federated;