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

Debezium MySQL connector does not capture floating point data with appropriate precision

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • None
    • 1.4.0.Final
    • mysql-connector
    • None
    • False
    • False
    • Undefined
    • Hide
      • Create a table with a column of floating point type.
      • Run Debezium connector with required configurations and mine the table.
      • Insert data into the table, specifically into the column.
      • Check if the data received in the MySQL connector is same as the data inserted for the floating point column.

      flaotingPoint.txt

      Show
      Create a table with a column of floating point type. Run Debezium connector with required configurations and mine the table. Insert data into the table, specifically into the column. Check if the data received in the MySQL connector is same as the data inserted for the floating point column. flaotingPoint.txt

    Description

      I created a table that contains a column with a floating point type column.

      create TABLE test_schema.floatTable (floatColumn FLOAT(10))

      Started Debezium MySQL connector and started capturing data.

      For an insert into the table like
      insert into test_schema.floatTable VALUES(1.234)

      produces Debezium message with data 
      "after":{"floatColumn":1.2339999675750732}

       

      There is a difference between the data inserted into the database and the data received using Debezium.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            majayk07 Ajay M (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: