[CALCITE-1293] Bad code generated when argument to COUNT(DISTINCT) is a GROUP BY column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 15/Jun/16 16:30
• Updated: 27/Feb/24 22:23
• Resolved: 21/May/17 17:45

Description

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

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

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

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