MATCH / AGAINST problem/bug
========================
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
Under some circumstances this query does never terminate. The win32
service cannot be stopped either.
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
HAVING score > 0 ORDER by score DESC
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, |
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
