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

Incorrect handling of type alias

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.0.0.CR1
    • 0.10.0.Beta3
    • postgresql-connector
    • None

      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?

            ccranfor@redhat.com Chris Cranford
            jpechane Jiri Pechanec
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: