Bug #60576 Workbench adds a extra quote
Submitted: 22 Mar 2011 1:23 Modified: 17 Jun 2011 19:14
Reporter: Ivan Cachicatari Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.33 OS:Any (Ubuntu 10.10, Mac OS X)
Assigned to: CPU Architecture:Any

[22 Mar 2011 1:23] Ivan Cachicatari
Description:
Is a non-critical bug from Workbench SQL Editor using the  beautify-query tool.
When you use that tool twice you will get a extra quote at the end of query.

How to repeat:
When you use beautify-query  tool (Ctrl + B) on a query:

SELECT Table.Field1, Table.Field2, Table.Field3 FROM DB.Table;

You will get:

SELECT 
    `Table`.`Field1`, `Table`.`Field2`, `Table`.`Field3`
FROM
    `DB`.`Table`;

But if you modify the new query text and apply beautify-query again you will get a extra quote at the end of query:

SELECT 
    `Table`.`Field1`, `Table`.`Field2`, `Table`.`Field5`
FROM
    `DB`.`Table``;
[22 Mar 2011 4:24] Valeriy Kravchuk
Thank you for the bug report. Verified on Mac OS X also.
[17 Jun 2011 19:14] Paul Dubois
Noted in 5.2.35 changelog.

The query beautifier added superfluous identifier quote characters to
the end of some queries.