| Bug #107338 | select return wrong result about time column | ||
|---|---|---|---|
| Submitted: | 19 May 2022 6:10 | Modified: | 19 May 2022 7:07 |
| Reporter: | crazy cs | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
| Version: | 8.0.26 | OS: | MacOS |
| Assigned to: | CPU Architecture: | x86 | |
| Tags: | time | ||
[19 May 2022 6:13]
crazy cs
same issue with https://bugs.mysql.com/bug.php?id=107337
[19 May 2022 7:07]
MySQL Verification Team
Hello! Thank you for the report and feedback. This is duplicate of Bug #107337. regards, Umesh
Description: ```sql create table t (a time); insert into t values ("08:00:56"); select * from t where a in ("08:00:56", ''); ``` The final select result is empty, but the expected result should be `"08:00:56"`. How to repeat: create table t (a time); insert into t values ("08:00:56"); select * from t where a in ("08:00:56", '');