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

"binary.handling.mode": "hex" setting works incorrectly for values with trailing zeros

XMLWordPrintable

    • False
    • False
    • undefined
    • Hide
      1. MySQL (tested on GCP CloudSQL for MySQL 8.0 and local docker image debezium/example-mysql:1.4 with MySQL 5.7.33-log ):
        create table dummy (UUID BINARY(16) NOT NULL);
      2. Create connector `io.debezium.connector.mysql.MySqlConnector{{}}` with "binary.handling.mode": "hex"
      3. insert into dummy (UUID) values (unhex('12DEA2AD3C8C40C6A2787CF1A1AC9300'));

      ---
      Kafka topic:
      Struct{UUID=12dea2ad3c8c40c6a2787cf1a1ac93,_op=c,ts_ms=1629841725077,_deleted=false}

      Show
      MySQL (tested on GCP CloudSQL for MySQL 8.0 and local docker image debezium/example-mysql:1.4 with MySQL 5.7.33-log ): create table dummy (UUID BINARY(16) NOT NULL); Create connector `io.debezium.connector.mysql.MySqlConnector {{}}` with "binary.handling.mode": "hex" insert into dummy (UUID) values (unhex('12DEA2AD3C8C40C6A2787CF1A1AC9300')); --- Kafka topic: Struct{UUID=12dea2ad3c8c40c6a2787cf1a1ac93,_ op=c, ts_ms=1629841725077, _deleted=false }

      For MySQL source database with BINARY(16) NOT NULL column when binary to hex string conversion with "binary.handling.mode": "hex" connector setting is used trailing zeros are ignored.

       

              jpechane Jiri Pechanec
              vaosinbi Vladimir Osin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: