[
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)
