[
https://issues.apache.org/jira/browse/CALCITE-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759620#comment-17759620
]
Zoltan Haindrich commented on CALCITE-5963:
-------------------------------------------
I think instead of restricting this by unknownAs mode; it might worth
considering to simply rewritte it to:
{code}
(x is not null) or null
{code}
and let the existing logic handle the rest
> Simplify 'x OR NOT(x)' to TRUE
> ------------------------------
>
> Key: CALCITE-5963
> URL: https://issues.apache.org/jira/browse/CALCITE-5963
> Project: Calcite
> Issue Type: New Feature
> Reporter: hongyu guo
> Assignee: hongyu guo
> Priority: Major
>
> When unknownAs is TRUE, or type of x is not nullable, Calcite can simpify:
> x OR NOT( x ) ==> TRUE
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
