[Resolved] Cant count the number of records when != is in filter

Completed

[[ Resolved in DataGrip 2018.3.1 ]]

 

When I try to select the number of records when I have a != in the filter (company_id = 35 and author_id != 94) it give this error.   Guessing that something is wrong with the interpreter here.

sql> SELECT COUNT(*) FROM public.bypass_bypass t
WHERE company_id = 35 and author_id != 94
ORDER BY author_id ASC
[2019-01-10 08:07:57] [42803] ERROR: column "t.author_id" must appear in the GROUP BY clause or be used in an aggregate function
[2019-01-10 08:07:57] Position: 96
2 comments
Comment actions Permalink

I can't reproduce the issue in DataGrip 2018.3.1. Could you email me full IDE & Database logs to vasily.chernov@jetbrains.com ?

0
Comment actions Permalink

I just upgraded to 2018.3.1 from 2018.2.3 and I confirm that the problem has been resolved.   Thanks for looking into it.

0

Please sign in to leave a comment.