yanjing.wang created CALCITE-4749: ------------------------------------- Summary: 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 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)