Yu Xu created CALCITE-7485:
------------------------------
Summary: FIRST_VALUE/LAST_VALUE should only be defined for window
aggregates
Key: CALCITE-7485
URL: https://issues.apache.org/jira/browse/CALCITE-7485
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.41.0
Reporter: Yu Xu
FIRST_VALUE and LAST_VALUE are only defined for window aggregates, but can be
used without window clause in current main branch.
test case would be passed as follow：
{code:java}
@Test void testAggregateFunctionOfGroupByKeys() {
final String sql = "select sal, max(sal) as sal_max, min(sal) as sal_min,\n"
+ "avg(sal) sal_avg, any_value(sal) as sal_val,\n"
+ "from emp group by sal, deptno";
sql(sql).check();
} {code}
maybe we should fix the issue.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
