Bug #82147 Syntax error indicator not updated
Submitted: 7 Jul 2016 11:38 Modified: 7 Jul 2016 11:49
Reporter: Matthias Maier Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.7 OS:Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: error, icon, indicator, syntax

[7 Jul 2016 11:38] Matthias Maier
After fixing the syntax in a line that previously had a syntax error the error indicator icon is not removed.

How to repeat:
Insert a few correct lines into editor, e.g.:

SELECT col1 FROM tbl1;
SELECT col2 FROM tbl2;
SELECT col3 FROM tbl3;

Provoke a syntax error in one line, e.g.:

SELECT col1 FROM tbl1;
SELECT col3 FROM tbl3;

Correct the syntax error:

SELECT col1 FROM tbl1;
SELECT col3 FROM tbl3;

Error indicator is not removed/switched back to blue bullet.

Suggested fix:
Check every line for errors and set error indicator accordingly.
[7 Jul 2016 11:39] Matthias Maier
Syntax Error Indicator

Attachment: 2016-07-07 13_38_59-Syntax Error.png (image/png, text), 13.46 KiB.

[7 Jul 2016 11:49] MySQL Verification Team
Hello Matthias,

Thank you for the report.

[17 Jul 2016 15:48] Kevin Hollingshead
Same problem here, can be cleared by selecting all and then the little broom icon in the toolbar toward the right (Beautify/reformat...), kinda like back in the day when you actually had to compile to see errors. :)
[19 Jul 2016 20:23] M Croucher
The clearing of the little red "x" worked perfectly on version 6.3.6; but after I upgraded to the latest version, 6.3.7, I am experiencing the same issue with the little red "x" not clearing after correcting the syntax error.  (The little broom doesn't work for me.)  Its really difficult to find syntax errors with a bunch of little red "x"'s all over the page.  Unfortunately, I cannot downgrade because I need security patch that is in 6.3.7 that is not in 6.3.6.
[21 Jul 2016 4:49] Kevin Hollingshead
@M Croucher, the way I get rid of them is to first select all text in the editor (Ctrl + A), then click the paint brush. This reformats the query and removes the error icons, which is maybe nice but not what I want, so I then undo the reformat with a Ctrl+Z and the error icons don't recur.