[
https://issues.apache.org/jira/browse/CALCITE-7485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18075419#comment-18075419
]
Alessandro Solimando commented on CALCITE-7485:
-----------------------------------------------
Thanks for the due diligence, we are not necessarily forced to follow neither
the standard nor any specific DB system (we have several extensions specific to
Calcite), but in this case I agree it makes sense to prevent the usage outside
of window functions, I can't imagine what the function semantics would be
without the ordering imposed by the window.
> 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
> Priority: Major
>
> 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 testFirstAndLastAggFunctionsOfGroupByKeys() {
> final String sql = "select sal, first_value(sal) as sal_first,
> last_value(sal) as sal_last from emp group by sal, deptno\n";
> sql(sql).check();
> } {code}
> maybe we should fix the issue.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
