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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.9.0.CR1
    • None
    • oracle-connector
    • None
    • 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: