Bug #60983 | LIKE/REGEXP performance regression in stored functions | ||
---|---|---|---|
Submitted: | 26 Apr 2011 23:00 | Modified: | 27 Apr 2011 17:40 |
Reporter: | Ashley Winters | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S5 (Performance) |
Version: | 5.5.8-enterprise-commercial-advanced-log | OS: | Linux |
Assigned to: | CPU Architecture: | Any | |
Tags: | BENCHMARK, FUNCTION, like, performance, regex, REGEXP, regression, udf |
[26 Apr 2011 23:00]
Ashley Winters
[26 Apr 2011 23:07]
Ashley Winters
Mention LIKE in the synposis/tags
[27 Apr 2011 3:09]
Valeriy Kravchuk
Looks like a duplicate of/closely related to Bug #60025. Please, check.
[27 Apr 2011 17:38]
Ashley Winters
Yes, I'd agree it's a dupe. I actually found Bug #60687 (another dupe) to be closer in description, but the fix for me is the same. set names latin1 resolves my problem on 5.5.
[27 Apr 2011 17:40]
Valeriy Kravchuk
Duplicate of Bug #60025.