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

Add support for SDO_GEOMETRY columns

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Unresolved
    • Major
    • Backlog
    • None
    • oracle-connector
    • None
    • False
    • False

    Description

      Currently, SDO_GEOMETRY columns are omitted from the connector's events as it is an unsupported column data type.
      We should investigate what's needed to support this.

      Observations from https://github.com/debezium/debezium/pull/2854

      • SDO_GEOMETRY values are not present in UPDATE statements that do not modify the column values. Need to investigate what happens if the UPDATE statement references an SDO_GEOMETRY column.
      • SDO_GEOMETRY columns are present in DELETE statements but the value is provided as Unsupported Type despite the database having compatibility mode of 12.1 or later.

      Attachments

        Issue Links

          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4206 DDL with Oracle SDO_GEOMETRY cannot be parsed

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              Unassigned Unassigned
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: