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

Default value of ('N') is not correctly emitted in Oracle change event

    XMLWordPrintable

Details

    • False
    • None
    • False
    • 1.8.0.Final
    • Hide
      create table A (
      COL1              VARCHAR2(1) default ('N'),
      COL2               VARCHAR2(2) default ('0')
      ...
      )
      

      When I insert a row has null value of COL, COL2 into database, after field value is wrong, COL1 and COL2 should be null

      {
      "payload": {
      " after": {
          "COL1": "'N'",
          "COL2": "'0'"
       }
      }

       

       

       

      Show
      create table A ( COL1              VARCHAR2(1) default ( 'N' ), COL2               VARCHAR2(2) default ( '0' ) ... ) When I insert a row has null value of COL, COL2 into database, after field value is wrong, COL1 and COL2 should be null { "payload" : { " after" : { "COL1" : " 'N' " , "COL2" : " '0' " } }      

    Description

      Oracle debezium send wrong value of column has

      default VARCHAR2(1) default ('N') or

      default VARCHAR2(1) default ('0')

      in kafka message 

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            quyendqmz Trry J (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: