release/src/router/mysql/mysql-test/suite/federated/federated_innodb.test

   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://root@127.0.0.1:$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;