You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Mihai Budiu (Jira)" <ji...@apache.org> on 2024/07/11 07:01:00 UTC

[jira] [Created] (CALCITE-6464) Type inference for DECIMAL division seems incorrect

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)