jinxing64 opened a new pull request #1520: [CALCITE-3428] Refine RelMdColumnUniqueness for Filter by considering… URL: https://github.com/apache/calcite/pull/1520 … constant columns (Jin Xing) `AggregateRemoveRule` fails to remove the top `Aggregate` for below SQL ``` select mgr, sum(sum_sal) from (select mgr, deptno, sum(sal) sum_sal from sales.emp group by mgr, deptno) where deptno=100 group by mgr ``` The reason is that `RelMdColumnUniqueness` doesn't take the filtering condition into consideration when checking uniqueness of columns. This PR proposes to refine `RelMdColumnUniqueness` for `Filter`, thus to strengthen `AggregateRemoveRule`. Resolving this Jira will help a lot for CALCITE-3334 by removing the redundant compensation `Aggregate` when doing materialization matching
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
