pingcap / tidb-binlog

A tool used to collect and merge tidb's binlog for real-time data backup and synchronization.
Apache License 2.0
292 stars 131 forks source link

Summer time increased by 1 hour through pump & drainer #839

Closed you06 closed 4 years ago

you06 commented 4 years ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
CREATE TABLE `t` (`d` timestamp NOT NULL);
INSERT INTO t(d) VALUES('1988-05-28 05:58:57'), ('2011-11-11 11:11:11');
mysql> SELECT d, UNIX_TIMESTAMP(d) FROM t;
+---------------------+-------------------+
| d                   | UNIX_TIMESTAMP(d) |
+---------------------+-------------------+
| 1988-05-28 05:58:57 |         580773537 |
| 2011-11-11 11:11:11 |        1320981071 |
+---------------------+-------------------+
2 rows in set (0.00 sec)
mysql> SELECT d, UNIX_TIMESTAMP(d) FROM t;
+---------------------+-------------------+
| d                   | UNIX_TIMESTAMP(d) |
+---------------------+-------------------+
| 2011-11-11 11:11:11 |        1320981071 |
| 1988-05-28 06:58:57 |         580777137 |
+---------------------+-------------------+
2 rows in set (0.00 sec)
  1. What did you expect to see?

1988-05-28 05:58:57 instead of 1988-05-28 06:58:57 in target db.

  1. What did you see instead?

1988-05-28 06:58:57 in target db.

  1. Please provide the relate downstream type and version of drainer. (run drainer -V in terminal to get drainer's version)
# ./drainer -V
Release Version: v3.0.6
Git Commit Hash: 948d8f32643321a038a79c91effcf55246d41e15
Build TS: 2019-12-04 09:30:14
Go Version: go1.13
Go OS/Arch: linux/amd64
zier-one commented 4 years ago

fixed in #841