[CALCITE-716] Scalar sub-query and aggregate function in SELECT or HAVING clause gives AssertionError

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0-incubating
• Fix Version/s: 1.3.0-incubating
• Assignee: Julian Hyde
• Reporter: Aman Sinha
• Created: 07/May/15 18:53
• Updated: 01/Jun/15 18:24
• Resolved: 13/May/15 19:12

Description

This may be a regression caused by CALCITE-694. Following query hits an AssertionError:

 SELECT emp.deptno FROM emp group by emp.deptno having max(emp.empno) > (select min(emp.empno) from emp);

Stack trace:

java.lang.AssertionError: null
	at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.getNewForOldInput(RelStructuredTypeFlattener.java:291)
	at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitInputRef(RelStructuredTypeFlattener.java:725)
	at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitInputRef(RelStructuredTypeFlattener.java:722)
	at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112)
	at org.apache.calcite.rex.RexShuttle.visitList(RexShuttle.java:134)
	at org.apache.calcite.rex.RexShuttle.visitCall(RexShuttle.java:83)
	at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitCall(RelStructuredTypeFlattener.java:795)
	at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitCall(RelStructuredTypeFlattener.java:722)