Fix start of comment detection at beginning of line
When editing SQL code in dbForge for MySQL 7.3.137, there is a case where it fails to detect the "start of comment" delimiter, and incorrectly intreprets the remaining text on the line as SQL code. This breaks the syntax highlighter, auto-complete, and ability to save stored procedures, functions, etc.
Specifically, when using a double-dash "--" to start a comment in MySQL, it normally requires whitespace after the double-dash to be interpreted as a start of comment delimiter. However, when the double dash is at the beginning of a line, it does not require whitespace.
See: https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
Example:
-- This is a valid comment
--This is also a valid comment
Eric Rasmussen
shared this idea
-
AdminDevart
(_, Devart)
commented
Dear User,
Thanks for your patience!
We would like to inform you that a new version of the Studio has now been released, it includes a lot of features and fixes, including the issue you described.
We kindly ask you to update to the latest version of the Studio and check the implementation of the functionality you described in this post. If the issue is still relevant, please let us know in detail by filling out the form on the company’s website (https://www.devart.com/company/contactform.html) or write directly to support@devart.com
Best,
Devart Team