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

Incorrect handling of type alias

    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?

        Gliffy Diagrams

          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: