Debian Codegraph @

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

raw
1 # NOTE: Keep any include/ files that will kill / skip a test BEFORE any others
2 # See Bug #40645 Test main.federated_innodb does not always clean up after itself
3
4 source suite/federated/include/federated.inc;
5
6 #
7 # Bug#25513 Federated transaction failures
8 #
9 connection slave;
10 create table federated.t1 (a int primary key, b varchar(64))
11 engine=myisam;
12 connection master;
13 --replace_result $SLAVE_MYPORT SLAVE_PORT
14 eval create table federated.t1 (a int primary key, b varchar(64))
15 engine=federated
16 connection='mysql://[email protected]:$SLAVE_MYPORT/federated/t1';
17
18 --error ER_DUP_KEY
19 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
20 select * from federated.t1;
21
22 connection slave;
23 truncate federated.t1;
24 alter table federated.t1 engine=innodb;
25 connection master;
26
27 --error ER_DUP_KEY
28 insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
29 select * from federated.t1;
30
31 drop table federated.t1;
32 connection slave;
33 drop table federated.t1;
34
35
36 source suite/federated/include/federated_cleanup.inc;