Syntax Highlighting not working/incorrect
Hi,
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
Please sign in to leave a comment.
@Mebner
Could you specify your MS SQL Server version?
> 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
Do you attach your files to project?
Do you set correct dialect for your files?
Do you set correct resolution scope for your files and data sources?
> Also, the syntax detection is reaaaally slow. Marking the whole text here as a comment took minutes
Could you email vasily.chernov@jetbrains.com me zipped IDE logs folder?
Hi Vasily,
it's PostgreSQL 10.4, not MS SQL. Forgot to mention, sorry.
> Do you attach your files to project?
The files are from GitLab and the GitLab directory is attached in the Files window, yes.
> Do you set correct dialect for your files?
yes
> Do you set correct resolution scope for your files and data sources?
Project mapping in resolution scope is set to default, "All roots"
> Could you email vasily.chernov@jetbrains.com me zipped IDE logs folder?
yes, I sent you the logs
Thanks!
@Mebner,
Thank you for IDE logs. It looks like the issue is fixed in EAP.
Could you try to reproduce the issue with DataGrip 2019.2 EAP 3?
@vasily,
thanks, I could not reproduce the issue in the EAP version!