search

pingcap / tidb-tools

tidb-tools are some useful tool collections for TiDB.
Apache License 2.0
286 stars 191 forks source link

sync_diff_inspector: time_zone is difference when parse the default value of type `timestamp` #694

Closed Leavrth closed 1 year ago

Leavrth commented 1 year ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

    • In UTC +8:00
    • create table with a column whose type is timestamp and default value is 1970-01-01 08:00:01.
    • use sync_diff_inspector to check tables.

  2. What did you expect to see? success to check

  3. What did you see instead? failed to check. 

    get table test.t1's information error [types:1067]Invalid default value for 'ts'

  4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

  5. which tool are you using?

  6. what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)?