From: Nuno Carvalho Date: January 19 2012 8:04pm Subject: bzr push into mysql-trunk branch (nuno.carvalho:3752 to 3753) List-Archive: http://lists.mysql.com/commits/142451 Message-Id: <201201192004.q0JK4HYw009402@acsmt358.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3753 Nuno Carvalho 2012-01-19 [merge] Merge from mysql-5.5 into mysql-trunk. Conflicts: mysql-test/include/show_slave_status.inc modified: mysql-test/extra/rpl_tests/rpl_start_stop_slave.test mysql-test/include/show_slave_status.inc mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result 3752 Andrei Elkin 2012-01-19 [merge] merging from repo. modified: storage/innobase/os/os0file.cc === modified file 'mysql-test/extra/rpl_tests/rpl_start_stop_slave.test' --- a/mysql-test/extra/rpl_tests/rpl_start_stop_slave.test 2012-01-19 15:55:36 +0000 +++ b/mysql-test/extra/rpl_tests/rpl_start_stop_slave.test 2012-01-19 20:03:07 +0000 @@ -200,7 +200,7 @@ START SLAVE; --let $slave_param_value=1236 --source include/wait_for_slave_param.inc ---let $slave_io_error_replace= / at [0-9]*/ at XXX/ /\.\/*master-bin/master-bin/ +--let $slave_field_result_replace= / at [0-9]*/ at XXX/ --let $status_items= Last_IO_Errno, Last_IO_Error --source include/show_slave_status.inc === modified file 'mysql-test/include/show_slave_status.inc' --- a/mysql-test/include/show_slave_status.inc 2012-01-04 15:48:00 +0000 +++ b/mysql-test/include/show_slave_status.inc 2012-01-19 20:03:07 +0000 @@ -56,10 +56,17 @@ # # --let $status_items= Master_Log_File, Relay_Master_Log_File # -# $slave_io_error_replace +# $slave_field_result_replace # If set, one or more regex patterns for replacing variable # text in the error message. Syntax as --replace-regex # +# $slave_sql_mode +# If set, change the slave sql mode during this macro, reverting +# to the previous on exit. Default sql_mode is NO_BACKSLASH_ESCAPES +# to allow replace '\' by '/' making paths OS independent. Example: +# +# --let $slave_sql_mode= NO_BACKSLASH_ESCAPES +# --let $_show_slave_status_items= $status_items @@ -69,13 +76,30 @@ if (!$status_items) } +--let $_slave_sql_mode= NO_BACKSLASH_ESCAPES +if ($slave_sql_mode) +{ + --let $_slave_sql_mode= $slave_sql_mode +} +--let $_previous_slave_sql_mode = `SELECT @@sql_mode` +--disable_query_log +eval SET sql_mode= '$_slave_sql_mode'; +--enable_query_log + + while ($_show_slave_status_items) { --let $_show_slave_status_name= `SELECT SUBSTRING_INDEX('$_show_slave_status_items', ',', 1)` --let $_show_slave_status_items= `SELECT LTRIM(SUBSTRING('$_show_slave_status_items', LENGTH('$_show_slave_status_name') + 2))` --let $_show_slave_status_value= query_get_value(SHOW SLAVE STATUS, $_show_slave_status_name, 1) - --replace_regex $slave_io_error_replace + --let $_slave_field_result_replace= /[\\]/\// $slave_field_result_replace + --replace_regex $_slave_field_result_replace --let $_show_slave_status_value= `SELECT REPLACE("$_show_slave_status_value", '$MYSQL_TEST_DIR', 'MYSQL_TEST_DIR')` --echo $_show_slave_status_name = '$_show_slave_status_value' } + + +--disable_query_log +eval SET sql_mode= '$_previous_slave_sql_mode'; +--enable_query_log === modified file 'mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result' --- a/mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result 2012-01-19 15:55:36 +0000 +++ b/mysql-test/suite/rpl/r/rpl_stm_start_stop_slave.result 2012-01-19 20:03:07 +0000 @@ -78,7 +78,7 @@ CHANGE MASTER TO master_log_pos=MASTER_P START SLAVE; include/wait_for_slave_param.inc [Last_IO_Errno] Last_IO_Errno = '1236' -Last_IO_Error = 'Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the start event position from 'master-bin.000001' at XXX, the last event was read from 'master-bin.000001' at XXX, the last byte read was read from 'master-bin.000001' at XXX.'' +Last_IO_Error = 'Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the start event position from 'master-bin.000001' at XXX, the last event was read from './master-bin.000001' at XXX, the last byte read was read from './master-bin.000001' at XXX.'' include/stop_slave.inc RESET SLAVE; RESET MASTER; No bundle (reason: useless for push emails).