1
--source include/have_bug25714.inc
2
source include/federated.inc;
5
# Disable concurrent inserts to avoid test failures when reading
6
# data from concurrent connections (insert might return before
7
# the data is actually in the table).
8
SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
9
SET @@GLOBAL.CONCURRENT_INSERT= 0;
12
SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
13
SET @@GLOBAL.CONCURRENT_INSERT= 0;
15
DROP TABLE IF EXISTS federated.bug_13118_table;
18
CREATE TABLE federated.t1 (
19
`id` int auto_increment primary key,
22
INSERT INTO federated.t1 SET value=1;
23
INSERT INTO federated.t1 SET value=2;
24
INSERT INTO federated.t1 SET value=2;
28
DROP TABLE IF EXISTS federated.t1;
31
--replace_result $SLAVE_MYPORT SLAVE_PORT
32
eval CREATE TABLE federated.t1 (
33
`id` int auto_increment primary key,
36
CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';
38
SELECT * from federated.t1;
40
INSERT INTO federated.t1 SET value=4;
42
SELECT LAST_INSERT_ID();
44
--exec $MYSQL_BUG25714 $SLAVE_MYPORT
45
--exec $MYSQL_BUG25714 $MASTER_MYPORT
47
SELECT * from federated.t1;
49
DROP TABLE federated.t1;
50
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
52
DROP TABLE federated.t1;
53
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
56
source include/federated_cleanup.inc;