Bug #3109 | lower_case_table_names=2 isn't honored when creating index | ||
---|---|---|---|
Submitted: | 8 Mar 2004 12:22 | Modified: | 23 Jun 2004 8:51 |
Reporter: | Miguel Solorzano | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 4.0 | OS: | Windows (Windows) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[8 Mar 2004 12:22]
Miguel Solorzano
[29 Mar 2004 6:06]
Parwinder Sekhon
Just voted for this. I work on a persistence layer that relies on getting meta-data, and this is case-sensitive. It relies on using foreign keys, and to use foreign keys we have to add indexes, hence the effect on case of table names.
[30 Mar 2004 10:28]
Parwinder Sekhon
Actually this is not just a problem with ALTER TABLE ADD INDEX, it seems like it is a problem with ALTER TABLE. I get the ALTER TABLE ADD COLUMN.
[23 Jun 2004 8:51]
Michael Widenius
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: Fix will be in 4.0.21 and 4.1.3.