[
https://issues.apache.org/jira/browse/CALCITE-4749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yanjing.wang closed CALCITE-4749.
---------------------------------
Resolution: Implemented
The implementation has been delegated to
RelDataTypeSystem#deriveDecimalDivideType(RelDataTypeFactory, RelDataType,
RelDataType), so we can override the method to support custom divide return
type.
> 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)
