[jira] [Created] (CALCITE-6533) Division between integer and decimal produces incorrect result

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-6533:
------------------------------------

             Summary: Division between integer and decimal produces incorrect 
result
                 Key: CALCITE-6533
                 URL: https://issues.apache.org/jira/browse/CALCITE-6533
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.37.0
            Reporter: Mihai Budiu


The following program

SELECT 95.0 / 100

produces the expected result, .95, as a DECIMAL(14, 8).

However, the program

SELECT 95 / 100.0

produces the result 0E+! with type DECIMAL(17, -1)



--
This message was sent by Atlassian Jira
(v8.20.10#820010)