Bug #58598 beautify query concatenates USING keyword to table name
Submitted: 30 Nov 2010 16:36 Modified: 6 Jan 2011 15:16
Reporter: Mike Carden Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.30 OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any

[30 Nov 2010 16:36] Mike Carden
Description:
When using Beautify Query on a query that is performing a join with the keyword USING, it concatenates USING to the table name it comes after.

How to repeat:
1) Enter a query having a join with the USING keyword, like

SELECT * FROM table1 LEFT JOIN table2 USING(somecolumn)

2) Go to Edit -> Format -> Beautify Query and it will be formatted like so:

SELECT 
        *
    FROM
        table1 LEFT JOIN table2USING(somecolumn)

which will cause a syntax error
[30 Nov 2010 16:57] Valeriy Kravchuk
Verified just as described on Mac OS X.
[30 Nov 2010 19:27] Alfredo Kojima
This was fixed along with another similar bug.
[8 Dec 2010 20:38] Johannes Taxacher
fix confirmed in repository
[8 Dec 2010 20:38] Johannes Taxacher
will be in 5.2.31
[6 Jan 2011 15:16] Tony Bedford
An entry has been added to the 5.2.31 changelog:

When the Beautify Query facility was used on a query that performed a join with the keyword USING, the table name was concatenated with the USING keyword.