Sergey Nuyanzin created CALCITE-7041:
----------------------------------------
Summary: Simplify simple contradicting expressions
Key: CALCITE-7041
URL: https://issues.apache.org/jira/browse/CALCITE-7041
Project: Calcite
Issue Type: Improvement
Reporter: Sergey Nuyanzin
For instance
{code:sql}
a > b AND b > a AND a IS NOT NULL AND b IS NOT NULL
{code}
or
{code:sql}
a >= b AND b > a AND a IS NOT NULL AND b IS NOT NULL
{code}
or
{code:sql}
a > b AND b >= a AND a IS NOT NULL AND b IS NOT NULL
{code}
could be simplified to {{FALSE}}
and
{code:sql}
a >= b AND b >= a AND a IS NOT NULL AND b IS NOT NULL
{code}
could be simplified to {{a = b}}
Probably there is something else
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
