Syntax Highlighting not working/incorrect

Completed

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

6 comments
Comment actions Permalink

@Mebner

Could you specify your MS SQL Server version?

 

0
Comment actions Permalink

> 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?

 

 

0
Comment actions Permalink

> 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?

0
Comment actions Permalink

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!

1
Comment actions Permalink

@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?

0
Comment actions Permalink

@vasily,

thanks, I could not reproduce the issue in the EAP version!

0

Please sign in to leave a comment.