Hi!
On Mar 12, Mathias Berchtold wrote:
> 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.
Of course we're interested!
But you really told too little for us to know where to look for the
bug :(
Please try to create a repeatable test case.
"Under some circumstances" doesn't help that much, sorry...
> 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 |
>
> 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
>
>
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
