Fulltext Search Problem

[Wido Menhardt]

(I posted this on forums-newbie before, but it’s not a newbie problem, I
don’t think)

I have a MyISAM table "movies" with a fulltext index on the title column. 

In there, I have among many other titles: 

"City Of God" 
"An Unreasonable Man" 

I do a query like: 
select title from movies where match (movies.title) against ('+city of*' in
boolean mode); 

This query NEVER RETURNS - it results in a locked table and a bogged down
mysql, even ^C out of the commandline client does not make the query go away
(the table has less than 300 entries at this point, it's not big!). 

('+city of') or ('+city') returns the right thing, and to tell you the
truth, the '+city of*' was a programming error (not mine :-), but still, why
does it lock up mysql?

 
Any suggestions?

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.13/842 - Release Date: 6/9/2007
10:46 AM