[
https://issues.apache.org/jira/browse/CALCITE-7619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18090907#comment-18090907
]
Yu Xu edited comment on CALCITE-7619 at 6/23/26 12:34 PM:
----------------------------------------------------------
In my opinion, simplifyIs1 directly prevents IS_FALSE( x ) → NOT x from
occurring when x is nullable. This is the least modified and most localized
solution, ensuring that simplifyPreservingType does not result in an expression
that requires forced CAST.
was (Author: JIRAUSER307770):
In my opinion, simplifyIs1 directly prevents IS_FALSE(x) → NOT x from occurring
when x is nullable. This is the least modified and most localized solution,
ensuring that simplifyPreservingType does not result in an expression that
requires forced CAST.
> RexSimplify incorrectly simplifies IS_FALSE(x) when x is nullable
> -----------------------------------------------------------------
>
> Key: CALCITE-7619
> URL: https://issues.apache.org/jira/browse/CALCITE-7619
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.42.0
> Reporter: Mihai Budiu
> Priority: Minor
> Fix For: 1.43.0
>
>
> The expression is reduced to CAST(NOT(x) AS BOOLEAN NOT NULL). This is wrong
> when x is NULL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)