From: Date: June 28 2007 12:49am
Subject: Fulltext Search Problem
List-Archive: http://lists.mysql.com/internals/34782
Message-Id: <!&!AAAAAAAAAAAYAAAAAAAAAFD8QWAc8XhNn4Ff6qEkhzXCgAAAEAAAAI6NxWnB0ANAg2pgRKb3AVgBAAAAAA==@menhardt.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="windows-1250"
Content-Transfer-Encoding: 7bit



Servus Sergei,

I whittled the database and table content down to this short script:

-----------------------------------------------------------------------
DROP TABLE IF EXISTS `movies`;
CREATE TABLE `movies` (
  `movie_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  PRIMARY KEY (`movie_id`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=3DMyISAM AUTO_INCREMENT=3D154 DEFAULT CHARSET=3Dutf8; 

INSERT INTO `movies` VALUES (111,'Offside'),(142,'City Of God'); 

select count(movie_id) as cnt from movies where match (movies.title) =
against ('+city of*' in boolean mode);
-----------------------------------------------------------------------

This does never return, and the best thing I have figured out to do is
kill-9 mysql.

This happens on a Red Hat system (I can get you more info if you require
it). Server appears to be 5.1.16-beta.

I also tried the exact same thing on a windows system, and the query =
returns just fine.

Let me know if you need more info.

Wido


-- Sergei wrote:
--
--
-- 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 Gruessen,
-- Sergei



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM