MySQL Bugs: #82147: Syntax error indicator not updated

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:	None
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

Description:
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 SELECT col2 FROM tbl2;
SELECT col3 FROM tbl3;

Correct the syntax error:

SELECT col1 FROM tbl1;
SELECT SELECT col2 FROM tbl2;
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.

Syntax Error Indicator

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

Hello Matthias,

Thank you for the report.

Thanks,
Umesh

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. :)

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.

@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.