MySQL Bugs: #27183: Uppercase tablenames causing problems with newer connectors and tools

Bug #27183	Uppercase tablenames causing problems with newer connectors and tools
Submitted:	15 Mar 2007 16:22	Modified:	21 Mar 2007 22:04
Reporter:	Enrico Zanolin	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.14	OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
Probably related to 

http://bugs.mysql.com/bug.php?id=26812

I cannot access uppercase table names with the 3.51.14 connector but It works fine with 3.51.12

I am connecting to a Linux server running "5.0.24a-Debian_9-log via TCP/IP"

I also cannot edit the tables using the new (v1.2.10 client 5.1.11)  MySQL Administrator but the older version (v1.1.6 client 5.0.11) works fine.

I don't want to waste anyones time but I would like to make sure that the bug is addressed in the ODBC driver.

Thanks

How to repeat:
Try to access any table name containing an uppercase char with the ODBC connector or try and edit a table like that from MySQL Administrator v1.2.10.

Connecting from Access -> Fedora Core 6

Attachment: uppercase-odbc.png (image/x-png, text), 51.95 KiB.

Thank you for the bug report. I was able to connect using Access 2003
with a server 5.0.40 source compiled running on Fedora Core 6. I attached
a picture showing that.

delphi exception error

Attachment: screen.GIF (image/gif, text), 17.54 KiB.

OK, possibly it's not the same bug. Here is a screencap of the error I'm getting from my delphi application. http://bugs.mysql.com/file.php?id=6009. the highlighted line is where the error occurs. If the table does not have any uppercase letters then I don't  get the error. Also not that the first access to the table works fine. I also don't get this error under 3.51.12

Thanks.