xiong duan created CALCITE-6638:
-----------------------------------

             Summary: Simplify '1 > a or 1 <= a or a is null' to TRUE when a 
has lossless casts
                 Key: CALCITE-6638
                 URL: https://issues.apache.org/jira/browse/CALCITE-6638
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.38.0
            Reporter: xiong duan
            Assignee: xiong duan
             Fix For: 1.39.0


Before this PR:
{code:java}
// "OR(IS NULL(?0.a), <(1, CAST(?0.a):INTEGER), >=(1, CAST(?0.a):INTEGER))"
// when (?0.a) is TINYINT
// ==> "OR(IS NULL(?0.a), <(1, CAST(?0.a):INTEGER), >=(1, CAST(?0.a):INTEGER))" 
{code}
After this PR:
{code:java}
// "OR(IS NULL(?0.a), <(1, CAST(?0.a):INTEGER), >=(1, CAST(?0.a):INTEGER))"
// when (?0.a) is TINYINT
// ==> "TRUE"{code}



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

Reply via email to