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

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

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Unresolved
    • Icon: Optional Optional
    • 2.4-backlog
    • None
    • jdbc-connector
    • None
    • False
    • 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
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: