mysql-test/t/federated_innodb.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

source include/federated.inc;
source include/have_innodb.inc;

#
# Bug#25513 Federated transaction failures
#
connection slave;
create table federated.t1 (a int primary key, b varchar(64))
  engine=myisam;
connection master;
--replace_result $SLAVE_MYPORT SLAVE_PORT
eval create table federated.t1 (a int primary key, b varchar(64))
  engine=federated
  connection='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';

--error ER_DUP_KEY
insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
select * from federated.t1;

connection slave;
truncate federated.t1;
alter table federated.t1 engine=innodb;
connection master;

--error ER_DUP_KEY
insert into federated.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe");
select * from federated.t1;

drop table federated.t1;
connection slave;
drop table federated.t1;


source include/federated_cleanup.inc;