search

Komodo / KomodoEdit

Komodo Edit is a fast and free multi-language code editor. Written in JS, Python, C++ and based on the Mozilla platform.
http://www.komodoide.com/komodo-edit
Other
2.15k stars 301 forks source link

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

Open jbullock35 opened 4 years ago

jbullock35 commented 4 years ago

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

Actual results

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

Platform Information

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

th3coop commented 4 years ago

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 commented 4 years ago

@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 commented 4 years ago

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