Bug #58569 Format - Beautify Query munges "AS" keyword and alias
| Submitted: | 29 Nov 2010 20:45 | Modified: | 6 Jan 2011 14:58 |
|---|---|---|---|
| Reporter: | Steven Maggs | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 5.2.30 | OS: | Any |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
[29 Nov 2010 23:03]
Alfredo Kojima
fixed in repository
[8 Dec 2010 20:25]
Johannes Taxacher
fix confirmed in repository
[6 Jan 2011 14:58]
Tony Bedford
An entry has been added to the 5.2.31 changelog: The Beautify Query facility in the SQL Editor did not recognize the optional AS keyword in table references. When AS was used with a table alias, the beautify function concatenated the AS keyword and alias, which caused any references to the original alias to fail.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 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: The Beautify Query function does not recognize the optional "AS" keyword in table references. When using "AS" with a table alias, the beautify function concatenates the "AS" keyword and alias, which causes any references to the original alias to fail. How to repeat: 1. Enter a query that uses the "AS" keyword in the editor window, such as SELECT a.* from sometable as a 2. From the Edit menu, select Format -> Beautify Query 3. The query will be changed to: SELECT a.* from sometable asa Suggested fix: Correct output is SELECT a.* from sometable as a