Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-7882

Oracle connector decimal.handling.mode improvement

XMLWordPrintable

      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!

            ccranfor@redhat.com Chris Cranford
            eriksvec8 Erik Švec (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: