Bug #70716 Beautifying the SQL script erases comments
Submitted: 24 Oct 2013 1:21 Modified: 5 Dec 2013 23:47
Reporter: Franck Dernoncourt Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.0.7.112.15 OS:Windows
Assigned to: CPU Architecture:Any
Tags: beautify

[24 Oct 2013 1:21] Franck Dernoncourt
Description:
The function "Beautify the SQL script" erases comments (except if located at the beginning of the query).

How to repeat:
Write the query:

SELECT 
    users.user_id
FROM
    moocdb.users -- hello
;

click on "Beautify the SQL script". The " -- hello" will be removed.

Suggested fix:
Comments shouldn't be removed, or at least there should be some option to keep them.
[24 Oct 2013 5:40] MySQL Verification Team
Hello Franck,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[5 Dec 2013 23:47] Alfredo Kojima
duplicate of bug #65523