I am experiencing a strange behaviour since DataGrip 2019.1.X
The SQL-Syntax Highlighting is sometimes simply not working (not identifying columns, schemata, tables as such) or giving me false errors, as it would be stuck somewhere. It seems to be more present in files (my recent SQL-file is only colored 50%) than in consoles, but occurs in both nonetheless.
Attached screenshots make it quite clear:
Syntax highlighting cannot find the query in between the Create Table Statement. Execution of query works fine though.
Second case. Syntax highlighting recognizes columns, schemata, tables etc. in the first query and colors them accordingly.
In the second query there is just nothing highlighted. No function names, no columns, no table names.. In this file, there is also no error before the code shown here, so nothing to interrupt the highlighting.
Also, the syntax detection is reaaaally slow. Marking the whole text here as a comment took minutes:
I tried "invalidate caches / restart". Version is the most recent, problem exists since ~ 2019.1.1