...
@NonNls @Language("MySQL") finalString sql = "select id from t2 where substring(text3, 0) = 'text';";
...
It is highlighted as MySQL. Ok.
Keep file open. Close project. Reopen project. See that there is error mark in substring() call. It looks like SQL-92 highlighting. That's the problem.
Modify file in any way: see that the highlighting is MySQL again.
Description
Type java code with injected MySQL:
...
@NonNls @Language("MySQL") finalString sql = "select id from t2 where substring(text3, 0) = 'text';";
...
It is highlighted as MySQL. Ok.
Keep file open. Close project. Reopen project. See that there is error mark in substring() call. It looks like SQL-92 highlighting. That's the problem.
Modify file in any way: see that the highlighting is MySQL again.
Bug
Open
Normal
Between opening a project and the first file modification injected SQL dialect is always considered SQL-92