Debian Codegraph @

mysql-test/suite/federated/r/federated_bug_25714.result

raw
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,
10 `value` int
11 ) ENGINE=MyISAM;
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,
18 `value` int
19 ) ENGINE=FEDERATED
20 CONNECTION='mysql://[email protected]:SLAVE_PORT/federated/t1';
21 SELECT * from federated.t1;
22 id value
23 1 1
24 2 2
25 3 2
26 INSERT INTO federated.t1 SET value=4;
27 SELECT LAST_INSERT_ID();
28 LAST_INSERT_ID()
29 4
30
31 5 inserted
32 6 inserted
33
34 7 inserted
35 8 inserted
36 SELECT * from federated.t1;
37 id value
38 1 1
39 2 2
40 3 2
41 4 4
42 5 54
43 6 55
44 7 54
45 8 55
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;