Re: fulltextsearch causes infinitive loop in mysqld - Sergei Golubchik - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsRe: fulltextsearch causes infinitive ...

From	Sent On	Attachments
hurle	15 Oct 2003 02:27
Sergei Golubchik	15 Oct 2003 04:36
hurle	15 Oct 2003 05:52
Sergei Golubchik	03 Nov 2003 14:00

Subject:	Re: fulltextsearch causes infinitive loop in mysqld
From:	Sergei Golubchik (se...@mysql.com)
Date:	11/03/2003 02:00:37 PM
List:	com.mysql.lists.bugs

Hi!

Fixed! Thanks for a great test case!

On Oct 15, hurle wrote:

Sergei Golubchik wrote:

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*').

Well, I tried it with a very small database... I just created a very small testdb: create table test (id integer primary key not null, lastname varchar(100)); INSERT INTO `test` (`id`, `lastname`) VALUES (0, 'Anders'); INSERT INTO `test` (`id`, `lastname`) VALUES (1, 'Tricky'); INSERT INTO `test` (`id`, `lastname`) VALUES (2, 'Tron'); INSERT INTO `test` (`id`, `lastname`) VALUES (3, 'Dickens'); INSERT INTO `test` (`id`, `lastname`) VALUES (4, 'Digger'); INSERT INTO `test` (`id`, `lastname`) VALUES (5, 'Duck'); INSERT INTO `test` (`id`, `lastname`) VALUES (6, 'Font'); INSERT INTO `test` (`id`, `lastname`) VALUES (7, 'Find'); INSERT INTO `test` (`id`, `lastname`) VALUES (8, 'Zone'); INSERT INTO `test` (`id`, `lastname`) VALUES (9, 'Xtra'); INSERT INTO `test` (`id`, `lastname`) VALUES (10, 'Yps');

Regards, Sergei