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

MySQL temporal values represented incorrectly

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.2.3, 0.3
    • 0.2.2
    • mysql-connector
    • None

    Description

      MySQL 5.7 has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.

      mysql> CREATE TABLE fractest( c1 *TIME(2)*, c2 *DATETIME(2),* c3 *TIMESTAMP(2)* );
      mysql> INSERT INTO fractest VALUES ('17:51:04.777', '2014-09-08 17:51:04.777', '2014-09-08 17:51:04.777');
      

      Now the millisecond part is ignore, hope the connector can support this new feature

      UPDATE: Upon closer inspection, the container was not properly reconstructing temporal values and encoding them in Kafka Connect records.

      Attachments

        Issue Links

          Activity

            People

              rhauch Randall Hauch (Inactive)
              logan2013 laogang laogang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: