Hi, I have a SQL like "select aser, sum(amount) over (rows 10 preceding) FROM OrderA group by aser" And it will fail with an error Expression 'amount' is not being grouped, But the attr 'amount' should not need to beging grouped, is that not support now?
And I saw if I have no groupby it will generate LogicalProject, else it will be LogicalAggregate. Cause I need a window relnode, if project I can use the ProjectToWindowRule, but with aggregate relnode, It seems difficult to get the window, Is there any method ? Thanks very much. Best, Yuhong
