From: Date: June 19 2007 8:31am
Subject: Re: Fulltext Search Problem
List-Archive: http://lists.mysql.com/internals/34747
Message-Id: <20070619063159.GA12039@janus.mylan>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi!

On Jun 10, Wido Menhardt wrote:
> 
> 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!). 

Can you provide a complete repeatable test case ?
 
Regards / Mit vielen Grüssen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Developer
/_/  /_/\_, /___/\___\_\___/  MySQL GmbH, Radlkoferstr. 2, D-81373 München
       <___/                  Geschäftsführer: Kaj Arnö - HRB München 162140