Bug #4066 DROP DATABASE case sensitive even if lower-case-table-names > 0
Submitted: 8 Jun 2004 22:36 Modified: 9 Jun 2004 15:29
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.20 OS:Any (all)
Assigned to: Guilhem Bichot CPU Architecture:Any

[8 Jun 2004 22:36] Guilhem Bichot
Description:
Your MySQL connection id is 2 to server version: 4.1.3-beta-valgrind-max-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

MASTER> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+
1 row in set (0.06 sec)

MASTER> drop database ZZ;
ERROR 1008 (HY000): Can't drop database 'ZZ'; database doesn't exist
MASTER> drop database zz;
Query OK, 0 rows affected (0.08 sec)

How to repeat:
see description

Suggested fix:
in mysql_rm_db(), move the test for lower_case_table_names up.
[9 Jun 2004 15:29] Guilhem Bichot
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Fixed in ChangeSet@1.1850, 2004-06-09 15:27:15+02:00, guilhem@mysql.com