Vitalii Diravka created CALCITE-2257:

             Summary: Combination of predicates can be proved to be always true
                 Key: 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 
select SAL from EMPNULLABLES_20 where SAL IS NOT NULL OR SAL is null
  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]])
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

Reply via email to