Bug #58360 query formatter converts non-keywords to uppercase

• Submitted: 21 Nov 2010 12:18
• Modified: 25 Nov 2010 16:37
• Reporter: Giuseppe Maxia
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.30
• OS: Any
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[21 Nov 2010 12:18] Giuseppe Maxia

Description:
The query formatter has an' uppercase/lowercase keyword' feature, which should only act on SQL keywords.
However, in at least one case, it converts to uppercase tokens that should not.
For example, in this statement:

alter table t1 
partition by range (i)
(
  partition mypart001 values less than (20)
, partition mypart002 values less than (30)
);

After invoking 'UPPERCASE Keyword', the result was this:

ALTER TABLE t1 
PARTITION BY RANGE (i)
(
  PARTITION MYPART001 VALUES LESS THAN (20)
, PARTITION MYPART002 VALUES LESS THAN (30)
);

The partition names should not be touched.

How to repeat:
see above example.

[24 Nov 2010 15:40] Johannes Taxacher

fix confirmed in repository

[25 Nov 2010 16:37] Tony Bedford

An entry has been added to the 5.2.31 changelog:

In the SQL Editor, the query formatter converted certain tokens to uppercase that should not have been converted.