You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Xiao Huang (Jira)" <ji...@apache.org> on 2024/12/27 08:33:00 UTC

[jira] [Created] (FLINK-36969) Merge result of data type BIGINT and DOUBLE should be DOUBLE instead of STRING

Xiao Huang created FLINK-36969:
----------------------------------

             Summary: Merge result of data type BIGINT and DOUBLE should be DOUBLE instead of STRING
                 Key: FLINK-36969
                 URL: https://issues.apache.org/jira/browse/FLINK-36969
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
            Reporter: Xiao Huang


In SchemaMergingUtils#getLeastCommonType, the merge result of BIGINT and DOUBLE is STRING now.

However, considering JSON string, JSON number can be integers or floating point. Data type of integers can be inferred as BIGINT, and floating point can be inferred as DOUBLE. So a JSON number field will be inferred as STRING, which is confusing.

The merge result of numerical types should always be a numerical type.



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