[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
Please sign in to leave a comment.
I can't reproduce the issue in DataGrip 2018.3.1. Could you email me full IDE & Database logs to vasily.chernov@jetbrains.com ?
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.