time type query <=> null failed

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table lrr(`COL1` time DEFAULT NULL,`COL2` time DEFAULT NULL);
insert into lrr(col2) values("-229:53:34");
select * from lrr where col1 <=> null;

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

+------+------------+
| COL1 | COL2 |
+------+------------+
| NULL | -229:53:34 |
+------+------------+

3. What did you see instead (Required)

Empty set

4. What is your TiDB version? (Required)

Release Version: v8.4.0
Edition: Community
Git Commit Hash: 2205f33
Git Branch: HEAD
UTC Build Time: 2024-10-17 07:36:44
GoVersion: go1.23.2
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[apollodafoni]

/severity major
/label affects-8.4

[apollodafoni]

/assign @xzhangxian1008

[xzhangxian1008]

/remove-label may-affects-5.4

[xzhangxian1008]

/remove-label may-affects-6.1

[xzhangxian1008]

/remove-label may-affects-6.5

[xzhangxian1008]

/remove-label may-affects-7.1

[xzhangxian1008]

/remove-label may-affects-7.5

[xzhangxian1008]

/remove-label may-affects-8.1

[apollodafoni]

/label fuzz/comp