| Bug #116863 | Queries data of the time type, the returned result is incorrect | ||
|---|---|---|---|
| Submitted: | 4 Dec 2024 6:47 | Modified: | 4 Dec 2024 6:54 |
| Reporter: | Alice Alice | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S2 (Serious) |
| Version: | 8.0.37, 8.0.40, 8.4.3, 9.1.0 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[4 Dec 2024 6:54]
MySQL Verification Team
Hello Alice Alice, Thank you for the report and feedback. regards, Umesh
Description: Queries data of the time type, the returned result is incorrect How to repeat: mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.37 | +-----------+ 1 row in set (0.00 sec) mysql> create table tt(time_col time(6)); Query OK, 0 rows affected (0.01 sec) mysql> insert into tt values('23:59:59.000000'),('12:00:00.000000'); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select time_col from tt where time_col in ('23:59:59.000000',NULL); Empty set (0.00 sec)