bzr commit into mysql-5.1 branch (Matthias.Leich:2745) Bug#38762

[Matthias Leich]

#At file:///work2/5.1/mysql-5.1-bugteam-A/

 2745 Matthias Leich	2008-10-02 [merge]
      Merge 5.0 -> 5.1 of fix for
      Bug#38762 main.federated_bug_25714 fails sporadically
modified:
  mysql-test/r/federated_bug_25714.result
  mysql-test/t/federated_bug_25714.test

=== modified file 'mysql-test/r/federated_bug_25714.result'
--- a/mysql-test/r/federated_bug_25714.result	2008-04-30 13:28:19 +0000
+++ b/mysql-test/r/federated_bug_25714.result	2008-10-02 11:18:36 +0000
@@ -9,7 +9,9 @@ DROP DATABASE IF EXISTS federated;
 CREATE DATABASE federated;
 DROP DATABASE IF EXISTS federated;
 CREATE DATABASE federated;
-SET @OLD_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
+SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
+SET @@GLOBAL.CONCURRENT_INSERT= 0;
+SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
 SET @@GLOBAL.CONCURRENT_INSERT= 0;
 DROP TABLE IF EXISTS federated.bug_13118_table;
 CREATE TABLE federated.t1 (
@@ -51,9 +53,10 @@ id	value
 7	54
 8	55
 DROP TABLE federated.t1;
+SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
 DROP TABLE federated.t1;
+SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
 DROP TABLE IF EXISTS federated.t1;
 DROP DATABASE IF EXISTS federated;
 DROP TABLE IF EXISTS federated.t1;
 DROP DATABASE IF EXISTS federated;
-SET @@GLOBAL.CONCURRENT_INSERT= @OLD_CONCURRENT_INSERT;

=== modified file 'mysql-test/t/federated_bug_25714.test'
--- a/mysql-test/t/federated_bug_25714.test	2008-04-30 13:28:19 +0000
+++ b/mysql-test/t/federated_bug_25714.test	2008-10-02 11:18:36 +0000
@@ -1,15 +1,16 @@
 --source include/have_bug25714.inc
 source include/federated.inc;
 
-connection default;
-
+connection master;
 # Disable concurrent inserts to avoid test failures when reading
 # data from concurrent connections (insert might return before
 # the data is actually in the table).
-SET @OLD_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
+SET @OLD_MASTER_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
 SET @@GLOBAL.CONCURRENT_INSERT= 0;
 
 connection slave;
+SET @OLD_SLAVE_CONCURRENT_INSERT= @@GLOBAL.CONCURRENT_INSERT;
+SET @@GLOBAL.CONCURRENT_INSERT= 0;
 --disable_warnings
 DROP TABLE IF EXISTS federated.bug_13118_table;
 --enable_warnings
@@ -46,11 +47,12 @@ SELECT LAST_INSERT_ID();
 SELECT * from federated.t1;
 
 DROP TABLE federated.t1;
+SET @@GLOBAL.CONCURRENT_INSERT= @OLD_MASTER_CONCURRENT_INSERT;
 connection slave;
 DROP TABLE federated.t1;
+SET @@GLOBAL.CONCURRENT_INSERT= @OLD_SLAVE_CONCURRENT_INSERT;
+
 
 source include/federated_cleanup.inc;
 
-connection default;
 
-SET @@GLOBAL.CONCURRENT_INSERT= @OLD_CONCURRENT_INSERT;