xiong duan created CALCITE-7100:
-----------------------------------
Summary: Invalid unparse for OVER() in OracleDialect
Key: CALCITE-7100
URL: https://issues.apache.org/jira/browse/CALCITE-7100
Project: Calcite
Issue Type: Bug
Reporter: xiong duan
The SQL:
{code:java}
select sum(count(*)) over() from EMPLOYEE;
{code}
The Calcite generate the Oracle Dialect SQL is:
{code:java}
select sum(count(*)) over(RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED
FOLLOWING) from EMPLOYEE; {code}
Which throws exception in Oracle:
{code:java}
ORA-30485: missing ORDER BY expression in the window specification {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
