[jira] [Created] (CALCITE-847) Using both Avg aggregate function and Avg window function leads to AssertionError

[Sean Hsuan-Yi Chu (JIRA)]

Sean Hsuan-Yi Chu created CALCITE-847:
-----------------------------------------

             Summary: Using both Avg aggregate function and Avg window function 
leads to AssertionError
                 Key: CALCITE-847
                 URL: https://issues.apache.org/jira/browse/CALCITE-847
             Project: Calcite
          Issue Type: Bug
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Sean Hsuan-Yi Chu


For example, 
{code}
select avg(deptno), avg(deptno) over ()
from emp
group by deptno
{code}

gives 
{code}
java.lang.AssertionError: Internal error: while converting SUM(`EMP`.`DEPTNO`) 
/ COUNT(`EMP`.`DEPTNO`)
        at org.apache.calcite.util.Util.newInternal(Util.java:792)
        at 
org.apache.calcite.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:96)
        at 
org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:60)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4116)
        at 
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:3566)
        at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:130)
{code}
(Below is truncated.)



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