Bug #17661 information_schema.SCHEMATA returns uppercase with lower_case_table_names = 1

Description:
MySQL server 5.0.18 with latest PHP/Connector (5.0.18) and PHP 5.1.2

with lower_case_table_names = 1 (default)

different cases for SCHEMA name returned from information_schema

information_schema.SCHEMATA gives `Test`
information_schema.TABLES gives `test`

to (re)produce this i renamed the directory in the filesystem after creating `Test` from 'test' to 'Test' (as MySQL creates all databases in lowercase with lower_case_table_names = 1) - i need to do this to reproduce a bug reporting for phpMyAdmin

https://sourceforge.net/tracker/index.php?func=detail&aid=1436171&group_id=23067&atid=3774...

How to repeat:
create database `Test`
rename directory 'test' to 'Test'

SELECT * FROM information_schema.SCHEMATA
SELECT * FROM information_schema.TABLES

Suggested fix:
return information_schema.SCHEMATA in lowercase

Thank you for a problem report. Verified just as described. Looks like a result of "hack", but different results from different tables in INFORMATION_SCHEMA is surely a bug.

I confirm that this problem also exists for Mac OSX (using MySQL 5.0.18-standard on OSX 10.4.5).

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4063

The patch looks ok to push.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6905

Looks ok to push.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7306

Fixed in 5.0.23

Noted in 5.0.23 changelog.

Results from INFORMATION_SCHEMA.SCHEMATA could contain uppercase
information when lower_case_table_names was not 0.