[
https://issues.apache.org/jira/browse/CALCITE-1340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gautam Kumar Parai updated CALCITE-1340:
----------------------------------------
Description:
Queries which fail (or fail with inconsistent errors)
Q1:
{code}select count( * ) over () from emp group by deptno
AssertionError: star should have been expanded.
{code}
Q2:
{code}
SELECT sum(empno), max(empno) OVER (order by deptno)
FROM emp
GROUP BY empno
gives error: Expression 'DEPTNO' is not being grouped
SELECT sum(empno), max(empno) OVER w
FROM emp
GROUP BY empno
WINDOW w as (order by deptno)
gives no error:
{code}
Q3:
{code}
select cume_dist() over w , rank()
from emp
window w as (partition by deptno order by deptno)
Assertion Error: Expression 'DEPTNO' is not being grouped
instead of
Assertion Error: OVER clause is necessary for window functions
{code}
was:
Queries which fail (or fail with inconsistent errors)
Q1:
{code}select count( * ) over () from emp group by deptno
AssertionError: star should have been expanded.
{code}
Q2:
{code}
SELECT sum(empno), max(empno) OVER (order by deptno)
FROM emp
GROUP BY empno
gives error: Expression 'DEPTNO' is not being grouped
SELECT sum(empno), max(empno) OVER w
FROM emp
GROUP BY empno
WINDOW w as (order by deptno)
gives no error:
{code}
Q3:
{code}
SELECT sum(empno), max(empno) OVER (order by deptno)
FROM emp
GROUP BY empno
gives error: Expression 'DEPTNO' is not being grouped
SELECT sum(empno), max(empno) OVER w
FROM emp
GROUP BY empno
WINDOW w as (order by deptno)
gives no error:
{code}
Q4:
{code}
select cume_dist() over w , rank()
from emp
window w as (partition by deptno order by deptno)
Assertion Error: Expression 'DEPTNO' is not being grouped
instead of
Assertion Error: OVER clause is necessary for window functions
{code}
> Window aggregates invalid error/error messages in some cases
> ------------------------------------------------------------
>
> Key: CALCITE-1340
> URL: https://issues.apache.org/jira/browse/CALCITE-1340
> Project: Calcite
> Issue Type: Bug
> Reporter: Gautam Kumar Parai
> Assignee: Gautam Kumar Parai
>
> Queries which fail (or fail with inconsistent errors)
> Q1:
> {code}select count( * ) over () from emp group by deptno
> AssertionError: star should have been expanded.
> {code}
> Q2:
> {code}
> SELECT sum(empno), max(empno) OVER (order by deptno)
> FROM emp
> GROUP BY empno
> gives error: Expression 'DEPTNO' is not being grouped
> SELECT sum(empno), max(empno) OVER w
> FROM emp
> GROUP BY empno
> WINDOW w as (order by deptno)
> gives no error:
> {code}
> Q3:
> {code}
> select cume_dist() over w , rank()
> from emp
> window w as (partition by deptno order by deptno)
> Assertion Error: Expression 'DEPTNO' is not being grouped
> instead of
> Assertion Error: OVER clause is necessary for window functions
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
