[IMPALA-2919] Wrong results when query has a HAVING clause but no aggregate or grouping exprs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.2.4
• Component/s: Frontend
• Labels: sql-language usability
• Assignee: Alexander Behm
• Reporter: Dimitris Tsirogiannis
• Created: 01/Feb/16 23:32
• Updated: 02/Feb/16 06:25
• Resolved: 02/Feb/16 06:25

Description

To reproduce:

create table foo(a int);
insert into foo values (1), (1);
select 1 from foo having count(*) = 1; 
1
1
select 1 from foo having count(*) = 2;
1
1

In Postgres the same queries return:

select 1 from foo having count(*) = 1; 
(0 rows)
select 1 from foo having count(*) = 2;
1