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/09/07 20:35:45 UTC

[jira] [Created] (CALCITE-878) Allow ORDER BY within COLLECT (an Oracle extension)

Julian Hyde created CALCITE-878:
-----------------------------------

             Summary: Allow ORDER BY within COLLECT (an Oracle extension)
                 Key: CALCITE-878
                 URL: https://issues.apache.org/jira/browse/CALCITE-878
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Oracle allows ORDER BY within the COLLECT aggregate function, e.g. {code}SELECT deptno, COLLECT(emp_type(ename, sal) ORDER BY sal DESC) emps
FROM emp
GROUP BY deptno{code}

This is an Oracle-specific extension to SQL:2011 but nevertheless useful and worth considering.

Note that Calcite already supports DISTINCT within COLLECT.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)