You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/01/06 00:59:34 UTC

[jira] [Created] (CALCITE-551) Sub-query inside aggregate function

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)