Bug #69672 Wrong display of "innodb_file_format_check" option default value
Submitted: 4 Jul 2013 17:32 Modified: 30 Jul 2013 19:21
Reporter: Roman Syroeshko Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version: CE OS:Windows (7 Home Basic 64-bit)
Assigned to: CPU Architecture:Any
Tags: default value, innodb_file_format_check

[4 Jul 2013 17:32] Roman Syroeshko
By default, the "innodb_file_format_check" option has "ON" in MySQL 5.6 (see http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_file_format_ch...).

In the same time MySQL Workbench administration tool:
a) "says" that this option is turned off;
b) suggest text values for this option instead of boolean.

How to repeat:
1. Open my.ini file of your MySQL Server 5.6 and make sure that the "innodb_file_format_check" is absent there.

2. Open MySQL Workbench administration tool and in "Status and System variables" section make sure that the "innodb_file_format_check" is ON. That's OK. That's by default.

3. Then go to the "Options File" section, open "InnoDB" tab and make sure:
- "innodb_file_format_check" flag in unset;
- if you set "innodb_file_format_check" flag, I offers you to set string value instead of boolean.

Suggested fix:
1. "innodb_file_format_check" option should be set by default.
2. "innodb_file_format_check" option should have only checkbox (no any inputs).
[4 Jul 2013 17:33] Roman Syroeshko
"InnoDB" tab screenshot.

Attachment: wrong_innodb_file_format_check_displayed_value.png (image/png, text), 148.52 KiB.

[5 Jul 2013 6:11] MySQL Verification Team
Hello Roman,

Thank you for the bug report. 
Verified as described.

[30 Jul 2013 19:21] Philip Olson
Fixed as of MySQL Workbench 6.0.4, and here's the changelog entry:

The "innodb_file_format_check" option was set as a String in the
MySQL Workbench GUI, but it is now set with a (Boolean) checkbox.

Thank you for the bug report.