From: Date: October 22 2008 3:53pm Subject: bzr commit into mysql-5.1 branch (sven:2771) Bug#39812 List-Archive: http://lists.mysql.com/commits/56815 X-Bug: 39812 Message-Id: <20081022135338.115F8B70BE@riska> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit #At file:///home/sven/bzr/b39812-statement_default/5.1-5.1.29-rc/ 2771 Sven Sandberg 2008-10-22 BUG#39812: Make statement replication default for 5.1 (to match 5.0) Added test case to check the default value of @@binlog_format. modified: mysql-test/r/binlog_format_basic.result mysql-test/t/binlog_format_basic.test per-file messages: mysql-test/t/binlog_format_basic.test Added test case to verify the default binlog_format: it should be STATEMENT in 5.1 and MIXED in 6.0. === modified file 'mysql-test/r/binlog_format_basic.result' --- a/mysql-test/r/binlog_format_basic.result 2008-04-10 13:14:28 +0000 +++ b/mysql-test/r/binlog_format_basic.result 2008-10-22 13:53:26 +0000 @@ -1,3 +1,6 @@ +SELECT @@GLOBAL.binlog_format; +@@GLOBAL.binlog_format +MIXED '#---------------------BS_STVARS_002_01----------------------#' SELECT COUNT(@@GLOBAL.binlog_format); COUNT(@@GLOBAL.binlog_format) === modified file 'mysql-test/t/binlog_format_basic.test' --- a/mysql-test/t/binlog_format_basic.test 2008-04-10 13:14:28 +0000 +++ b/mysql-test/t/binlog_format_basic.test 2008-10-22 13:53:26 +0000 @@ -22,6 +22,13 @@ # # ############################################################################### +################################################################### +# BUG#39812: Make statement replication default for 5.1 (to match 5.0) +# We just verify that the default binlog_format is STATEMENT in 5.1. +# In 6.0, it should be MIXED. +################################################################### +SELECT @@GLOBAL.binlog_format; + --echo '#---------------------BS_STVARS_002_01----------------------#' #################################################################### # Displaying default value #