You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "xuyangzhong (Jira)" <ji...@apache.org> on 2021/09/27 02:06:00 UTC

[jira] [Created] (CALCITE-4806) When simplifying 'equals', the data type will be ignore

xuyangzhong created CALCITE-4806:
------------------------------------

             Summary: When simplifying 'equals', the data type will be ignore
                 Key: CALCITE-4806
                 URL: https://issues.apache.org/jira/browse/CALCITE-4806
             Project: Calcite
          Issue Type: Bug
            Reporter: xuyangzhong


the sql is following:
{code:java}
// code placeholder
select cast(1.1 as int) = cast (1 as int){code}
In SQLite the result is 1 and in postgreSQL the result is true.

But in calcite the result is false.

The bug is in RexSimplify and 1.1 and 1 are all converted to java.lang.Comparable, and 1.1 doesn't equal to 1. It ignores the source data type. The literal 1.1 should be cast to 1(int) first.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)