bug#54769: 28.1; Incorrect sql comment highlighting

[emacsq]

Attached a small test.sql file where the statement after the comment incorrectly gets comment face.

Looks like the two kinds of comment styles confuses the highlighter:

"You can include a comment in a statement in two ways:

Begin the comment with a slash and an asterisk (/*). Proceed with the text of the comment. This text can span multiple lines. End the comment with an asterisk and a slash (*/). The opening and terminating characters need not be separated from the text by a space or a line break.

Begin the comment with -- (two hyphens). Proceed with the text of the comment. This text cannot extend to a new line. End the comment with a line break.

"

If you remove the hyphens from the /* */ comment then the higlighting is correct.

Such SQL worked fine for me with 27.1, so something must have happened since then.

test.sql
Description: application/sql