Bug #105159 | rlike expression evaluated when it should not be | ||
---|---|---|---|
Submitted: | 7 Oct 2021 0:33 | Modified: | 8 Oct 2021 6:23 |
Reporter: | Dave Pullin (Basic Quality Contributor) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.7.31, 5.7.35 | OS: | CentOS (CentOS Linux release 7.6.1810 (Core)) |
Assigned to: | CPU Architecture: | Any |
[7 Oct 2021 0:33]
Dave Pullin
[7 Oct 2021 4:51]
MySQL Verification Team
Hello Dave, Thank you for the report and test case. Verified as described. regards, Umesh
[8 Oct 2021 6:23]
Roy Lyseng
Posted by developer: What happens here is that we have constant expressions that fail when evaluated. When the IF or IFNULL expression is analyzed, we look into each of the subexpressions to see if they can be simplified, and constant expressions often can. Thus, this is a natural way of processing these statements. Workarounds: - Make sure that the constant expression is valid. - Make sure that the "impossible" subexpression is not constant (e.g. it refers a column).