-
Enhancement
-
Resolution: Unresolved
-
Optional
-
None
-
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