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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.