1 # name : bug860910.patch
4 # Fixes LP bug #860910 / MySQL bug #62557
7 +++ b/mysql-test/suite/rpl/r/percona_bug860910.result
9 +*** Set up master (server_1) <-> master (server_2) replication ***
10 +include/rpl_init.inc [topology=1->2->1]
12 +SELECT @@global.log_slave_updates;
13 +@@global.log_slave_updates
15 +SELECT @@global.log_slave_updates;
16 +@@global.log_slave_updates
18 +CREATE TABLE t1(a INT);
20 +INSERT INTO t1 VALUES (@var);
21 +INSERT INTO t1 VALUES (1);
24 +include/check_slave_param.inc [Exec_Master_Log_Pos]
27 +++ b/mysql-test/suite/rpl/t/percona_bug860910.cnf
38 +++ b/mysql-test/suite/rpl/t/percona_bug860910.test
40 +########################################################################
41 +# Bug #860910: SHOW SLAVE STATUS gives wrong output with master-master
42 +# and using SET uservars
43 +########################################################################
45 +--echo *** Set up master (server_1) <-> master (server_2) replication ***
46 +--let $rpl_topology= 1->2->1
47 +--source include/rpl_init.inc
50 +--connection server_1
51 +SELECT @@global.log_slave_updates;
53 +--connection server_2
54 +SELECT @@global.log_slave_updates;
56 +--connection server_1
57 +CREATE TABLE t1(a INT);
59 +INSERT INTO t1 VALUES (@var);
60 +INSERT INTO t1 VALUES (1);
64 +# The following would hang with the bug not fixed due to incorrect
65 +# Exec_Master_Log_Pos
66 +--source include/rpl_sync.inc
68 +--connection server_2
69 +--let $master_log_pos= query_get_value(SHOW MASTER STATUS, Position, 1)
71 +--connection server_1
72 +--let $slave_param= Exec_Master_Log_Pos
73 +--let $slave_param_value= $master_log_pos
74 +--source include/check_slave_param.inc
77 +--source include/rpl_end.inc
80 @@ -5079,6 +5079,12 @@
82 user_var_event->charset_number,
85 + These User_var_log_events must be logged with event_info's
86 + server_id, rather than the current one.
88 + e.server_id= event_info->server_id;
92 if (file == &log_file)