Single-quoted variables not working for SQL highlighting

[H3dg3]

According to the examples, the following should work, but it does not
SET @'quoted-variable' = 3;
All other quoted variable examples do work, i.e. the following:

SET @variable = 1;
SET @$_ = 2;
SET @"quoted-variable" = 3;
SET @`quoted-variable` = 3;

[RunDevelopment]

Cannot reproduce.

Are you also using some plugin or do have other code which also produces the error?

[H3dg3]

I can reproduce it like this:

SET @'quoted-variable' = 3;
SET @'quoted-variable' = 3;

It seems to be a multiline issue. I will try to assemble a minimal example.

[H3dg3]

Here you go: https://jsfiddle.net/zL9hbdo4/2/
I hope a fiddle is OK.

[RunDevelopment]

Thank you for providing this example.
I have found the problem and will provide a fix soon.

[RunDevelopment]

While the simple example of

SET @'quoted-variable' = 3;
SET @'quoted-variable' = 3;

is now working correctly, due to a greedy matching bug (#1492) the other example is still not highlighted correctly.

CREATE USER 'user'@'server-ip' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON scheme.* TO 'user'@'server-ip' WITH GRANT OPTION;

[RunDevelopment]

I used a littly trick to by pass the greedy bug. I won't work 100% of the time but it should solve your issue.

[H3dg3]

I just tested with the last commit on my end and it works like a charm. Hope the fix makes it into the 1.16.0 👍