[CALCITE-5507] HAVING alias fails for mixed usage of alias and aggregate function

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.34.0
• Labels: pull-request-available
• Assignee: Jiajun Xie
• Reporter: Jiajun Xie
• Created: 29/Jan/23 06:59
• Updated: 14/Mar/23 13:53
• Resolved: 19/Feb/23 12:54

Description

We know that calcite can support HAVING alias by setting SqlConformanceEnum.LENIENT

sql("select count(empno) as e from emp having e > 10")
    .withConformance(lenient).ok(); 

but when I add one aggregate function in HAVING clause, it will fail.

sql("select count(empno) as e from emp having ^e^ > 10 and count(empno) > 10 ")
    .withConformance(lenient).fails("Column 'E' not found in any table"); 
// I think it should be ok

Issue Links

• links to: GitHub Pull Request #3055