7 messages in com.mysql.lists.bugsTables names change to lowercase afte...| From | Sent On | Attachments |
|---|---|---|
| Paul Hamer | 23 Jul 2001 05:07 | |
| Matt Wagner | 23 Jul 2001 20:57 | |
| Miguel Angel Solórzano | 25 Jul 2001 12:02 | |
| Miguel Angel Solórzano | 27 Jul 2001 01:14 | |
| Jim Michaels | 31 Jul 2001 15:34 | |
| Miguel Angel Solórzano | 31 Jul 2001 16:10 | |
| Michael Widenius | 10 Aug 2001 02:05 |
| Subject: | Tables names change to lowercase after changing table definition |
|---|---|
| From: | Paul Hamer (pa...@netcase.nl) |
| Date: | 07/23/2001 05:07:20 AM |
| List: | com.mysql.lists.bugs |
Description: Ever since version 3.23.30 or so the table names suddenly change to lowercase when I alter the definition of an existing table. In my 'my.ini' I have put the following line: set-variable = lower_case_table_names=0 The variable value is picked up by mysql as SHOW VARIABLES shows it correctly. In older versions this problem does not exist.
How-To-Repeat: Create a table which a mixed case name. Then change the table definition, for example: ALTER TABLE jCaseId CHANGE id id2 BIGINT NOT NULL; No the table name 'jCaseId' has changed to 'jcaseid'.
Fix: Stop mysql, rename the .frm file back to the correct name. Start mysql
Synopsis: Tables names change to lowercase after changing table definition Submitter-Id: Originator: Paul Hamer Organization: NetCASE MySQL support: none Severity: non-critical Priority: low Category: mysqld Class: sw-bug Release: mysql-3.23.39a
Exectutable: mysqld-nt Environment: Intel Pentium III 600MHz System: Windows 2000 sp1 Compiler: none, downloaded binary distribution Architecture: i