MySQL Bugs: #63698: Workbench showing same table on different databases.

Bug #63698	Workbench showing same table on different databases.
Submitted:	9 Dec 2011 16:21	Modified:	12 Dec 2011 14:51
Reporter:	Leonardo Hernandez	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.35	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	case, database, duplicated, name, sensitive, tables

Description:
When you have 2 or more database with the same name but different cases, Workbench

Looks like when workbench looks for the table schema information, it indexes the tables under a key (database name) that's not key sensitive.

Example:
> create database RADIO;
> create database Radio;
> create database radio;

Now create a table inside any of those databases and you will notice Workbench show the table in all the databases;

How to repeat:
1. create 2 or more databases, example: radio, Radio, RADIO

2. create a table on any of those databases

3. use the "refresh all" option in workbench

4. go to any of the databases recently created, you will see the table

Databases

Attachment: Radio-RADIO-radio.png (image/png, text), 53.07 KiB.

I couldn't repeat running WorkBench on Windows 7 connecting the MySQL server on Ubuntu (see prior attached screen-shot showing the table t1 only in the database called radio and not on Radio or RADIO databases). Please describe the environment which you found that behavior. Thanks.

Please try version 5.2.36 too. Thanks.

Remember to "refresh all" after creating the tables. I tested on Win7, Linux (ubuntu) and Mac OS environment. 

Gonna check version 5.2.36 too.

case sensitive table duplicated bug

Attachment: workbench.png (image/png, text), 16.55 KiB.

Can't reproduce on version 5.2.36 (fixed I guess).

Closed, Reporter can't reproduce the bug anymore.