[CALCITE-800] Window function defined within another window function should be invalid - ASF JIRA

Rank to Top

Rank to Bottom

Voters

Watch issue

Watchers

Convert to sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

For instance,

select sum(deptno) over (order by 
sum(deptno) over(order by deptno)) 
from emp

This is an invalid query. However, it passes the validation.

relates to

CALCITE-806 ROW_NUMBER should emit distinct values

Comment