Bug #79954 lower_case_table_names not recognized

• Submitted: 13 Jan 2016 13:42
• Modified: 14 Jan 2016 6:30
• Reporter: Phil LECLERCQ
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S5 (Performance)
• Version: 6.3.6
• OS: Windows (Microsoft Windows 7 Professional Service Pack 1)
• CPU Architecture: Any
• Tags: WBBugReporter

[13 Jan 2016 13:42] Phil LECLERCQ

Description:
Hi,

As shown below, the system variable is not recognized when trying to synchronize a model with a schema.

* In the dialog box :
Fetching schema list.
OK
Operation failed: Unknown system variable 'lower_case_table_names'

* At the end of the log file :
14:18:56 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Unknown system variable 'lower_case_table_names'
14:18:56 [ERR][  GRTDispatcher]: worker: task 'wizard task' has failed with error:.Unknown system variable 'lower_case_table_names'
----------------

MySql version : 5.0.51a

How to solve this problem ?
Thanks in advance.
Best regards from France.
Philippe

How to repeat:
The problem occurs when using MySql 5.0.51a.

[14 Jan 2016 6:30] MySQL Verification Team

Hello Phil LECLERCQ,

Thank you for the report.

Thanks,
Umesh

[22 Sep 2017 19:27] Stuart Miller

I'm currently using Workbench 6.3.9 and mysql 5.1.30. When I migrated over my dev schema to the production schema, I got this message.