Bug #52892 MySQL Server Hangs on certain Full Text Boolean searches
Submitted: 16 Apr 2010 17:33 Modified: 19 Apr 2010 18:04
Reporter: Neil Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S2 (Serious)
Version:5.1.37 OS:Linux
Assigned to: CPU Architecture:Any
Tags: boolean, Craches, full text, hangs, locks, MySQL, query, search

[16 Apr 2010 17:33] Neil
Description:
We are attempting to run the following full text search on one of our tables.  But on entering the keyword phrases below it appears to crash/hang the query. 

SELECT Country, County, Name, MATCH (Country, County, Name) AGAINST ('+st.* giles-* the* Court* New* York*' IN BOOLEAN MODE) AS Relevance
 FROM Properties
 WHERE MATCH (Country, County, Name) AGAINST ('+st.* giles-* the* Court* New* York*' IN BOOLEAN MODE) ORDER BY Relevance DESC

Does anyone know of this problem ?

How to repeat:
By running the query using the keyword phrases +st.* giles-* the* Court* New* York* it will lock the search.
[16 Apr 2010 19:49] MySQL Verification Team
Thank you for the bug report. Could you please try 5.1.45 released version and if you continue to have the same issue, please provide a complete test case. Thanks in advance.
[19 Apr 2010 9:28] Neil
I tried version 5.1.45 and it appears to fix the problem.  However, how do we go about upgrading our version to 5.1.45 on Ubuntu OS
[19 Apr 2010 18:04] MySQL Verification Team
Closing according last comment. You can use our tarball package or wait until Ubuntu makes it available for upgrade. Thanks in advance.