MySQL Bugs: #39761: Lower/upper case problem

Bug #39761	Lower/upper case problem
Submitted:	30 Sep 2008 15:39	Modified:	1 Oct 2008 12:27
Reporter:	Mr._Burns Miller	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.12	OS:	Windows (XP, SP3)
Assigned to:		CPU Architecture:	Any
Tags:	migration toolkit capital letters lower case upper case

Description:
The migration toolkit shows all database names and table names in lower case letters even if they are in the database with upper case.

e.g.: db6206 instead of DB6206 or table1 instead of Table1.

(Other MySQL tools like Query Browser show it correctly)

The problem now is the creation of table fails, and the bulk data transfer fails as well.
The mySQL server comes up with an error message 'access denied for user xyz' which is only caused by the lower case database and table names.
If I correct the CREATE statement in the details of migration toolkit and save the bulk transfer into a file and correct the lower case to upper case (and execute the sql file using the mySQL query browser) it works.
So how can I get the correct uppercase read out of my database by the migration toolkit?

How to repeat:
1. Create a mySQL database with nam DB_test
2. Create a mySQL table e.g. Table1
3. Insert any fields and data in Table1
4. start the migration toolkit and follow the steps inside
5. If you reach the point where the objects are created (CREATE table) you will see the database and the table with an error message

Thank you for the bug report. I could not repeat see MT report below. I configured both Windows server with: lower_case_table_names = 2.

--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report                                             --
--                                                                            --
-- Title:   Summary Of The Migration Process                                  --
-- Date:    2008-09-30 17:17                                                  --
--------------------------------------------------------------------------------

1. Schema Migration
-------------------

  Number of migrated schemata: 1

  Schema Name:            DB_test
  - Tables:               1
  - Views:                0
  - Routines:             0
  - Routine Groups:       0
  - Synonyms:             0
  - Structured Types:     0
  - Sequences:            0

  Details:

  - Tables
      `DB_test`.`Table1`
      ------------------
  - Views
  - Routines
  - Routine Groups
  - Synonyms
  - Structured Types
  - Sequences

2. Data Bulk Transfer
---------------------

      `DB_test`.`Table1`
      ------------------
          5 row(s) transfered.

End of report.
--------------------------------------------------------------------------------

Comparision of source database and the migrated target

Attachment: source_target.jpg (image/pjpeg, text), 25.48 KiB.

Hello,

Of course it does not really help me if you could not rebuilt the problem.
Now I attached an image which shows the result of migration.
On left hand the original source database. Please note the database name and e.g. the table Folder start with upper case letters.

On the right hand side there is the screenshot after migration to my local database. As you can see the database name has lower case letters and the table name (folder) as well.

I just used the standard settings of the migration toolkit.

You can see the tool changes the upper case letters into lower case ones.
This is of course a problem not only if I want to migrate the database back from my local (testing database) to the server but also in my PHP source, becuase it distinguishes between lower case and upper case!

Thanks for any support!

Hello,

I found out more,

if I use the 'Create Script File for Create Statements' under 'Object Creation Options' and look into the file I see database name and table names have correct upper/lower case.
If I manually execute the file (in MySQL Query Browser) I also get the database name and table names in lower case letters. :-(

So my question is there a general setting in my local database which avoids upper case letters for database name and table names?

Thanks for any support!