Bug #55787 Server Configuration Defaults do not seem to be reflected in non-selected items

• Submitted: 5 Aug 2010 17:15
• Modified: 29 May 2013 18:43
• Reporter: Wil Moore
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 5.2.25, 5.2.26
• OS: Windows (7)
• Assigned to: Assigned Account
• CPU Architecture: Any

[5 Aug 2010 17:15] Wil Moore

Description:
If the setting: "Make table names case-insensitive" is not checked (using the server default), the drop-down shows "1 - Store in Lowercase, Case Insensitive" which is NOT the correct default on the server.

1 - My server is Ubuntu 10.04
2 - I am running WB on Windows 7
3 - I am connecting via SSH w/ an RSA key

How to repeat:
Open Admin, Select "Advanced" tab, scroll down to "Make table names case insensitive".

Make sure the server does not have this value set before checking this.

Notice the value in the disabled drop-down shows "1 - Store in Lowercase, Case Insensitive". On the server:

mysql -u root -p -e "show variables" | grep -i "lower_case_table_names"

lower_case_table_names           0

Suggested fix:
Show the correct default by actually checking the server variables when presenting this tab.

[28 Aug 2010 11:24] Sveta Smirnova

Thank you for the report.

Have you restarted MySQL server after changing this variable?

[30 Aug 2010 12:54] Wil Moore

updating synopsis.

[30 Aug 2010 12:56] Wil Moore

>Have you restarted MySQL server after changing this variable?

A restart is not necessary. The value is simply incorrect from the beginning.

[30 Aug 2010 16:23] Sveta Smirnova

Thank you for the feedback and explanation: got report wrongly in first place.

Verified as described.

[29 May 2013 18:43] Sergio Andres De La Cruz Rodriguez

The referred drop-down is no longer present in newer MySQL Workbench versions.