Vitalii Diravka created CALCITE-2257:
----------------------------------------
Summary: Combination of predicates can be proved to be always true
Key: CALCITE-2257
URL: https://issues.apache.org/jira/browse/CALCITE-2257
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.16.0
Reporter: Vitalii Diravka
Assignee: Vitalii Diravka
Fix For: 1.17.0
I have found the case, when Filter operator is not necessary since filter
condition is always true, but that is not detected by current version of
Calcite.
{code}
select SAL from EMPNULLABLES_20 where SAL IS NOT NULL OR SAL is null
{code}
{code}
LogicalProject(SAL=[$5])
LogicalFilter(condition=[OR(IS NOT NULL($5), IS NULL($5))])
LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4],
SAL=[$5], COMM=[$6], SLACKER=[$8])
LogicalFilter(condition=[AND(=($7, 20), >($5, 1000))])
LogicalTableScan(table=[[CATALOG, SALES, EMPNULLABLES]])
{code}
But filter condition _OR(IS NOT NULL($5), IS NULL($5))_ can be proved to be
always true.
I have tried _ReduceExpressionsRule_, but it doesn't give effect.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
