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: | |
| 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 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.
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``;