php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17391 MySQL's FULLTEXT index not usefull for the bugsystem
Submitted: 2002-05-23 11:03 UTC Modified: 2002-09-18 20:08 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: edink at proventum dot net Assigned:
Status: Closed Package: Website problem
PHP Version: 4.0CVS-2002-05-23 OS: N/A
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: edink at proventum dot net
New email:
PHP Version: OS:

 

 [2002-05-23 11:03 UTC] edink at proventum dot net 
I don't seem to be getting any results when I enter data in "Find bugs with any of the words" field.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-05-23 20:44 UTC] jimw@php.net 
works fine for me. can you give a specific example that fails to return any results?
 [2002-05-23 21:01 UTC] edink@php.net 
I searched for pow which failed to find bug #17374. I still cannot find that bug if I search for "pow" and status "closed" (I've closed the bug report in the meanwhile).

Btw, I'm not able to respond as a regular user, so I had to use my dev account. The error I get is "You aren't allowed to change a bug to that state."
 [2002-05-24 13:02 UTC] sander@php.net 
Words with less than 4 characters are ignored by MySQL's full-text search which is used by this bug system. That full-text thingy sucks anyway but AFAIK it's the only serious indexing that can be used on TEXT's.
 [2002-05-30 05:19 UTC] edink@php.net 
Apparently that can be solved only by recompiling MySQL. Anyone willing to do so?
 [2002-06-16 07:53 UTC] sander@php.net 
Let's make this bugreport a generic complain-report about MySQL's FULLTEXT indexing/search stuff:

-as stated above, it ignores words with three or less letters...
-it uses an OR search
-it ignores "quotes to search for a certain string"

Does anybody know of a good alternative to index over 30 megs of text?
 [2002-09-18 20:08 UTC] iliaa@php.net 
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at 
http://www.php.net/downloads.php

Apparently someone did recompile MySQL, since searching for words <4 characters long, now works.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun May 19 10:01:32 2024 UTC