fulltextsearch causes infinitive loop in mysqld

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);

the second "T*" seems to produce the problem but only if it is the 4th 
or a later searchstring:
This works fine:
select * from <tableName> where match(<columnName>) against('T* A* T*' 
in boolean mode);

Another problem, which might have to do with the first one is, any 
searchstring after the 3rd doesn't produce any results:

select * from <tableName> where match(<columnName>) against('T* A* D*' 
in boolean mode);

==> all rows with <columnName> beginning with "T" or "A" or "D"

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 tried it on two machines running Linux with mysql 4.0.14 and Windows2k 
with mysql 4.0.15. The second machine (nearly) crashed because mysqld-nt 
used all CPU-resources and couldn't be stopped, so this might be a nice 
DOS-Attack against Windows based mysql databases ;-).


Greets
    hurle


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