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"
      

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

              Created:
              Updated:
              Resolved: