Re: Fulltext Search Problem

[Sergei Golubchik]

Hi!

Reported as http://bugs.mysql.com/bug.php?id=29445

You can subscribe to the bugreport to follow the progress.

You could've submitted the bug yourself, of course, the bugdb it open.
In that case you would've needed to subscribe.

The test case was good, by the way. Thanks!

On Jun 27, Wido Menhardt wrote:
> 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
> 
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