1
# Check that path to the specific test program has been setup
2
if (`select LENGTH("$MYSQL_BUG25714") = 0`)
4
skip Need bug25714 test program;
10
# Disable concurrent inserts to avoid test failures when reading
11
# data from concurrent connections (insert might return before
12
# the data is actually in the table).
13
SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
14
SET @@GLOBAL.CONCURRENT_INSERT= 0;
17
SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
18
SET @@GLOBAL.CONCURRENT_INSERT= 0;
20
DROP TABLE IF EXISTS federated.bug_13118_table;
23
CREATE TABLE federated.t1 (
24
`id` int auto_increment primary key,
27
INSERT INTO federated.t1 SET value=1;
28
INSERT INTO federated.t1 SET value=2;
29
INSERT INTO federated.t1 SET value=2;
33
DROP TABLE IF EXISTS federated.t1;
36
--replace_result $SLAVE_MYPORT SLAVE_PORT
37
eval CREATE TABLE federated.t1 (
38
`id` int auto_increment primary key,
41
CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';
43
SELECT * from federated.t1;
45
INSERT INTO federated.t1 SET value=4;
47
SELECT LAST_INSERT_ID();
49
--exec $MYSQL_BUG25714 $SLAVE_MYPORT
50
--exec $MYSQL_BUG25714 $MASTER_MYPORT
52
SELECT * from federated.t1;
54
DROP TABLE federated.t1;
55
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
57
DROP TABLE federated.t1;
58
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
62
source federated_cleanup.inc;