Corruption reported on indexed virtual column when timezone is changed

SET TIME_ZONE='+00:00';

CREATE TABLE t (a TIMESTAMP, b DATE GENERATED ALWAYS AS (DATE(a)) VIRTUAL, KEY(b));

INSERT INTO t (a) VALUES ('1999-01-31 22:00:00'),('1990-01-01 00:00:00');

SET TIME_ZONE='+02:00';

CHECK TABLE t EXTENDED;

# Cleanup

DROP TABLE t;

CHECK TABLE t EXTENDED;

Table	Op	Msg_type	Msg_text

test.t	check	error	Record at: 0  Can't find key for index:  1

test.t	check	error	Corrupt

DROP TABLE t;

bug.t                                    [ fail ]  Found warnings/errors in server log file!

        Test ended at 2023-11-29 15:10:20

line

2023-11-29 15:10:20 4 [ERROR] Got an error from thread_id=4, /data/bld/10.4-asan/storage/myisam/ha_myisam.cc:1130

2023-11-29 15:10:20 4 [ERROR] MySQL thread id 4, OS thread handle 140423800547008, query id 26 localhost root Checking table

CHECK TABLE t EXTENDED;

Table	Op	Msg_type	Msg_text

test.t	check	Warning	InnoDB: Index 'b' contains 1 entries, should be 2.

test.t	check	error	Corrupt

DROP TABLE t;

bug.t                                    [ fail ]  Found warnings/errors in server log file!

        Test ended at 2023-11-29 15:11:00

line

2023-11-29 15:11:00 4 [ERROR] InnoDB: Flagged corruption of `b` in table `test`.`t` in CHECK TABLE; Wrong count