[jira] [Created] (CALCITE-5986) The SqlTypeFamily for FP types is incorrect

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-5986:
------------------------------------

             Summary: The SqlTypeFamily for FP types is incorrect
                 Key: CALCITE-5986
                 URL: https://issues.apache.org/jira/browse/CALCITE-5986
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.35.0
            Reporter: Mihai Budiu


In SqlTypeFamily we have this code:
{code:java}
private static final Map<Integer, SqlTypeFamily> JDBC_TYPE_TO_FAMILY =
...
          .put(Types.FLOAT, NUMERIC)
          .put(Types.REAL, NUMERIC)
          .put(Types.DOUBLE, NUMERIC)
{code}

But it looks to me like the type family should be APPROXIMATE_NUMERIC.

This impacts the way RelToSqlConverter works, for instance.



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