Bug #16067 two schemas with same name will cause some serious error

• Submitted: 29 Dec 2005 10:53
• Modified: 30 Dec 2005 1:27
• Reporter: ming lu
• Status: Can't repeat
• Category: MySQL Administrator
• Severity: S1 (Critical)
• Version: 1.1.2
• OS: Linux (linux)
• Assigned to: Aleksey Kishkin
• CPU Architecture: Any

[29 Dec 2005 10:53] ming lu

Description:
run mysql-administrator, then create two schemas with same name.
create schema DB1;
create schema db1;
choose the schema db1, then create a new table named table1 with the table editor. Save the table, then you will find the table1 has been saved in the schema DB1 instead of db1.  This is a problem caused by lowercase and uppercase in linux Os.

How to repeat:
see the description

[29 Dec 2005 11:30] Aleksey Kishkin

lu ming, was not able to reproduce it on slackware linux against MA 1.15 and mysql 5.0. It's intended behaviuor on windows but for linux tables is created in appropriate database. 

BTW what mysql server version do you use?

[30 Dec 2005 1:27] ming lu

my test environment:
os : red hat9
mysql server : 5.0.12
mysql administrator : 1.1.2

I just do this test a moment ago, the problem already exists.

[30 Dec 2005 7:59] Jens Schanz

With MySQL-Admin 1.1.5, SuSE 10.0 and MySQL-5.0.17 this problem doesn't occure. The table will be placed in the database you have selected