[CALCITE-551] Sub-query inside aggregate function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 05/Jan/15 23:59
• Updated: 22/Mar/16 01:18
• Resolved: 26/Jan/16 20:39

Description

Calcite SQL-to-rel translator cannot handle a sub-query inside an aggregate function. An example is SqlToRelConverterTest.testAggCaseInSubquery:

SELECT SUM(
  CASE WHEN deptno IN (SELECT deptno FROM dept) THEN 1
  ELSE 0 END)
FROM emp

Similar issue CALCITE-516 involves IN with constant list inside an aggregate function, which is treated similarly to a sub-query but is simpler.

Issue Links

• depends upon: CALCITE-1045 Decorrelate sub-queries in Project and Join
• is related to: CALCITE-516 GROUP BY on a CASE expression containing IN predicate fails
• is related to: CALCITE-816 Represent sub-query as a RexNode
• links to: Julian's dev branch