MySQL Bugs: #114009: '--' does not highlight as comment in SQL editor if following character is tab

Bug #114009	'--' does not highlight as comment in SQL editor if following character is tab
Submitted:	15 Feb 2024 16:39	Modified:	16 Feb 2024 13:19
Reporter:	Michael Beaton	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	8.0.36	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
'--' followed by a space highlights as a comment in the SQL Editor.
'--' followed by a tab does not highlight as a comment, although it is one.

From a quick search in the MySQL Workbench code, some handlers for '--' treat '--' followed by space, tab, cr or lf as a comment, others treat '--' followed by space or any control character as a comment - i.e. I have not so far managed to identify the place in the code where this is mis-parsed.

However, both from the above and from what happens when you run it, '--' followed by a tab definitely is a comment, and should be highlighted as one in the editor.

This may be the same as https://bugs.mysql.com/bug.php?id=66873, which I believe was incorrectly closed - if so, it would be long-standing.

How to repeat:
As above, always occurs

Image showing the issue

Attachment: mysql-tab-comment.png (image/png, text), 20.80 KiB.

Hello Michael,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.