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
6
source include/have_innodb.inc;
7
source include/federated.inc;
10
# Bug#25513 Federated transaction failures
13
create table federated.t1 (a int primary key, b varchar(64))
16
--replace_result $SLAVE_MYPORT SLAVE_PORT
17
eval create table federated.t1 (a int primary key, b varchar(64))
19
connection='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';
22
insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
23
select * from federated.t1;
26
truncate federated.t1;
27
alter table federated.t1 engine=innodb;
31
insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
32
select * from federated.t1;
34
drop table federated.t1;
36
drop table federated.t1;
39
source include/federated_cleanup.inc;