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:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.26 OS:MacOS
Assigned to: CPU Architecture:x86
Tags: time

[19 May 2022 6:10] crazy cs
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", '');
[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