Bug #28752 binlog_format variable is empty when binlog is turned off

Submitted:	29 May 2007 15:44	Modified:	6 Jul 2007 3:43
Reporter:	Daniel Fischer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Row Based Replication ( RBR )	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Mats Kindahl	CPU Architecture:	Any

Description:
The binlog_format system variable is shown as empty when mysqld is run with binlog disabled.

How to repeat:
Run mysqld with binlog disabled and SHOW VARIABLES LIKE "binlog_format"

Suggested fix:
Make it say "OFF" or "DISABLED" or "UNKNOWN" or maybe something funny. :)

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/27995

ChangeSet@1.2536, 2007-06-02 21:01:30+02:00, mats@kindahl-laptop.dnsalias.net +1 -0
  BUG#28752 (binlog_format variable is empty when binlog is turned off):
  Setting MIXED format instead of UNSPECIFIED format when server is
  started without log-bin.

Pushed into 5.1.20-beta

Noted in 5.1.20 changelog.

The binlog_format system variable value was empty if the server was
started with binary logging disabled. Now it is set to MIXED.

Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.