Mihai Budiu created CALCITE-6464:
------------------------------------
Summary: Type inference for DECIMAL division seems incorrect
Key: CALCITE-6464
URL: https://issues.apache.org/jira/browse/CALCITE-6464
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.37.0
Reporter: Mihai Budiu
This bug surfaces if one uses a custom type system, e.g., where DECIMAL is
limited to (28, 10).
The problem is in RelDataTypeSystem.deriveDecimalDivideType.
The JavaDoc of this function gives the algorithm for deriving the division
result type.
According to these rules, if you divide two numbers of type DECIMAL(28, 10),
you should get a result with type DECIMAL(28, 10).
But the actual implementation infers a type of DECIMAL(28, 0), which seems
incorrect.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
