[
https://issues.apache.org/jira/browse/FLINK-35408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849697#comment-17849697
]
Leonard Xu commented on FLINK-35408:
------------------------------------
[~davidradl] I think a FLIP is not necessary as this minor improvement doesn’t
influence users' API. The improvement is pretty useful when validate timezone,
30 minutes is the best value for the timezone tolerance as the granularity of
the time zone is hours.
> Add 30 min tolerance value when validating the time-zone setting
> ----------------------------------------------------------------
>
> Key: FLINK-35408
> URL: https://issues.apache.org/jira/browse/FLINK-35408
> Project: Flink
> Issue Type: Improvement
> Components: Flink CDC
> Affects Versions: cdc-3.1.0
> Reporter: Xiao Huang
> Assignee: Xiao Huang
> Priority: Major
> Labels: pull-request-available
> Fix For: cdc-3.2.0
>
>
> Now, MySQL CDC connector will retrieve the offset seconds between the
> configured timezone and UTC by executing the SQL statement below, and then
> compare it with the configured timezone.
> {code:java}
> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), UTC_TIMESTAMP())) {code}
> For some MySQL instances, the validating for time-zone is too strict. We can
> add 30min tolerance value.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
