MySQL Bugs: #9761: case sensetive problems..

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:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.11	OS:	Linux (Linux (fedoraC2))
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
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..

Greetings
Collen

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:
??

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:

  http://lists.mysql.com/internals/24465

Fixed in 4.1.12 and 5.0.6.

Noted in 4.1.12, 5.0.6 changelogs.