SQL/mySQL syntax highlighting treats comments beginning with hash mark (#) as normal code

[jbullock35]

Short Summary

In mySQL, there are three ways to create comments. One way is to add a hash mark (#) to a line; everything on the line on the hash mark is a comment. But in Komodo IDE 12.0, the characters after the hash mark are highlighted as though they are normal SQL code, not comments. This is so for both the SQL and mySQL file types.

The other two types of comments receive "comment highlighting" in Komodo IDE. That is, they're displayed as comments, not normal code.

Steps to Reproduce

1. Create a file. Specify the mySQL file type.
2. Type # CREATE DATABASE courseEvals DEFAULT CHARACTER SET utf8;
3. Type # Design principle: where the primary key consists of multiple columns, create

Expected results

Normal comment formatting:

Actual results

The lines are highlighted as though they are normal code, not comments:

Platform Information

Komodo IDE, version 12.0.1, build 91869, platform win32-x86. Built on Mon Feb 10 18:14:23 2020.

[th3coop]

Taking a look. If it's as easy as adding # to the MySQL language file then i'll push a fix otherwise it'll be a UDL change and I can't take that on right now.

[th3coop]

@jbullock35, Unfortunately it wasn't as easy a as I'd hoped it would be. I'm not going to be able to get to fixing this properly for now.

[jbullock35]

@th3coop, I understand -- thank you for taking a look.