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

MySQL Connector: NULL values are replaced by default values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate Issue
    • 1.4.1.Final, 1.7.1.Final
    • None
    • mysql-connector
    • None

    Description

      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. 

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: