Bug #56237 Synchronization should match schemas case insensitively
Submitted: 25 Aug 2010 1:05 Modified: 16 Nov 2011 15:38
Reporter: Alfredo Kojima Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2 OS:Any
Assigned to: Alexander Musienko CPU Architecture:Any

[25 Aug 2010 1:05] Alfredo Kojima
Description:
Currently synchronization will match schema names by case. That means if a schema has upper case letters and server is case insensitive, the schema will be created in lowercase during fwd engineering. Future synchronizations will not recognize both schemas as being the same.

This issue is also reported as a comment in bug #54748

How to repeat:
Create schema with uppercase name.
Forward engineer to server in Windows
Synchronize

Suggested fix:
-
[16 Nov 2011 15:38] Philip Olson
Fixed as of 5.2.37:

+        The Forward engineering feature now preserves case for schema
+        names, even on case-insensitive systems. Before it would create
+        lowercase variants of the schema names on these systems.