-
Enhancement
-
Resolution: Done
-
Major
-
None
-
False
-
None
-
False
Enhancement of whole numbers handling by Oracle connector
In case of whole number fields (NUMERIC[x,0]), Debezium connector for Oracle treats these as INT64 schema despite the fact that decimal.handling.mode=string. This behavior is confusing since other connectors (tested on Postgres and SQL Server) treat numeric fields (not only) with scale = 0 as STRING schema.
For discussion about this topic please check https://debezium.zulipchat.com/#narrow/stream/348250-community-oracle/topic/decimal.2Ehandling.2Emode.20not.20working.
Implementation ideas
Could you please add a new converter to serialize NUMERIC(x,0) as SpecialValueDecimal types that can be influenced by the decimal handling mode? From there you could either pick to have all fields done this way or select fields via a selector property. Maybe also consider standardizing the behavior in future release. Thanks!
- links to
-
RHEA-2024:139598 Red Hat build of Debezium 2.5.4 release