Bug #9761 case sensetive problems..
Submitted: 8 Apr 2005 14:41 Modified: 19 May 2005 1:40
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.11 OS:Linux (Linux (fedoraC2))
Assigned to: Jim Winstead CPU Architecture:Any

[8 Apr 2005 14:41] [ name withheld ]
Got a standard, fedora C2, updated to latest mysql-4.1.11-standard.
starting with extra variable: lower_case_table_names=1

so far so good, executing:

'use database1'
'CREATE TABLE database2.mTables LIKE mTables;'

it gives back an error, mTable not found!!
the table is there, in lower case!, if i execute the line with lower names, the command works.!

so basicly, the part after 'like xxx' does not get lowered, 
(i tested it with a windows setup, and there it works 100%)

played around with lower_case_table_names=0 and 1 and 2..
does not matter..


How to repeat:
just do:

create an table, (jn lower case) and try to copy it like

'CREATE TABLE database2.mTables LIKE mTables;'

with capitals in the table names..

Suggested fix:
[28 Apr 2005 22:30] Bugs System
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:

[7 May 2005 8:02] Jim Winstead
Fixed in 4.1.12 and 5.0.6.
[19 May 2005 1:40] Paul DuBois
Noted in 4.1.12, 5.0.6 changelogs.