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

MySQL Connector: NULL values are replaced by default values

    XMLWordPrintable

Details

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

    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

          duplicates

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1609 Kafka Connect JsonConverter swallow null value on optional filed which has default value

          • Critical - To be worked on immediately following BLOCKER issues.
          • Closed
          relates to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-1064 NULL Values are replaced by default values even in NULLABLE fields

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: