MySQL Bugs: #72562: Synchronize model error: Unknown system variable 'lower_case_table

Bug #72562	Synchronize model error: Unknown system variable 'lower_case_table_names'
Submitted:	8 May 2014 2:58	Modified:	9 Dec 2014 16:32
Reporter:	Mark LeMerise	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	6.1.4.11773	OS:	MacOS (10.9.2)
Assigned to:		CPU Architecture:	Any
Tags:	modeling, sync, system

Description:
When running a model synchronization, the wizard fails in the "Check Common Server Configuration Issues" step. The following error is issued:

Fetching schema list.
OK
Operation failed: Unknown system variable 'lower_case_table_names'

The MySQL server (running on CentOS) I'm trying to connect to is 5.0.95 and has the "lower_case_table_names" variables set to 0, per standard MySQL practices for a Unix system. 

It should be noted that I can synchronize just fine with my local MySQL server (5.5), which uses a value of "2" for "lower_case_table_names"

I noticed in the latest release notes a bugfix regarding a "fix" which had MySQL Workbench checking for the system variable "lower_case_table_name" (notice the missing "s" character from the end). Is it possible that this was just a typo in the release notes or perhaps this is how it's stored right now?

How to repeat:
I guess try to synchronize a model with a server running this same setup. I'm not sure if this is related to it being an older version of MySQL, but since the variable is set, it seems like it should work.

I can confirm that WB 6.1.7 on OS X 10.9.3 is affected by this issue, too.

I have worked around this problem (at least for forward engineering) using the "Synchronize with any source" feature.

Same issue here trying to synchronise a 5.0.96 community server.

As previously said i used the "synchronise with any source" feature and it worked fine (thanks Christian Kopp).

The synchronize with any source solves this issue but i can't find any "update model" button in this process.
So i can't solve the other problem I meet which is when i synchronize, my Fks are never considered as sychronized so, each time, workbench drops and create all the fks. With 5.2 versions, i could synchronize FKs by using "update model" when i was sure both were identical.

Please check Development Releases 6.2.2 rc version. Thanks.

I downloaded the 6.2.2 RC.
The problem isn't solved.

Error: Unknown system variable 'lower_case_table_names'

I couldn't repeat with 6.2.3 and server 5.5.40 running on CentOS 6.5.

"I couldn't repeat with 6.2.3 and server 5.5.40 running on CentOS 6.5."

Like previously said i think it's only affecting the old branch of mysql server like 5.0

Just tried with workbench 6.2.3 dans the error is still there;

"Fetching schema list.
OK
Operation failed: Unknown system variable 'lower_case_table_names'"

Thank you for the feedback.

Version 5.0 is not supported anymore. Since bug is not repeatable with any currently supported server version (5.1+) I close it as "Unsupported".