diff options
| author | Alfranio Correia <alfranio.correia@oracle.com> | 2010-08-20 03:59:58 +0100 |
|---|---|---|
| committer | Alfranio Correia <alfranio.correia@oracle.com> | 2010-08-20 03:59:58 +0100 |
| commit | ac6026ce2774222b4607fcad4e36bbd5c25ff60a (patch) | |
| tree | 50a64e874f314240cba6e127b70048adb841cb30 /mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result | |
| parent | 7f98714247d601c353779d8615a5624cf00b5e6a (diff) | |
| download | mariadb-git-ac6026ce2774222b4607fcad4e36bbd5c25ff60a.tar.gz | |
BUG#53452 Inconsistent behavior of binlog_direct_non_transactional_updates with
temp table
This patch introduces two key changes in the replication's behavior.
Firstly, it reverts part of BUG#51894 which puts any update to temporary tables
into the trx-cache. Now, updates to temporary tables are handled according to
the type of their engines as a regular table.
Secondly, an unsafe mixed statement, (i.e. a statement that access transactional
table as well non-transactional or temporary table, and writes to any of them),
are written into the trx-cache in order to minimize errors in the execution when
the statement logging format is in use.
Such changes has a direct impact on which statements are classified as unsafe
statements and thus part of BUG#53259 is reverted.
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result b/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result index 92b6592dcfb..a05213217b2 100644 --- a/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result +++ b/mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result @@ -201,7 +201,7 @@ DROP TABLE t1; [MASTER] ********* SOW BINLOG EVENTS IN ... ********* show binlog events in 'master-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000002 # Query # # use `test`; DROP TABLE t1 +master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ [MASTER] ********* SOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info @@ -234,7 +234,7 @@ master-bin.000001 # Rotate # # master-bin.000002;pos=4 [SLAVE] ********* SOW BINLOG EVENTS IN ... ********* show binlog events in 'slave-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -slave-bin.000002 # Query # # use `test`; DROP TABLE t1 +slave-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ [SLAVE] ********* SOW BINLOG EVENTS ********* show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info |