[CALCITE-6955] PruneEmptyRules does not handle the all attribute of SetOp correctly - ASF JIRA

XML

Word

Printable

JSON

select * from emp where deptno = 10 
union 
select * from emp where 1=0

should be optimized to :

select distinct * from emp where deptno = 10

but now is:

select * from emp where deptno = 10

is related to

CALCITE-6953 Extend UnionEliminatorRule to support Intersect and Minus

links to

GitHub Pull Request #4308