[
https://issues.apache.org/jira/browse/CALCITE-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17298278#comment-17298278
]
Julian Hyde commented on CALCITE-4525:
--------------------------------------
Could you devise a SQL query that shows this problem? For example, in
{code}
SELECT *
FROM (
SELECT deptno AS x, deptno AS y
FROM dept
WHERE x < 20)
WHERE y < 30
{code}
is the {{Filter(y < 30)}} correctly eliminated?
> Pull up predicate will loss some predicates when project contains same
> RexInputRef.
> ------------------------------------------------------------------------------------
>
> Key: CALCITE-4525
> URL: https://issues.apache.org/jira/browse/CALCITE-4525
> Project: Calcite
> Issue Type: Improvement
> Reporter: Ziwei Liu
> Assignee: Ziwei Liu
> Priority: Major
>
> If project like this a=$0, b=$0
> Pull up predicate is $0='a'
> when pull up through project, predicate will only contain b='a'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
