[jira] [Created] (CALCITE-1293) Error when argument to COUNT(DISTINCT) is a GROUP BY column

[Julian Hyde (JIRA)]

Julian Hyde created CALCITE-1293:
------------------------------------

             Summary: Error when argument to COUNT(DISTINCT) is a GROUP BY 
column
                 Key: CALCITE-1293
                 URL: https://issues.apache.org/jira/browse/CALCITE-1293
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


There is a code generation error when argument to {{COUNT(DISTINCT ...)}} is a 
column in the {{GROUP BY}} clause. For example,

{code}
select count(distinct deptno) as cdd, count(*) as c
from emp
group by deptno
{code}

generates code that is invalid ({{!}} operator applied to a {{long}} value):

{noformat}
          public Object current() {
            final Object[] current = (Object[]) inputEnumerator.current();
            return new Object[] {
                current[0],
                current[1],
                !org.apache.calcite.runtime.SqlFunctions.toLong(current[1])};
          }
{noformat}



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