Bug 105625 - MySQL SQL formatter uppercase table names
Summary: MySQL SQL formatter uppercase table names
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: future   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords: helpwanted
Depends on:
Blocks:
 
Reported: 2005-07-29 22:54 EDT by Thierry Danard CLA
Modified: 2013-08-01 14:39 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thierry Danard CLA 2005-07-29 22:54:51 EDT
The format SQL option in the SQL scrapbook works great, but it turns the table 
names in uppercase. In MySQL, the convention is to use lower case table names. 
It's more complex than that, see 
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Name_case_sensitivity.h
tml.

I develop with a PC, but the application will be deployed on Linux. As a 
result, I can't use the SQL formatter as it will make my SQL statements 
unusable in my target environment, even if they work in my development 
environment.
Comment 1 John Graham CLA 2006-04-10 16:16:47 EDT
Pending vendor enablement
Comment 2 John Graham CLA 2007-09-06 15:53:50 EDT
moving to enablement category
Comment 3 Brian Fitzpatrick CLA 2008-08-08 12:05:24 EDT
With the additional MySQL support added in 1.5, has this been addressed already?
Comment 4 Brian Fitzpatrick CLA 2009-04-09 11:59:47 EDT
Hung & Brian, do you have any suggestions on this one? 
Comment 5 Brian Fitzpatrick CLA 2009-04-22 12:39:19 EDT
With a lack of resources, this is getting bumped to future.