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

Invalid default value error on captured table DDL with default value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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);

      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"

        1. log-events-viewer-result (3).csv
          45 kB

              ccranfor@redhat.com Chris Cranford
              trustokoroego Trust Okoroego (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: