bk commit into 4.1 tree (guilhem:1.2216)

[guilhem]

Below is the list of changes that have just been committed into a local
4.1 repository of guilhem. When guilhem does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.2216 05/01/13 00:44:13 guilhem@stripped +1 -0
  Fix for BUG#7850: force the transaction isolation level to REPEATABLE READ when --single-transaction

  client/mysqldump.c
    1.168 05/01/13 00:44:06 guilhem@stripped +7 -0
    force the transaction isolation level to REPEATABLE READ when --single-transaction

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	guilhem
# Host:	gbichot2.local
# Root:	/home/mysql_src/mysql-4.1-clean

--- 1.167/client/mysqldump.c	2005-01-06 19:47:05 +01:00
+++ 1.168/client/mysqldump.c	2005-01-13 00:44:06 +01:00
@@ -2200,8 +2200,15 @@
     We use BEGIN for old servers. --single-transaction --master-data will fail
     on old servers, but that's ok as it was already silently broken (it didn't
     do a consistent read, so better tell people frankly, with the error).
+
+    We want the first consistent read to be used for all tables to dump so we
+    need the REPEATABLE READ level (not anything lower, for example READ
+    COMMITTED would give one new consistent read per dumped table).
   */
   return (mysql_query_with_error_report(mysql_con, 0,
+                                        "SET SESSION TRANSACTION ISOLATION "
+                                        "LEVEL REPEATABLE READ") ||
+          mysql_query_with_error_report(mysql_con, 0,
                                         consistent_read_now ?
                                         "START TRANSACTION "
                                         "WITH CONSISTENT SNAPSHOT" :