[
https://issues.apache.org/jira/browse/CALCITE-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16583090#comment-16583090
]
Julian Hyde commented on CALCITE-2469:
--------------------------------------
OK, as long as we're all on the same page.
For the record, contrary to the assertion made in the description of this case,
"not \(x) is null" is the same as "not (\(x) is null)" (because "is null" has
higher precedence than "not") and is therefore equivalent to "x is not null".
If you don't believe me try variations of "select * from emp where not((comm <
100) is null)" at [http://rextester.com/l/postgresql_online_compiler].
> RexSimplify should not optimize 'not(x) is null' to 'x is not null
> ------------------------------------------------------------------
>
> Key: CALCITE-2469
> URL: https://issues.apache.org/jira/browse/CALCITE-2469
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.17.0
> Reporter: pengzhiwei
> Assignee: Julian Hyde
> Priority: Critical
>
> The RexSimplify will optimize the 'not（x) is null' to 'x is not null'.
> However,this is incorrect.It is same to the case 'not（x） is not null' .
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
