Shawn-Hx opened a new pull request, #3821: URL: https://github.com/apache/flink-cdc/pull/3821
In SchemaMergingUtils#getLeastCommonType, the merge result of BIGINT and DOUBLE is STRING now. However, considering JSON format, JSON numbers can be integers or floating point, which can be inferred as BIGINT and DOUBLE respectively. In this case, a JSON number field will be inferred as STRING, which is confusing. The updated data type merge tree is: ```mermaid graph TD; BOOLEAN --> STRING; CHAR --> STRING; VARCHAR --> STRING; BINARY --> STRING; VARBINARY --> STRING; TINYINT --> FLOAT; SMALLINT --> FLOAT; FLOAT --> DOUBLE; TINYINT --> SMALLINT --> INT --> BIGINT --> DECIMAL --> DOUBLE --> STRING; TIMESTAMP --> TIMESTAMP_LTZ --> TIMESTAMP_TZ --> STRING; TIME --> STRING; ROW --> STRING; ARRAY --> STRING; MAP --> STRING; Specially, the merge result of DOUBLE and DECIMAL will be STRING. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org