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

Incorrect handling of type alias

    XMLWordPrintable

    Details

      Description

      If a new type is introduced as an alias to a built-in type like CREATE DOMAIN money2 AS NUMERIC(12,2); then it is not correctly handled in io.debezium.connector.postgresql.PostgresValueConverter.convertBinary(Column, Field, Object).
      The issue is visble in snapshot as the value arrives as the logical Java class and is not thus possible to be converted as a binary value.

      See https://issues.jboss.org/browse/DBZ-1009?focusedCommentId=13757501&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13757501 for reference.

      Key problems

      • streaming mode delivers byte representation but snapshot mode delivers Java class
      • how to handle default values?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ccranfor Chris Cranford
              Reporter:
              jpechanec Jiri Pechanec
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: