MySQL Bugs: #39659: Having "2.0" in version search field doesn't show bugs with "2.0" in the version

Bug #39659	Having "2.0" in version search field doesn't show bugs with "2.0" in the version
Submitted:	26 Sep 2008 7:15	Modified:	5 May 2012 11:58
Reporter:	Carsten Segieth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Websites: bugs.mysql.com	Severity:	S3 (Non-critical)
Version:	2008-09-26	OS:	Any
Assigned to:	Vlad Safronov	CPU Architecture:	Any

Description:
I tried to select all MEM bugs that have a "2.0" in the search field, but e.g. bug#27447 with "1.1.0.4899, 2.0" as version string is not shown.

It looks that only bugs are shown, that starts with "2.0" in the version field.

How to repeat:
- try one of these 2 saved searches
  - http://bugs.mysql.com/saved/mer%20v%202.0
  - http://bugs.mysql.com/saved/mer%20v%202.0%20%28active%29
- or manually enter "2.0" in the version field and select all Enterprise Monitor categories

Suggested fix:
- show all bugs that have the entered string as part of the specified field (and not only as the beginning), I think here about something like 

  SELECT ... FROM bugs WHERE <field> LIKE "%<string>%";

- or document on http://bugs.mysql.com/report.php (and/or it's sub-page http://bugs.mysql.com/how-to-report.php) how the search is done. And if there is some documentation about how the search is performed, it would help to show it "at a more prominent place"

Thank you for the report.

Verified as described.

I can add prepending %, but this would obviously add noise in the search results.

Another option might be regex checkbox for version in Advanced search form. Would that work?

The bug has been fixed. A different approach is used, a slightly better one than suggested fix.