Incorrect GROUP BY static analysis

Hi,

DataGrip does not seem to be able to understand when I have or haven't added an entry in the SELECT list to the GROUP BY clause. It does this for every single GROUP BY statement, despite them all executing perfectly fine.

Here is a screenshot:

And the whole message is:

Thanks!

5 comments
Comment actions Permalink

What is SQL dialect that you are using? Does Help | Invalidate Caches / Restart action help? 

Is it possible to have a sample query if problem remains? It could be this issue https://youtrack.jetbrains.com/issue/IDEA-145888 . But when I check it - it works for me.

0
Comment actions Permalink

Had the same yesterday.

Closed Datagrip
Removed the C:\Users\username>\AppData\Local\JetBrains\ReSharperPlatformVs14\vAny folder because R# thew an error regarding an unfindable file

Now the issue is gone.
Don't know what exactly did it, but it works now.

0
Comment actions Permalink

Andrey, the Invalidate Caches did not resolve my problem, and my issue does not seem to be quite like the other persons issue in youtrack. I think mine is different, it is on SQL Server, but only seems to happen on very large scripts for me.

Boris, I don't have that exact folder, and I can't see any error for a missing file.

Here is a sample of the script, it's quite large with many inner joins:

And here is the error:

0
Comment actions Permalink

Would you mind to post the query in text format? Thanks.

0
Comment actions Permalink

Same. I use Oracle DB and inspection generates false warnings. It claimes that column is not contained in group by clause although it is contained in GROUP BY. Definitelly bug.

0

Please sign in to leave a comment.