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
