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)