Bug #71459 MySQL Workbench's SQL Query Formatter doesn't change the case of the operators.
Submitted: 23 Jan 2014 16:38 Modified: 21 Aug 2014 1:09
Reporter: Franck Dernoncourt Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.0.8 OS:Windows
Assigned to: CPU Architecture:Any

[23 Jan 2014 16:38] Franck Dernoncourt
Description:
MySQL Workbench's SQL Query Formatter doesn't change the case of the operators.

How to repeat:
Write the query in MySQL Workbench's query editor:

selECT
    f1
from
    tblName;

The SQL Query Formatter ("beautify") doesn't change anything, and doesn't fix selECT into select or SELECT.

Suggested fix:
- check for SQL operators' case
- give option to beautify SQL operator with uppercase or lowercase.
[23 Jan 2014 17:06] MySQL Verification Team
Thank you for the bug report.
[21 Aug 2014 1:09] Philip Olson
Fixed as of the MySQL Workbench 6.2.0 release, and here's the changelog entry:

An option was added that changes keywords to uppercase when using the SQL
beautification tool.

Thank you for the bug report.