Bug #49540 DEFAULT value of binlog_format isn't the default value
Submitted: 8 Dec 2009 19:14 Modified: 14 Mar 2010 1:15
Reporter: Sergei Golubchik Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[8 Dec 2009 19:14] Sergei Golubchik 
Description:
set global binlog_format=DEFAULT sets to MIXED, not to STATEMENT

How to repeat:
set global binlog_format=DEFAULT;
select @@global.binlog_format;
[8 Dec 2009 19:14] Sergei Golubchik 
fixed in WL#4738
[6 Mar 2010 11:03] Bugs System 
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@fedora12-20091225154921-x25a5pyw1pxiwobv) (merge vers: 5.5.99) (pib:16)
[14 Mar 2010 1:15] Paul DuBois 
Noted in 5.5.3 changelog.

Setting binlog_format to DEFAULT assigned a value different from the
default.