Bug #70716 Beautifying the SQL script erases comments

• Submitted: 24 Oct 2013 1:21
• Modified: 5 Dec 2013 23:47
• Reporter: Franck Dernoncourt
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.0.7.112.15
• OS: Windows
• 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