From: Date: June 10 2007 8:06pm
Subject: Fulltext Search Problem
List-Archive: http://lists.mysql.com/internals/34720
Message-Id: <!&!AAAAAAAAAAAYAAAAAAAAAFD8QWAc8XhNn4Ff6qEkhzXCgAAAEAAAAOTuEQh+PrxKsYBNO2rVFeEBAAAAAA==@menhardt.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

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

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

In there, I have among many other titles:=20

"City Of God"=20
"An Unreasonable Man"=20

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

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!).=20

('+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?

=20
Any suggestions?

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