Bug #8312 propose generation of requests in capital letter

• Submitted: 4 Feb 2005 9:28
• Modified: 29 Sep 2007 19:27
• Reporter: Mickael Besson
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S4 (Feature request)
• Version: 1.1.4
• OS: Windows (Windows NT4)
• CPU Architecture: Any

[4 Feb 2005 9:28] Mickael Besson

Description:

It will be usefull to generate the requests entirely in capital letter.
Indeed, query cache is case sensitive. When you program an application you have to write all requests into tiny or all in capital letters for better performance
.
MySQL Query Browser uses the two types of syntax :
SELECT * FROM tlp_data

It will be good if we have to choice in general options 
- all requests into tiny
- or all requests in capital letter

with a radio button for example....

How to repeat:
Tools/options

Suggested fix:

see cast functions

[24 Jan 2007 10:28] Jared S

Dont think it has any effect on performance, and after spending hours editing sql scripts, it is good pratice to have keywords in upper case and data descriptors in lower.