[
https://issues.apache.org/jira/browse/CALCITE-2580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16627430#comment-16627430
]
Vladimir Sitnikov commented on CALCITE-2580:
--------------------------------------------
Note: unknownAsFalse would touch many places, not just simplifyCoalesce.
> RexSimplify: coalesce(null > null, true) produces wrong result in
> unknownAsFalse mode
> -------------------------------------------------------------------------------------
>
> Key: CALCITE-2580
> URL: https://issues.apache.org/jira/browse/CALCITE-2580
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.17.0
> Reporter: Vladimir Sitnikov
> Assignee: Julian Hyde
> Priority: Major
> Labels: newbie
> Fix For: 1.18.0
>
>
> checkSimplify2(coalesce(gt(nullInt, nullInt), trueLiteral), "true", "true");
> {noformat}
> java.lang.AssertionError: result mismatch:
> when applied to {}, COALESCE(>(null, null), true) yielded true, and false
> yielded false
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
