[
https://issues.apache.org/jira/browse/CALCITE-847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu updated CALCITE-847:
--------------------------------------
Summary: Avg window function used along with Group-By leads to
AssertionError (was: Using both Avg aggregate function and Avg window function
leads to AssertionError)
> Avg window function used along with Group-By 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)
