Zhen Chen created CALCITE-6955:
----------------------------------

             Summary: PruneEmptyRules does not handle the all attribute of 
SetOp correctly
                 Key: CALCITE-6955
                 URL: https://issues.apache.org/jira/browse/CALCITE-6955
             Project: Calcite
          Issue Type: Bug
            Reporter: Zhen Chen
            Assignee: Zhen Chen


{code:java}
select * from emp where deptno = 10 
union 
select * from emp where 1=0{code}
should be optimized to :
{code:java}
select distinct * from emp where deptno = 10 {code}
but now is:
{code:java}
select * from emp where deptno = 10 {code}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to