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

Invalid default value error on captured table DDL with default value

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.8.0.Alpha2
    • 1.6.0.CR1
    • oracle-connector
    • None
    • False
    • False
    • Undefined
    • Hide

      Perform similar DDL on already captured table:

      ALTER TABLE ULGN01.TLGNC_SAREA ADD (CONFIRM_MERGE_FLAG NUMBER(1) DEFAULT 0);
      Show
      Perform similar DDL on already captured table: ALTER TABLE ULGN01.TLGNC_SAREA ADD (CONFIRM_MERGE_FLAG NUMBER(1) DEFAULT 0);

    Description

      After altering the schema of already captured table with below DDL:

       REDO_SQL: ALTER TABLE ULGN01.TLGNC_SAREA ADD (CONFIRM_MERGE_FLAG NUMBER(1) DEFAULT 0);

      Debezium producer throw below error. The new DDL is not also captured in the Schema_changes topic with the new schema updated in the schema registry

      org.apache.kafka.connect.errors.SchemaBuilderException: Invalid default value

... 

Caused by: org.apache.kafka.connect.errors.DataException: Invalid Java object for schema type INT8: class java.lang.String for field: "null"

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4221 Invalid Java object for schema type INT64

          • 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

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) DBZ-4115 Introduce DefaultValueParserListener and DefaultValueConverter to handle default-value evaluation

          • 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
          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4208 DDL with Oracle sequence as default for primary key fails schema generation

          • 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
              trustokoroego Trust Okoroego (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: