Bug #4066 DROP DATABASE case sensitive even if lower-case-table-names > 0
Submitted: 9 Jun 2004 0:36 Modified: 9 Jun 2004 17:29
Reporter: Guilhem Bichot
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.0.20 OS:Any (all)
Assigned to: Guilhem Bichot Target Version:

[9 Jun 2004 0: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 17: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