You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/06/26 02:14:04 UTC
[jira] [Created] (CALCITE-774) When Group By clause is present, the
argument in window function should not refer to any column outside Group By
Sean Hsuan-Yi Chu created CALCITE-774:
-----------------------------------------
Summary: When Group By clause is present, the argument in window function should not refer to any column outside Group By
Key: CALCITE-774
URL: https://issues.apache.org/jira/browse/CALCITE-774
Project: Calcite
Issue Type: Bug
Reporter: Sean Hsuan-Yi Chu
Assignee: Sean Hsuan-Yi Chu
An {color:red}invalid{color} query such as:
{code}
select max(empno) over ()
from emp
group by deptno
{code}
This query is invalid because the argument in max (i.e., empno) points at a column which is not present in Group By clause. However, Calcite does not catch it but generate a plan.
Invalid queries should fail early to reduce potential confusion.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)