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

Events for tables with generated columns fail when using hybrid mining strategy

XMLWordPrintable

      The Oracle hybrid mining strategy is designed to decode the COLn columns to column ordinal positions in the table metadata.

      However, when the table contains a generated column, the column is ignored by LogMiner, but the relational model used by Debezium includes them. When the COLn lookup is performed, this leads to an inconsistency between LogMiner's mapping of column positions and those managed by Debezium's relational model.

      This will ultimately lead to situations where the decoding of a HEXTORAW value may fail or other random OracleValueConverter functions may fail as the data supplied to the converter is incorrect because the column position lookup was off.

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

                Created:
                Updated:
                Resolved: