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

Details

    • 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);
    • 1.8.0.Final

    Description

      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
      }
      }

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: