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

MySQL Connector: NULL values are replaced by default values

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.4.1.Final, 1.7.1.Final
    • mysql-connector
    • None
    • False
    • False

      Basically, Issue is identical to DBZ-1064. 

      MySQL table definition:

      CREATE TABLE `campaign_ads` (
 `ad_id` int(11) NOT NULL,
 `max_cpc` float(20,8) DEFAULT '0.00000000',
 PRIMARY KEY (`ad_id`)
 )

      If I'm trying to insert row with null `max_cpc`, I'm getting 0 in Kafka just because it's default value.

       

      I reproduced it with 1.4.1 and 1.7.1 versions. 

              Unassigned Unassigned
              rubanau Ivan Rubanau (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: