MATCH / AGAINST fatal bug
========================
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
RAM: 1GB Apacer
Free Disk Space: 32GB
HD Write Back Cache: Disabled
Under some circumstances the following query does never terminate. The
win32 service cannot be stopped either = FATAL.
SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST
('550') AS score FROM file as f, filesys as fs WHERE f.id = fs.fileid
AND MATCH (f.title,f.body) AGAINST ('550') > 0 ORDER by score DESC
Same behavior can be seen with "HAVING score > 0" or when using BOOLEAN
mode.
If you are not interested in fixing this bug any advice how to
circumvent this bug would be appreciated.
Thanks a lot.
-Mat
SmartFTP.com
mysqladmin -proc Output
===================
| 25850 | kb | localhost | kb | Query | 17497 | Copying to tmp table
| SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST
('2147220991') AS score FROM file |
OR
| 37522 | kb | localhost | kb | Query | 1323 | Copying to tmp table
| SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST
('550') AS score FROM file as f, |
OR
| 56040 | kb | localhost | kb | Query | 13095 | Copying to tmp table
| SELECT f.id as id, fs.name as name, fs.id as fsid, MATCH
(f.title,f.body) AGAINST ('asteriks') AS sc |
Table Structure
===========
#
# Table structure for table `file`
#
CREATE TABLE file (
id int(11) NOT NULL auto_increment,
title text,
version varchar(255) default NULL,
created int(11) NOT NULL default '0',
modified int(11) default NULL,
body text,
hits int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY modified (modified),
KEY hits (hits),
KEY created (created),
FULLTEXT KEY titlebody (title,body),
FULLTEXT KEY body (body)
) TYPE=MyISAM;
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
