Wrong enum calculation result in where condition. #22717
Closed
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
drop table t;
create table t(e enum('a','','b'));
insert into t values(1),(2),(3);
select * from t where e;
2. What did you expect to see? (Required)
MySQL [test]> select * from t where e;
+------+
| e |
+------+
| a |
| |
| b |
+------+
3 rows in set (0.000 sec)
3. What did you see instead (Required)
[tidb]> select * from t where e;
+------+
| e |
+------+
| a |
| b |
+------+
2 rows in set (0.001 sec)
Activity