Julian Hyde created CALCITE-551:
-----------------------------------
Summary: Sub-query inside aggregate function
Key: CALCITE-551
URL: https://issues.apache.org/jira/browse/CALCITE-551
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Calcite SQL-to-rel translator cannot handle a sub-query inside an aggregate
function. An example is SqlToRelConverterTest.testAggCaseInSubquery:
{code}SELECT SUM(
CASE WHEN deptno IN (SELECT deptno FROM dept) THEN 1
ELSE 0 END)
FROM emp{code}
Similar issue CALCITE-516 involves IN with constant list inside an aggregate
function, which is treated similarly to a sub-query but is simpler.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
