Bug #56015 Online syntax checker does not refresh error icon

• Submitted: 16 Aug 2010 13:47
• Modified: 5 Sep 2012 23:47
• Reporter: Herbert Schneider
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.26
• OS: Windows (XP, version 7)
• CPU Architecture: Any
• Tags: syntax

[16 Aug 2010 13:47] Herbert Schneider

Description:
If I delete charcters in a SQL statement within the SQL Editor window, usually the error indication icon (red cross mark) is displayed to indicate that the SQL syntax is incorrect. When I now add charcters to correct the SQL statement, the error indication icon is still visible. The error icon only disapears after I insert an new line or another windows application get the focus.
Version information:
MySQL Workbench CE for Windows version 5.2.26

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 3.2.0

OS: Microsoft Windows 7  (build 7600), 64-bit

CPU: 4x Intel(R) Core(TM)2 Quad CPU    Q9650  @ 3.00GHz, 7.9 GiB RAM

Video adapter info:

Adapter type: 

Chip Type: Quadro NVS 295

BIOS String: Version 62.98.6e.0.a

Video Memory: 262144 KB

How to repeat:
Delete a charcter within a correct SQL statement and insert the deleted one again.

[16 Aug 2010 13:51] Herbert Schneider

syntax error icon not refreshed

Attachment: SyntaxCheckerError.png (image/png, text), 3.55 KiB.

[16 Aug 2010 15:12] MySQL Verification Team

Thank you for the bug report.

[2 Sep 2010 9:15] Johannes Taxacher

this only affects multiline-statements

[5 Sep 2012 23:47] Philip Olson

Fixed as of the upcoming Workbench 5.2.43, and here's the changelog entry:

 The error icon would continue to be displayed in the SQL editor after
 deleting a character to create the error, and then adding it back. This
 only affected multiline SQL statements. 

Thank you for the report.