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

Inconsistent Behavior for a Deleted Record

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • None
    • None
    • postgresql-connector
    • None
    • False
    • False

    Description

      When deleting a record in PostgreSQL by running this for example:

      delete from order_details where order_detail_id = 2;

      The change record that reflects this:

      "before":{ "order_detail_id":2, "order_id":0, "order_date":null, "quantity":null, "notes":null, "od_numeric":null, "od_decimal":null, "od_real":null, "od_double_precision":null, "od_bigserial":0, "od_text":null, "od_json":null}

      In other connectors (tested MSSQL and DB2 for now), the before object represents the record before the deletion, while here the fields are set to null/0.

      Attachments

        Activity

          People

            Unassigned Unassigned
            yossish Yossi Shirizli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: