SQL: use of agg function in HAVING with no grouping emits wrong error message #57125
Description
A(n incorrect) query like SELECT salary FROM employees HAVING salary = count(1) will generate an error message, but a misleading one:
"Found 1 problem\nline 2:46: Cannot use WHERE filtering on aggregate function [count(1)], use HAVING instead".