diff options
| author | guilhem@mysql.com <> | 2005-01-14 10:59:37 +0100 |
|---|---|---|
| committer | guilhem@mysql.com <> | 2005-01-14 10:59:37 +0100 |
| commit | 980d1b658ea1141610ea5f2907cf0bcc6798b7a5 (patch) | |
| tree | 233fb7cfe6505e68b912e4ab5fe1502e9ca78406 /client | |
| parent | ebefcc616ac083d90bc0f02273c41a5f07cb196e (diff) | |
| parent | a02601ecc572065c49c3b731db08d6c75d857192 (diff) | |
| download | mariadb-git-980d1b658ea1141610ea5f2907cf0bcc6798b7a5.tar.gz | |
Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.1
into mysql.com:/home/mysql_src/mysql-4.1-clean
Diffstat (limited to 'client')
| -rw-r--r-- | client/mysqldump.c | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/client/mysqldump.c b/client/mysqldump.c index d511dc3bbde..14ebe9ea8f7 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -2200,8 +2200,15 @@ static int start_transaction(MYSQL *mysql_con, my_bool consistent_read_now) 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" : |