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

Invalid default value error on captured table DDL with default value

    XMLWordPrintable

Details

    • 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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: