Some tests can't pass when time_zone not equal to Asia/Shanghai

[Defined2014]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Some tests and feature can't pass when time_zone != Asia/Shanghait, we should fix it.

You could get list of test cases below

• TestStmtFile
• TestFlashbackCloseAndResetPDSchedule
• TestTiDBTrx
• TestExactStalenessTransaction
• TestSetTransactionReadOnlyAsOf
• TestCancelFlashbackCluster
• TestSetTiDBCloudStorageURI
• TestIssue20236
• TestClusterTableSlowQuery
• TestGetLock
• TestSelectClusterTable
• TestTiFlashFlashbackCluster
• TestGlobalVariablesOnFlashback
• TestStmtFiles
• TestChangingColOriginDefaultValueAfterAddColAndCastSucc
• TestAddDDLDuringFlashback
• TestStmtFileInvalidLine
• TestGetTimeZone
• TestRecoverClusterMeetError

log.txt

2. What did you expect to see? (Required)

The test shouldn't related with time_zone.

3. What did you see instead (Required)

The test failed.

4. What is your TiDB version? (Required)

[Defined2014]

A same problem #42755

[hawkingrei]

Can we use the bazel as our default ut tool? bazel has managed the unit test environment in the tidb repo.

tidb/.bazelrc

Line 21 in f50e894

test --test_env=TZ=Asia/Shanghai

[Defined2014]

Can we use the bazel as our default ut tool? bazel has managed the unit test environment in the tidb repo.

tidb/.bazelrc

Line 21 in f50e894

test --test_env=TZ=Asia/Shanghai

But the problem is not only about test itself. We did not handle time_zone correctly in some features. Every test cases should pass in any time_zone.