Bug #83427 | LOCATE('he','hello',NULL) should return NULL instead of 0 | ||
---|---|---|---|
Submitted: | 18 Oct 2016 13:22 | Modified: | 19 Oct 2016 17:12 |
Reporter: | Marko Mäkelä | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 5.0.47 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[18 Oct 2016 13:22]
Marko Mäkelä
[19 Oct 2016 17:12]
Paul DuBois
Posted by developer: Fixed in 8.0.1. The LOCATE() function returned NULL if the substr or str argument was NULL, but not if the pos argument was NULL. Now it returns NULL if any argument is NULL.