Re: fulltextsearch causes infinitive loop in mysqld

Hi!

On Oct 15, hurle wrote:
> Hi!
> 
> I think I found a bug in mysql using version 4.0.15:
> Using any database with or without fulltext indexes the mysqld seems to 
> get in a infinit loop when I query something like:
> 
> select * from <tableName> where match(<columnName>) against('T* A* B* 
> T*' in boolean mode);
> 
> select * from <tableName> where match(<columnName>) against('T* A* D* 
> F*' in boolean mode);
> 
> ==> all rows with <columnName> beginning with "T" or "A" or "D" but NO 
> rows beginning with "F".

I don't think it's an infinite loop.
Most probably your query matches huge number of rows and MySQL gets very
busy removing duplicates (rows that match both e.g. 'T*' and 'A*').

But let's get some numbers.
What are the results for queries:

SELECT COUNT(*) from <tableName>;
SELECT COUNT(*) from <tableName> where
match(<columnName>) against('T*' in boolean mode);
SELECT COUNT(*) from <tableName> where
match(<columnName>) against('A*' in boolean mode);
SELECT COUNT(*) from <tableName> where
match(<columnName>) against('D*' in boolean mode);
SELECT COUNT(*) from <tableName> where
match(<columnName>) against('F*' in boolean mode);
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]