1
CREATE DATABASE federated;
2
CREATE DATABASE federated;
3
SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
4
SET @@GLOBAL.CONCURRENT_INSERT= 0;
5
SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
6
SET @@GLOBAL.CONCURRENT_INSERT= 0;
7
DROP TABLE IF EXISTS federated.bug_13118_table;
8
CREATE TABLE federated.t1 (
9
`id` int auto_increment primary key,
12
INSERT INTO federated.t1 SET value=1;
13
INSERT INTO federated.t1 SET value=2;
14
INSERT INTO federated.t1 SET value=2;
15
DROP TABLE IF EXISTS federated.t1;
16
CREATE TABLE federated.t1 (
17
`id` int auto_increment primary key,
20
CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1';
21
SELECT * from federated.t1;
26
INSERT INTO federated.t1 SET value=4;
27
SELECT LAST_INSERT_ID();
36
SELECT * from federated.t1;
46
DROP TABLE federated.t1;
47
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
48
DROP TABLE federated.t1;
49
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
50
DROP TABLE IF EXISTS federated.t1;
51
DROP DATABASE federated;
52
DROP TABLE IF EXISTS federated.t1;
53
DROP DATABASE federated;