[ https://issues.apache.org/jira/browse/CALCITE-3249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-3249: ------------------------------------ Labels: pull-request-available (was: ) > Substitution#getRexShuttle does not consider RexLiteral > ------------------------------------------------------- > > Key: CALCITE-3249 > URL: https://issues.apache.org/jira/browse/CALCITE-3249 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: jin xing > Assignee: jin xing > Priority: Minor > Labels: pull-request-available > > Current {{Substitution#getRexShuttle}} does not take {{RexLiteral}} into > consideration. > Thus below query & mv fails matching: > {code:java} > MV: > select deptno, sum(salary), sum(commission), sum(k) > from > (select deptno, salary, commission, 100 as k > from emps) > group by deptno > Query: > select deptno, sum(salary), sum(k) > from > (select deptno, salary, 100 as k > from emps) > group by deptno > {code} > The root cause is that {{ProjectToProjectUnifyRule}} compensates a > {{Project}} which contains {{RexLiteral}}, but > {{AggregateOnProjectToAggregateUnifyRule}} works only when the {{Project}} in > query is a mapping > https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/plan/SubstitutionVisitor.java#L1357 -- This message was sent by Atlassian JIRA (v7.6.14#76016)