[jira] [Commented] (CALCITE-4749) Division with two operands of integer family can't return value with decimal data type.

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

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

Stamatis Zampetakis commented on CALCITE-4749:
----------------------------------------------

Hey [~yanjing.wang] can you explain why you closed this issue? Since the behavior is different for some DBMS shouldn't Calcite adapt the type system for every dialect of those mentioned in the description. Is it already done?

> Division with two operands of integer family can't return value with decimal data type.
> ---------------------------------------------------------------------------------------
>
>                 Key: CALCITE-4749
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4749
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.27.0
>         Environment: jdk8
> macos
>            Reporter: yanjing.wang
>            Priority: Major
>
> I tested the following sql
> {code:java}
> select cast(1 as bigint) / 1000
> {code}
> Calcite use the least restrictive dataType BIGINT as return type between the BIGINT and INT and result is 0, which is consistent with SQL SERVER and PostgreSQL. Whereas BigQuery, Oracle, MySQL and Spark returns 0.001.
>  
> I think Calcite should support both behaviors.
>  



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