| Bug #103633 | The not like returned unexpected results | ||
|---|---|---|---|
| Submitted: | 8 May 2021 15:06 | Modified: | 9 May 2021 23:01 |
| Reporter: | Guo Wenxuan | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S2 (Serious) |
| Version: | 5.6/5.7/8.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[9 May 2021 23:01]
MySQL Verification Team
Thank you for the bug report.
Description: select * from t0 where t0.col1 not like t0.col1; I think the sql should not return any value. mysql> select * from t0 where t0.col1 not like t0.col1; +--------+ | col1 | +--------+ | \9jM\M | +--------+ 1 row in set (0.12 sec) This is not what I expected。 How to repeat: create table t0(col1 varchar(255)); insert into t0 values("\\9jM\\M"); select * from t0 where t0.col1 not like t0.col1;