[jira] [Commented] (CALCITE-4806) Lossy CAST is incorrectly simplified

["duan xiong (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17421056#comment-17421056 ] 

duan xiong commented on CALCITE-4806:
-------------------------------------

[~julianhyde] [~xuyangzhong] Another problem that needs to notice:

In PostgreSQL(same as Mysql):
{code:java}
select cast(5.1 as int) return 5
select cast(5.5 as int) return 6{code}
But In Calcite the both SQL return 5. I think maybe this needs to repair first.

> Lossy CAST is incorrectly simplified
> ------------------------------------
>
>                 Key: CALCITE-4806
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4806
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: xuyangzhong
>            Priority: Major
>
> 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)