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.t1;
9
Note 1051 Unknown table 't1'
10
CREATE TABLE federated.t1 (
11
`id` int(20) NOT NULL,
12
`dummy` int(20) DEFAULT NULL,
15
DEFAULT CHARSET=latin1;
16
INSERT INTO federated.t1 (`id`) VALUES
17
(1001), (1002), (1003), (1004), (1005),
18
(1006), (1007), (1008), (1009), (1010);
19
CREATE TABLE federated.t1 (
20
`id` int(20) NOT NULL,
21
`dummy` int(20) DEFAULT NULL,
24
DEFAULT CHARSET=latin1
25
CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1';
26
CREATE TABLE federated.t2 (
27
`id` int(20) NOT NULL,
28
`dummy` int(20) NOT NULL,
31
DEFAULT CHARSET=latin1;
32
INSERT INTO federated.t2 (`id`, `dummy`) VALUES (1005, 5);
33
SELECT * FROM federated.t1;
45
UPDATE federated.t1 ft1 INNER JOIN federated.t2 ft2 ON ft1.id = ft2.id SET ft1.dummy = ft2.dummy WHERE ft1.dummy IS NULL;
46
SELECT * FROM federated.t1;
58
DELETE FROM federated.t1 WHERE id = 1005;
59
SELECT * FROM federated.t1 WHERE id = 1005;
61
SELECT * FROM federated.t1;
72
DROP TABLE federated.t2;
73
DROP TABLE federated.t1;
74
DROP TABLE federated.t1;
75
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
76
SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
77
DROP TABLE IF EXISTS federated.t1;
78
DROP DATABASE federated;
79
DROP TABLE IF EXISTS federated.t1;
80
DROP DATABASE federated;