SQL comment yields wrong highlighting

[fabsenet]

I have the following sql. Yes, I have sql queries in database tables. Do not judge me 🐇

This is the code i want to highlight:

INSERT INTO MESSAGESEARCHPATTERN (name, query)
VALUES ('a','select ''hello world'' from a')

-- this is a comment

INSERT INTO MESSAGESEARCHPATTERN (name, query)
VALUES ('a','select ''hello world'' from a')

this is, what the test page/prismjs makes from it (language is SQL):

[yakov116]

@fabsenet me too 😀

I however use it more for documentation.

[Golmote]

From a really quick look at it, it appears to be more about the '' part of the string than about the comment. I think our component does not handle "quote-escaped quotes" (is there a name for this?) in the string pattern at the moment.