Chunwei Lei created CALCITE-5149: ------------------------------------ Summary: Refine RelMdColumnUniqueness for Window by considering partition keys Key: CALCITE-5149 URL: https://issues.apache.org/jira/browse/CALCITE-5149 Project: Calcite Issue Type: Improvement Reporter: Chunwei Lei Assignee: Chunwei Lei
Currently, RelMdColumnUniqueness always returns null when meeting the Window operator. We can improve it by considering its partition keys. For instance, {code:java} select empno, rank () over (partition by empno order by empno) as rn from emp{code} If {{empno}} is the primary key of the table, {{empno}} is unique obviously. -- This message was sent by Atlassian Jira (v8.20.7#820007)