Bug #58367 Beautify two query error
Submitted: 22 Nov 2010 0:02 Modified: 26 Nov 2010 10:57
Reporter: arnaud lemercier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.30 OS:Microsoft Windows (7)
Assigned to: Alfredo Kojima CPU Architecture:Any

[22 Nov 2010 0:02] arnaud lemercier
Description:
Hello,

When I format my code containing several queries. The code is totally wrong.

Ex :
BEFORE
-------
SELECT * FROM Table1;
SELECT * FROM Table2;

AFTER
-------
SELECT 
        *
    FROM
        Table1
SELECT 
        *
    FROM
        Table2

SELECT * FROM Table2;

How to repeat:
1- Create two query like :
   SELECT * FROM Table1;
   SELECT * FROM Table2;
2- Edit > Format > Beautiful

Suggested fix:
;)
[24 Nov 2010 15:35] Johannes Taxacher
fix confirmed in repository
[26 Nov 2010 10:57] Tony Bedford
An entry has been added to the 5.2.31 changelog:

In the SQL Editor, when the beautifier was run on code containing several statements, the code was incorrectly formatted.