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

Incorrect handling of type alias

    XMLWordPrintable

Details

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

    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

          is duplicated by

          Bug - A problem that impairs or prevents the functions of the product. DBZ-808 Debezium cant parse user define type on AWS RDS

          • 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
          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1009 Postgres Connector fails on none nullable MACADDR field during initial snapshot

          • 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

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

              Dates

                Created:
                Updated:
                Resolved: