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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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' " } }      

      Oracle debezium send wrong value of column has

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

      default VARCHAR2(1) default ('0')

      in kafka message 

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

                Created:
                Updated:
                Resolved: