[
https://issues.apache.org/jira/browse/CALCITE-4749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17403493#comment-17403493
]
yanjing.wang commented on CALCITE-4749:
---------------------------------------
No, it isn't. I close it because I can solve this issue by override the
RelDataTypeSystem#deriveDecimalDivideType method. I have no idea about how
calcite adapts the type system for every dialect, because the type system seems
to be independent of dialect.
> 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)
