Debian Codegraph @

mysql-test/suite/federated/federated_innodb.test

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