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

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

XMLWordPrintable

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

      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.

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

                Created:
                Updated:
                Resolved: