snapshot task migrates timestamp '0000-00-00 00:00:00' to now()

[qianyiwen2019]

export MYSQL_IMAGE="mysql:5.7.40"

• source database

docker run -d --name some-mysql-1
--platform linux/x86_64
-it
-p 3307:3306 -e MYSQL_ROOT_PASSWORD="123456"
"$MYSQL_IMAGE" --lower_case_table_names=1 --character-set-server=utf8 --collation-server=utf8_general_ci
--datadir=/var/lib/mysql
--user=mysql
--server_id=1
--log_bin=/var/lib/mysql/mysql-bin.log
--max_binlog_size=100M
--gtid_mode=ON
--enforce_gtid_consistency=ON
--binlog_format=ROW
--default_time_zone=+08:00
--sql_mode=NO_ENGINE_SUBSTITUTION

• target database

docker run -d --name some-mysql-2
--platform linux/x86_64
-it
-p 3308:3306 -e MYSQL_ROOT_PASSWORD="123456"
"$MYSQL_IMAGE" --lower_case_table_names=1 --character-set-server=utf8 --collation-server=utf8_general_ci
--datadir=/var/lib/mysql
--user=mysql
--server_id=1
--log_bin=/var/lib/mysql/mysql-bin.log
--max_binlog_size=100M
--gtid_mode=ON
--enforce_gtid_consistency=ON
--binlog_format=ROW
--default_time_zone=+07:00
--sql_mode=NO_ENGINE_SUBSTITUTION

• table
  Create database test_db_1;
  create table test_db_1.a(id int, value timestamp NOT NULL DEFAULT '0000-00-00 00:00:00');
  insert into test_db_1.a values(1, '0000-00-00 00:00:00');

• source column values
  mysql> select * from test_db_1.a;
  +------+---------------------+
  | id | value |
  +------+---------------------+
  | 1 | 0000-00-00 00:00:00 |
  +------+---------------------+

• target column values which migrated by ape_dts
  mysql> select * from test_db_1.a;
  +------+---------------------+
  | id | value |
  +------+---------------------+
  | 1 | 2025-02-21 16:34:21 |
  +------+---------------------+