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

The MySQL connector does not handle timezone information correctly for TIMESTAMP values

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.4
    • 0.3.6
    • mysql-connector
    • None

    Description

      When parsing the MySQL binlog and generating events for TIMESTAMP columns, the MySQL connector currently uses Java's OffsetDateTime class which does not handle Daylight Savings Time changes (these are specific to a TimeZone with certain rules)

      This means that for example when running on a JVM which has the Europe/Bucharest timezone a value such as 2014-09-08T17:51:04.780 is reported back by the connector as a String 2014-09-08T17:51:04.780+02:00.

      The correct (expected) result in this case should be 2014-09-08T17:51:04.780+03:00 which takes into account the DST value for this timezone.

      Attachments

        Activity

          People

            hchiorean Horia Chiorean (Inactive)
            hchiorean Horia Chiorean (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: