Fulltext Search Problem

From: Wido Menhardt <wido(at)menhardt.com>
Date: Wed Jun 27 2007 - 18:49:42 EDT

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  

--

MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals?unsub=lists@pantek.com Received on Wed Jun 27 18:50:16 2007