WuChongYong commented on issue #3827:
URL: https://github.com/apache/flink-cdc/issues/3827#issuecomment-2566170058

   The data in a certain (timestamp type) time field of the table in the source 
MySQL is 0002-11-30 08:05:43, and the timestamp that Flink CDC should output is 
-62075462057000L, but the actual timestamp output by Flink CDC is 
1038643543000L, which is different from the value in the data source
   Data such as:
   INSERT INTO testdb.test_datetime
   (id, datetime_col)
   VALUES('1', '0002-11-30 08:05:43');
   INSERT INTO testdb.test_datetime
   (id, datetime_col)
   VALUES('2', '0022-11-30 08:05:43');
   INSERT INTO testdb.test_datetime
   (id, datetime_col)
   VALUES('3', '0222-11-30 08:05:43');
   Only the parsing of 0222-11-30 08:05:43 is correct, which means that there 
will be problems when the prefix has two or more 0s


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@flink.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to