Bug #60742 Beautify Query removes space before table aliases Workbench 5.2.33 rev.7508

• Submitted: 3 Apr 2011 18:18
• Modified: 18 May 2011 2:04
• Reporter: Marcelo Mafra
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: Workbench 5.2.33 revision 7508
• OS: Any (10.6.7)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any
• Tags: beautify query, remove space, table alias, table name

[3 Apr 2011 18:18] Marcelo Mafra

Description:
When using the command Beautify Query, it removes the spaces between table names and table aliases. If you define something like "table_name tn" after applying Beautify Query it will look like "`table_name``tn`" without the space between the table name and the alias. And the grave accent helps to hide it, because it looks like the space is there.

How to repeat:
Type any query like:
SELECT field1,field2 FROM table t

then use the Beautify Query:

SELECT 
    `field1`, `field2`
FROM
    `table_name``t`

and the space is gone.

[18 May 2011 2:04] Paul DuBois

Noted in 5.2.34 changelog.

Beautify Query incorrectly removed spaces between table names and
table aliases.