diff options
| author | Magne Mahre <magne.mahre@sun.com> | 2010-06-08 19:47:10 +0200 |
|---|---|---|
| committer | Magne Mahre <magne.mahre@sun.com> | 2010-06-08 19:47:10 +0200 |
| commit | db716d11af3d3a5a3a58fde97c4252182c0e4a09 (patch) | |
| tree | 5c2e277adf35121acdd8da39496b8dc6a1dcd665 /sql/handler.cc | |
| parent | da8c33ba7ceb5feefe9d2a6f107e32faf5478e1b (diff) | |
| parent | 946fad350283a46d1eb36d97d4af14b0732ea585 (diff) | |
| download | mariadb-git-db716d11af3d3a5a3a58fde97c4252182c0e4a09.tar.gz | |
Bug#20837 Apparent change of isolation level during transaction
Bug#46527 COMMIT AND CHAIN RELEASE does not make sense
Bug#53343 completion_type=1, COMMIT/ROLLBACK AND CHAIN don't
preserve the isolation level
Bug#53346 completion_type has strange effect in a stored
procedure/prepared statement
Added test cases to verify the expected behaviour of :
SET SESSION TRANSACTION ISOLATION LEVEL,
SET TRANSACTION ISOLATION LEVEL,
@@completion_type,
COMMIT AND CHAIN,
ROLLBACK AND CHAIN
..and some combinations of the above
Diffstat (limited to 'sql/handler.cc')
| -rw-r--r-- | sql/handler.cc | 3 |
1 files changed, 0 insertions, 3 deletions
diff --git a/sql/handler.cc b/sql/handler.cc index 11f684a8010..587490dd708 100644 --- a/sql/handler.cc +++ b/sql/handler.cc @@ -1302,7 +1302,6 @@ int ha_commit_one_phase(THD *thd, bool all) if (thd->transaction.changed_tables) query_cache.invalidate(thd->transaction.changed_tables); #endif - thd->variables.tx_isolation=thd->session_tx_isolation; } } /* Free resources and perform other cleanup even for 'empty' transactions. */ @@ -1379,8 +1378,6 @@ int ha_rollback_trans(THD *thd, bool all) if (is_real_trans && thd->transaction_rollback_request && thd->transaction.xid_state.xa_state != XA_NOTR) thd->transaction.xid_state.rm_error= thd->stmt_da->sql_errno(); - if (all) - thd->variables.tx_isolation=thd->session_tx_isolation; } /* Always cleanup. Even if nht==0. There may be savepoints. */ if (is_real_trans) |