Data inconsistency after adding index in another timezone

[tangenta]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SET time_zone = '-06:00';
create table t (`src` varchar(48),`t` timestamp,`timezone` varchar(100));
insert into t values('2000-07-29 23:15:30 -0600','2000-07-29 23:15:30 -0600','-6:00');
alter table t add index idx(t);
admin check table t;

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

No error.

3. What did you see instead (Required)

ERROR 8223 (HY000): data inconsistency in table: t, index: idx, handle: 1, index-values:"handle: 1, values: [KindMysqlTime 2000-07-30 19:15:30]" != record-values:"handle: 1, values: [KindMysqlTime 2000-07-30 13:15:30]"

4. What is your TiDB version? (Required)

c34f6fc

[jackysp]

Duplicate with #46033