thswlsqls opened a new pull request, #8610: URL: https://github.com/apache/paimon/pull/8610
### Purpose fix #8605 - Postgres `numeric` allows precision up to 1000, but Paimon `DecimalType.MAX_PRECISION` is 38, so `PostgresTypeUtils.toDataType()` threw `IllegalArgumentException` on a `numeric(50,2)` column and schema derivation failed before the CDC sink could start. - Now precision > 38 falls back to `STRING` (`ARRAY(STRING)` for `_numeric`); precision 0 default (`DECIMAL(38,18)`) and the 1..38 behavior are preserved. - Mirrors the sibling `MySqlTypeUtils.toDataType()` guard (`length <= 38 ? DECIMAL : STRING`) under the same `JdbcToPaimonTypeVisitor` SPI. ### Tests - Added `PostgresTypeUtilsTest` covering precision 50 → STRING, 10/38 → DECIMAL, 0 → DECIMAL(38,18), and `_numeric` array symmetry. - `mvn -pl paimon-flink/paimon-flink-cdc -am -Pflink1 clean install` — 4 tests passed (checkstyle/spotless/rat green). -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
