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

jdbc's getFormattedTimestampWithTimeZone should be split into two methods for DDL/DML

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False

      debezium-connector-jdbc's getFormattedTimestampWithTimeZone shoule be split into two method, one for DDL one for DML.

      Which use case/requirement will be addressed by the proposed feature?

      MySQL save Timestamp as UTC, so when we create/alter table, we should convert time to UTC as field's default value.

      However, MySQL convertsĀ TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval.
      So when we insert/update/select, we should convert timestamp to zone of session.

      What we expect

      If getFormattedTimestampWithTimeZone is only used with DDL, it's name shoule be more specific.
      If not, it should be split into two method, one for DDL, one for DML

              ccranfor@redhat.com Chris Cranford
              j2gg0s Wang j2gg0s (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: