[IMPALA-2215] HAVING clause without aggregation not applied properly

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4, impala 2.3
• Fix Version/s: Impala 2.5.0, Impala 2.3.4
• Component/s: Frontend
• Labels: correctness ramp-up
• Target Version: Impala 2.5.0, Impala 2.3.4
• Assignee: Alexander Behm
• Reporter: Alan Choi
• Created: 18/Aug/15 01:04
• Updated: 04/Jan/17 23:58
• Resolved: 06/Feb/16 01:35

Description

The following query has a "having" clause but it doesn't have a group by. This is invalid syntax and should be rejected.

select case when 1=1 then "didit" end as c1 from (select 1 as one) a having 1!=1;

Query: select case when 1=1 then "didit" end as c1 from (select 1 as one) a having 1!=1

+-------+
| c1    |
+-------+
| didit |
+-------+