[
https://issues.apache.org/jira/browse/CALCITE-4749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17404202#comment-17404202
]
yanjing.wang commented on CALCITE-4749:
---------------------------------------
Yes, it's from SQL to Rel. I noticed the type system in
[PostgresSqlDialect|https://github.com/apache/calcite/blob/94e2f98d9769ea17b9e8a6a478802f78a745e3f0/core/src/main/java/org/apache/calcite/sql/dialect/PostgresqlSqlDialect.java#L67].
Could I add custom type system with decimal result type implementation of the
RelDataTypeSystem#deriveDecimalDivideType for BigQuery, Oracle, MySQL and Spark?
> 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)
