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

Postgres debezium send wrong value of column has default NULL::::character varying in kafka message

XMLWordPrintable

    • False
    • False
    • 1.8.0.Final
    • Hide 
      create table test
(
test_id varchar(32) not null,
bill_flag varchar(1) default NULL::character varying,
constraint pk_pt_ab_category_test
primary key (test_id)
);
INSERT INTO test (test_id, bill_flag) VALUES ('6', null);
INSERT INTO test (test_id, bill_flag) VALUES ('7', DEFAULT);
      Show
      create table test ( test_id varchar(32) not null , bill_flag varchar(1) default NULL::character varying, constraint pk_pt_ab_category_test primary key (test_id) ); INSERT INTO test (test_id, bill_flag) VALUES ( '6' , null ); INSERT INTO test (test_id, bill_flag) VALUES ( '7' , DEFAULT);

      Hello, i found the problem as bellow, please help me to check that.

      Thanks!

      Postgres debezium send wrong value of column has default NULL::::character varying in kafka message.

      Kafka message:

      {
...
"payload": {
"before": null,
"after": {
"test_id": "7",
"bill_flag": "NULL::character varying"
},
"source": {
"version": "1.8.0.Final",
"snapshot": "false",
"sequence": "[\"95037292864\",\"95037292920\"]",
"txId": 284791,
"lsn": 95037292920,
"xmin": null,
...
},
"op": "c",
"ts_ms": 1644486606597,
"transaction": null
}
}

              jpechane Jiri Pechanec
              quyendqmz Trry J (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: