Bug #49741 test files contain explicit references to bin/relay-log positions

• Submitted: 16 Dec 2009 17:58
• Modified: 29 Nov 2010 14:22
• Reporter: Andrei Elkin
• Status: Closed
• Category: Tests
• Severity: S3 (Non-critical)
• Version: 5.0+
• OS: Any
• Assigned to: Libing Song
• CPU Architecture: Any

[16 Dec 2009 17:58] Andrei Elkin

Description:
Maintainance of testing suites is overly troublesome also due to the fact
that many tests explicitly referrer to binlog positions and the positions
are recorded into result files.
Moreover, I found several tests which references are inadequate
although the test succeed.
Last but not least, if the binlogging master had an option that changes a replication event size the test results would strongly object.
The ongoing WL#2540 replication events checksum will provide such option.

Currently, the test writer has all necessary tool to avoid the explicit values.
Resolving this issue is necessary in order to integrate WL#2540 with mtr.

The task suggests to walk through all tests and result files to locate
and replace the explicit values performing methods of the Suggested fix.

How to repeat:
Look at tests to see:

E.g mysqlbinlog.test:

--exec $MYSQL_BINLOG --short-form --local-load=$MYSQLTEST_VARDIR/tmp/ --position=331 $MYSQLD_DATADIR/master-bin.000002

Suggested fix:
The explicit value can be found via

1. The last written event into binlog:

let $log_file= query_get_value(SHOW MASTER STATUS, File, 1);
let $pos= query_get_value(SHOW MASTER STATUS, Pos, 1);

2. An event written in binlog and not the last

let $pos= query_get_value(show binlog events, Pos, 7); # the 7th

Queries of commands referring to the symbolic name of the position value
needs prefixing with --exec

E.g

--exec $MYSQL_BINLOG --start-position=$rollback_pos

[13 Apr 2010 8:58] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/105474

3449 [e-mail]	2010-04-13
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      After this patch, All the binlog position numbers which can be effected 
      by changing binlog format are removed from the result file.
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/show_slave_status3.inc
        Until_log_pos is masked in include file.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.

[28 Apr 2010 8:29] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/106762

3360 [e-mail]	2010-04-28
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc. The file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'show_slave_running_status.inc' and 'show_slave_error_status.inc'
         and 'show_slave_running_and_error_status.inc' are auxiliary files helping
         to show running status and error information easily.
         
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
        'show_slave_running_and_error_status.inc' only shows 'Slave_IO_Running', 'Slave_SQL_Running' and 'Last_SQL_Error'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'show_slave_running_and_error_status.inc' and 'show_slave_error_status.inc' instead of 'show slave status' statement.
        'show_slave_running_and_error_status.inc' only shows 'Slave_IO_Running', 'Slave_SQL_Running' and 'Last_SQL_Error'.
        'show_slave_error_status.inc' shows 'Last_SQL_Error'.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
        'show_slave_error_status.inc' shows 'Last_SQL_Error'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status.inc'.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
        'show_slave_running_and_error_status.inc' only shows 'Slave_IO_Running', 'Slave_SQL_Running' and 'Last_SQL_Error'.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
        'show_slave_running_and_error_status.inc' only shows 'Slave_IO_Running', 'Slave_SQL_Running' and 'Last_SQL_Error'.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_slave_error_status.inc
        This include file can help to extract error informations from the result of 'show slave status' statement.
     @ mysql-test/include/show_slave_running_and_error_status.inc
        This include file can help to extract running status and error informations from the result of 'show slave status' statement.
     @ mysql-test/include/show_slave_running_status.inc
        This include file can help to extract running status from the result of 'show slave status' statement.
     @ mysql-test/include/show_slave_status_item.inc
        An auxiliary file for 'show_slave_status.inc'
     @ mysql-test/include/test_fieldsize.inc
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'show_slave_running_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'wait_for_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
        'show_slave_error_status.inc' shows 'Last_SQL_Error'.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status '.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status '.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Use 'query_get_value(SHOW MASTER STATUS, Position, 1)' to get the number of current binlog position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        Use 'show_slave_running_and_error_status.inc' and 'show_slave_error_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'show_slave_error_status.inc' instead of 'show_slave_status.inc'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'wait_for_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Show only Last_SQL_Error instead of all result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'wait_for_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'wait_for_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        The numbers of 'master_log_pos' in result file  are replaced by '#'.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'show_slave_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'show_slave_running_and_error_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[11 May 2010 13:43] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/107966

3378 [e-mail]	2010-05-11
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc or wait_for_binlog_event.inc. 
         show_binlog_events.inc file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'check_slave_is_running.inc' and 'check_slave_no_error.inc'
         and 'check_slave_param.inc' are auxiliary files helping
         to show running status and error information easily.
         
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'check_slave_is_running.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'wait_for_slave_sql_error.inc' and 'ait_for_slave_sql_error_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_get_master_version_and_clock.test
        It is need now to give a error number, so use 'wait_for_slave_io_to_stop.inc'
        instead of 'wait_for_slave_io_error.inc'.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc' statement.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/extra/rpl_tests/rpl_row_basic.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/include/check_slave_is_running.inc
        To make sure both sql and io thread are running well. If not, the test will be aborted.
     @ mysql-test/include/check_slave_no_error.inc
        To make sure both sql and io thread have no error. If not, the test will be aborted.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_rpl_debug_info.inc
        Add 'SELECT NOW()' in the debug information.
     @ mysql-test/include/show_slave_status.inc
        It's more clean and tidy Only the given columns of slave status are printed.
     @ mysql-test/include/test_fieldsize.inc
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/include/wait_for_binlog_event.inc
        Use show_rpl_debug_info.inc instead of 'SHOW BINLOG EVENTS'.
     @ mysql-test/include/wait_for_slave_io_error.inc
        Add $slave_io_errno and $show_slave_io_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_param.inc
        Use die instead of exit.
     @ mysql-test/include/wait_for_slave_sql_error.inc
        Add $slave_sql_errno and $show_slave_sql_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_sql_error_and_skip.inc
        Add $slave_skip_counter variable, test cases can set how many events should be skipped.
     @ mysql-test/include/wait_for_status_var.inc
        Use die instead of exit.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we use 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'query_vertical SHOW SLAVE STATUS' instead of 'show slave status'.
        There is no status columns in the result file, for no slave exists on master's server.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Mask the explicit positions in the result file.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        Mask the explicit binary log positions in the result file.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'wait_for_binlog_event.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Mask the explicit position numbers in result file.
        It is restricted running on SBR, for it want to binlog 'set @a=1' statement.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        UUse 'check_slave_is_running.inc' and 'show_slave_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_get_master_version_and_clock.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'wait_for_slave_sql_error_and_skip.inc' to wait the given sql thread error happening and then skip the event. There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_log_pos.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and mask the explicit position number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test
        Mask master_log_pos and master_log_file
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'wait_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[20 May 2010 10:19] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108756

3391 [e-mail]	2010-05-20
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc or wait_for_binlog_event.inc. 
         show_binlog_events.inc file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'check_slave_is_running.inc' and 'check_slave_no_error.inc'
         and 'check_slave_param.inc' are auxiliary files helping
         to show running status and error information easily.
         
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'check_slave_is_running.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'wait_for_slave_sql_error.inc' and 'ait_for_slave_sql_error_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_get_master_version_and_clock.test
        It is need now to give a error number, so use 'wait_for_slave_io_to_stop.inc'
        instead of 'wait_for_slave_io_error.inc'.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc' statement.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/extra/rpl_tests/rpl_row_basic.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/include/check_slave_is_running.inc
        To make sure both sql and io thread are running well. If not, the test will be aborted.
     @ mysql-test/include/check_slave_no_error.inc
        To make sure both sql and io thread have no error. If not, the test will be aborted.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_rpl_debug_info.inc
        Add 'SELECT NOW()' in the debug information.
     @ mysql-test/include/show_slave_status.inc
        It's more clean and tidy Only the given columns of slave status are printed.
     @ mysql-test/include/test_fieldsize.inc
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/include/wait_for_binlog_event.inc
        Use show_rpl_debug_info.inc instead of 'SHOW BINLOG EVENTS'.
     @ mysql-test/include/wait_for_slave_io_error.inc
        Add $slave_io_errno and $show_slave_io_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_param.inc
        Use die instead of exit.
     @ mysql-test/include/wait_for_slave_sql_error.inc
        Add $slave_sql_errno and $show_slave_sql_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_sql_error_and_skip.inc
        Add $slave_skip_counter variable, test cases can set how many events should be skipped.
     @ mysql-test/include/wait_for_status_var.inc
        Use die instead of exit.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we use 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'query_vertical SHOW SLAVE STATUS' instead of 'show slave status'.
        There is no status columns in the result file, for no slave exists on master's server.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Mask the explicit positions in the result file.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        Mask the explicit binary log positions in the result file.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'wait_for_binlog_event.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Mask the explicit position numbers in result file.
        It is restricted running on SBR, for it want to binlog 'set @a=1' statement.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        UUse 'check_slave_is_running.inc' and 'show_slave_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_get_master_version_and_clock.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'wait_for_slave_sql_error_and_skip.inc' to wait the given sql thread error happening and then skip the event. There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_log_pos.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and mask the explicit position number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test
        Mask master_log_pos and master_log_file
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'wait_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[22 May 2010 0:47] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108938

3394 [e-mail]	2010-05-22
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc or wait_for_binlog_event.inc. 
         show_binlog_events.inc file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'check_slave_is_running.inc' and 'check_slave_no_error.inc'
         and 'check_slave_param.inc' are auxiliary files helping
         to show running status and error information easily.
         
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'check_slave_is_running.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'wait_for_slave_sql_error.inc' and 'ait_for_slave_sql_error_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_get_master_version_and_clock.test
        It is need now to give a error number, so use 'wait_for_slave_io_to_stop.inc'
        instead of 'wait_for_slave_io_error.inc'.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc' statement.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/extra/rpl_tests/rpl_row_basic.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/include/check_slave_is_running.inc
        To make sure both sql and io thread are running well. If not, the test will be aborted.
     @ mysql-test/include/check_slave_no_error.inc
        To make sure both sql and io thread have no error. If not, the test will be aborted.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_rpl_debug_info.inc
        Add 'SELECT NOW()' in the debug information.
     @ mysql-test/include/show_slave_status.inc
        It's more clean and tidy Only the given columns of slave status are printed.
     @ mysql-test/include/test_fieldsize.inc
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/include/wait_for_binlog_event.inc
        Use show_rpl_debug_info.inc instead of 'SHOW BINLOG EVENTS'.
     @ mysql-test/include/wait_for_slave_io_error.inc
        Add $slave_io_errno and $show_slave_io_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_param.inc
        Use die instead of exit.
     @ mysql-test/include/wait_for_slave_sql_error.inc
        Add $slave_sql_errno and $show_slave_sql_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_sql_error_and_skip.inc
        Add $slave_skip_counter variable, test cases can set how many events should be skipped.
     @ mysql-test/include/wait_for_status_var.inc
        Use die instead of exit.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we use 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'query_vertical SHOW SLAVE STATUS' instead of 'show slave status'.
        There is no status columns in the result file, for no slave exists on master's server.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Mask the explicit positions in the result file.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        Mask the explicit binary log positions in the result file.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'wait_for_binlog_event.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Mask the explicit position numbers in result file.
        It is restricted running on SBR, for it want to binlog 'set @a=1' statement.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        UUse 'check_slave_is_running.inc' and 'show_slave_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_get_master_version_and_clock.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'wait_for_slave_sql_error_and_skip.inc' to wait the given sql thread error happening and then skip the event. There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_log_pos.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and mask the explicit position number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test
        Mask master_log_pos and master_log_file
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'wait_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[24 May 2010 10:36] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109029

3395 [e-mail]	2010-05-24
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc or wait_for_binlog_event.inc. 
         show_binlog_events.inc file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'check_slave_is_running.inc' and 'check_slave_no_error.inc'
         and 'check_slave_param.inc' are auxiliary files helping
         to show running status and error information easily.
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'check_slave_is_running.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'wait_for_slave_sql_error.inc' and 'ait_for_slave_sql_error_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_get_master_version_and_clock.test
        It is need now to give a error number, so use 'wait_for_slave_io_to_stop.inc'
        instead of 'wait_for_slave_io_error.inc'.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc' statement.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/extra/rpl_tests/rpl_row_basic.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/include/check_slave_is_running.inc
        To make sure both sql and io thread are running well. If not, the test will be aborted.
     @ mysql-test/include/check_slave_no_error.inc
        To make sure both sql and io thread have no error. If not, the test will be aborted.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_rpl_debug_info.inc
        Add 'SELECT NOW()' in the debug information.
     @ mysql-test/include/show_slave_status.inc
        It's more clean and tidy Only the given columns of slave status are printed.
     @ mysql-test/include/test_fieldsize.inc
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/include/wait_for_binlog_event.inc
        Use show_rpl_debug_info.inc instead of 'SHOW BINLOG EVENTS'.
     @ mysql-test/include/wait_for_slave_io_error.inc
        Add $slave_io_errno and $show_slave_io_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_param.inc
        Use die instead of exit.
     @ mysql-test/include/wait_for_slave_sql_error.inc
        Add $slave_sql_errno and $show_slave_sql_error, it waits only a given error.
     @ mysql-test/include/wait_for_status_var.inc
        Use die instead of exit.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we use 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'query_vertical SHOW SLAVE STATUS' instead of 'show slave status'.
        There is no status columns in the result file, for no slave exists on master's server.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Mask the explicit positions in the result file.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        Mask the explicit binary log positions in the result file.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'wait_for_binlog_event.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Mask the explicit position numbers in result file.
        It is restricted running on SBR, for it want to binlog 'set @a=1' statement.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        UUse 'check_slave_is_running.inc' and 'show_slave_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_get_master_version_and_clock.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'wait_for_slave_sql_error_and_skip.inc' to wait the given sql thread error happening and then skip the event. There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_log_pos.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and mask the explicit position number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test
        Mask master_log_pos and master_log_file
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'wait_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[24 May 2010 13:54] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109067

3395 [e-mail]	2010-05-24
      Bug #49741  test files contain explicit references to bin/relay-log positions
      
      Some of the test cases reference to binlog position and
      these position numbers are written into result explicitly.
      It is difficult to maintain if log event format changes. 
      
      There are a couple of cases explicit position number appears, 
      we handle them in different ways
      A. 'CHANGE MASTER ...' with MASTER_LOG_POS or/and RELAY_LOG_POS options
         Use --replace_result to mask them.
      B. 'SHOW BINLOG EVENT ...'
         Replaced by show_binlog_events.inc or wait_for_binlog_event.inc. 
         show_binlog_events.inc file's function is enhanced by given
         $binlog_file and $binlog_limit.
      C. 'SHOW SLAVE STATUS', 'show_slave_status.inc' and 'show_slave_status2.inc'
         For the test cases just care a few items in the result of 'SHOW SLAVE STATUS',
         only the items related to each test case are showed.
         'show_slave_status.inc' is rebuild, only the given items in $status_items
         will be showed.
         'check_slave_is_running.inc' and 'check_slave_no_error.inc'
         and 'check_slave_param.inc' are auxiliary files helping
         to show running status and error information easily.
     @ mysql-test/extra/binlog_tests/binlog.test
        It only cares whether current binlog file index is changed, so it is ok
        with 'show_master_status.inc' instead of 'show mater status'.
     @ mysql-test/extra/binlog_tests/blackhole.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_deadlock.test
        Use 'check_slave_is_running.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_extraSlave_Col.test
        Use 'wait_for_slave_sql_error.inc' and 'ait_for_slave_sql_error_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/extra/rpl_tests/rpl_flsh_tbls.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_get_master_version_and_clock.test
        It is need now to give a error number, so use 'wait_for_slave_io_to_stop.inc'
        instead of 'wait_for_slave_io_error.inc'.
     @ mysql-test/extra/rpl_tests/rpl_insert_delayed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_max_relay_size.test
        se 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/extra/rpl_tests/rpl_ndb_apply_status.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/extra/rpl_tests/rpl_reset_slave.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc' statement.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/extra/rpl_tests/rpl_row_basic.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
     @ mysql-test/extra/rpl_tests/rpl_row_tabledefs.test
        Use 'show_slave_error_status_and_skip.inc' instead of 'show slave status'.
     @ mysql-test/include/check_slave_is_running.inc
        To make sure both sql and io thread are running well. If not, the test will be aborted.
     @ mysql-test/include/check_slave_no_error.inc
        To make sure both sql and io thread have no error. If not, the test will be aborted.
     @ mysql-test/include/get_relay_log_pos.inc
        According to the position of a log event in master binlog file,
        find the peer position of a log event in relay log file.
     @ mysql-test/include/rpl_stmt_seq.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/include/show_binlog_events.inc
        Add two options $binlog_file and $binlog_limit for showing binlog events from different binlog files or/and given different limits on position or row number.
     @ mysql-test/include/show_rpl_debug_info.inc
        Add 'SELECT NOW()' in the debug information.
     @ mysql-test/include/show_slave_status.inc
        It's more clean and tidy Only the given columns of slave status are printed.
     @ mysql-test/include/test_fieldsize.inc
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/include/wait_for_binlog_event.inc
        Use show_rpl_debug_info.inc instead of 'SHOW BINLOG EVENTS'.
     @ mysql-test/include/wait_for_slave_io_error.inc
        Add $slave_io_errno and $show_slave_io_error, it waits only a given error.
     @ mysql-test/include/wait_for_slave_param.inc
        Use die instead of exit.
     @ mysql-test/include/wait_for_slave_sql_error.inc
        Add $slave_sql_errno and $show_slave_sql_error, it waits only a given error.
     @ mysql-test/include/wait_for_status_var.inc
        Use die instead of exit.
     @ mysql-test/r/flush_block_commit_notembedded.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/r/multi_update.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_innodb.result
        It checks whether somethings are binlogged, so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/r/binlog_row_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/r/binlog_stm_binlog.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/binlog/t/binlog_innodb.test
        It checks whether somethings are binlogged, so we use 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/binlog/t/binlog_stm_binlog.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/r/rpl_bug36391.result
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/bugs/t/rpl_bug12691.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/bugs/t/rpl_bug36391.test
        'show master status' is replaced by 'show_master_status.inc'.
        Position in the result of 'show master status' is replaced by '#'.
     @ mysql-test/suite/engines/funcs/r/rpl_000015.result
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/suite/engines/funcs/t/rpl_000015.test
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_REDIRECT.test
        Use 'query_vertical SHOW SLAVE STATUS' instead of 'show slave status'.
        There is no status columns in the result file, for no slave exists on master's server.
     @ mysql-test/suite/engines/funcs/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/engines/funcs/t/rpl_empty_master_crash.test
        We doesn't really need the statement.
     @ mysql-test/suite/engines/funcs/t/rpl_flushlog_loop.test
        Just show Relay_Log_File, running status and error informations.
        Use 'check_slave_is_running.inc' to verify that Slave threads are running well.
     @ mysql-test/suite/engines/funcs/t/rpl_loaddata_s.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_log_pos.test
        Mask the explicit positions in the result file.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/engines/funcs/t/rpl_row_inexist_tbl.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
        
        Mask the explicit binary log positions in the result file.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id1.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
        Use 'check_slave_no_error.inc' to simplify the check that there is no error.
     @ mysql-test/suite/engines/funcs/t/rpl_server_id2.test
        It doesn't really need in this test.
     @ mysql-test/suite/engines/funcs/t/rpl_slave_status.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/engines/funcs/t/rpl_switch_stm_row_mixed.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/manual/t/rpl_replication_delay.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/parts/t/rpl_partition.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_ddl.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/include/rpl_mixed_dml.inc
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_000015.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_binlog_grant.test
        Use 'wait_for_binlog_event.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_bug33931.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_change_master.test
        This test just care whether Read_Master_Log_Pos is equal to Exec_Master_Log_Pos after 'CHANGE MASTER ..'. So 'show slave status' is removed and just check the value of Read_Master_Log_Pos and Exec_Master_Log_Pos.
     @ mysql-test/suite/rpl/t/rpl_critical_errors.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_dual_pos_advance.test
        Mask the explicit position numbers in result file.
        It is restricted running on SBR, for it want to binlog 'set @a=1' statement.
     @ mysql-test/suite/rpl/t/rpl_empty_master_crash.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_flushlog_loop.test
        UUse 'check_slave_is_running.inc' and 'show_slave_status.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_get_master_version_and_clock.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
     @ mysql-test/suite/rpl/t/rpl_grant.test
        It doesn't need in this test.
     @ mysql-test/suite/rpl/t/rpl_incident.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_known_bugs_detection.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_loaddata_fatal.test
        Use 'wait_for_slave_sql_error_and_skip.inc' to wait the given sql thread error happening and then skip the event. There is no need to print the result of 'show slave stutus'.
     @ mysql-test/suite/rpl/t/rpl_log_pos.test
        Use 'wait_for_slave_io_error.inc' to wait the given io thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rbr_to_sbr.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_replicate_do.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_rotate_logs.test
        Use 'show_slave_status.inc' instead of 'show_slave_status2.inc'.
     @ mysql-test/suite/rpl/t/rpl_row_basic_11bugs.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_create_table.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_drop.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_row_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_skip_error.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl/t/rpl_slave_load_remove_tmpfile.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_slave_skip.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and mask the explicit position number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_sp.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/suite/rpl/t/rpl_ssl.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_ssl1.test
        Use 'show_slave_status.inc' instead of 'show slave status'.
     @ mysql-test/suite/rpl/t/rpl_stm_until.test
        Use 'check_slave_param.inc' to check whether SQL Thread stop at a right position, and use binlog position variables instead of explicit number in the 'CHANGE MASTER' statements.
     @ mysql-test/suite/rpl/t/rpl_temporary_errors.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_basic.test
        Use 'wait_for_slave_sql_error.inc' to wait the given sql thread error happening.
        There is no need to print the result of 'show slave status'.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_simplex.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_idempotent.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_multi.test
        Mask master_log_pos and master_log_file
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_sync.test
        Use 'check_slave_is_running.inc' instead of 'show slave status' statement.
     @ mysql-test/suite/rpl_ndb/t/rpl_truncate_7ndb.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/alter_table-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/create-big.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/ctype_cp932_binlog_stm.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.
     @ mysql-test/t/flush_block_commit_notembedded.test
        It checks whether somethings are binlogged, 
        so we using 'show_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/multi_update.test
        It checks whether somethings are binlogged, 
        so we using 'wait_binlog_event.inc' instead of 'show master status'.
     @ mysql-test/t/sp_trans_log.test
        Use 'show_binlog_events.inc' instead of 'show binlog events' statement.

[25 May 2010 3:40] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109109

3396 [e-mail]	2010-05-25
      Postfix BUG#49741

[28 May 2010 3:08] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109441

3400 [e-mail]	2010-05-28
      Postfix for BUG#49741
      Add code to waiting for a set of errors.
      Add code to waiting for an error instead of waiting for io thread to stop, as
      after 'START SLAVE', the status of io thread is still not running.
      But it doesn't mean slave io thread encounters an error.

[31 May 2010 6:14] Libing Song

Pushed into mysql-5.1-bugteam and merged into mysql-trunk-merge

[2 Jun 2010 8:49] Bugs System

Pushed into 5.1.48 (revid:[e-mail]-20100602084411-2yu607bslbmgufl3) (version source revid:[e-mail]-20100528025745-zur4o99wtcu0rnw5) (merge vers: 5.1.47) (pib:16)

[3 Jun 2010 2:53] Paul DuBois

Changes to test cases. No changelog entry needed.

Setting report to Need Merge pending further pushes.

[17 Jun 2010 6:13] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615145247-8bj0vmuqlotbqsn9) (version source revid:[e-mail]-20100528032120-x6ivgz7vcuzd5ea2) (merge vers: 5.5.5-m3) (pib:16)

[17 Jun 2010 6:16] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615150216-cubqoyn1fj9b6a2p) (version source revid:[e-mail]-20100513074652-0cvlhgkesgbb2bfh) (pib:16)

[18 Jun 2010 11:03] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/111536

3192 [e-mail]	2010-06-18
      Postfix for merging bug#49741 from 5.1(gca)

[26 Jun 2010 7:40] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100626073921-t0e6q2c9nkhuemnj) (version source revid:[e-mail]-20100626073921-t0e6q2c9nkhuemnj) (pib:16)

[4 Aug 2010 8:03] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100626073921-t0e6q2c9nkhuemnj) (merge vers: 5.6.99-m4) (pib:18)

[4 Aug 2010 8:19] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:[e-mail]-20100626073921-t0e6q2c9nkhuemnj) (merge vers: 5.6.99-m4) (pib:18)

[4 Aug 2010 15:38] Jon Stephens

Changes in test code only; no end-user changes to document.

Closed.

[14 Oct 2010 8:27] Bugs System

Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:[e-mail]-20101014082627-jrmy9xbfbtrebw3c) (version source revid:[e-mail]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 8:42] Bugs System

Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:[e-mail]-20101014083757-5qo48b86d69zjvzj) (version source revid:[e-mail]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 8:57] Bugs System

Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:[e-mail]-20101014084420-y54ecj85j5we27oa) (version source revid:[e-mail]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 13:55] Jon Stephens

Set back to Closed; see above.

[29 Nov 2010 11:12] Bugs System

Pushed into mysql-trunk 5.6.1-m5 (revid:[e-mail]-20101129111021-874if2qsp0i8d5ze) (version source revid:[e-mail]-20101129111021-874if2qsp0i8d5ze) (merge vers: 5.6.1-m5) (pib:23)