#17391 [Opn->Csd]: MySQL's FULLTEXT index not usefull for the bugsystem

ID: 17391 Updated by: iliaa@php.net Reported By: edink@proventum.net -Status: Open +Status: Closed Bug Type: Website problem Operating System: N/A PHP Version: 4.0CVS-2002-05-23 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2002-06-16 07:53:53] 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-05-30 05:19:18] edink@php.net Apparently that can be solved only by recompiling MySQL. Anyone willing to do so? ------------------------------------------------------------------------ [2002-05-24 13:02:19] 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-23 21:01:03] 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-23 20:44:34] jimw@php.net works fine for me. can you give a specific example that fails to return any results? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/17391 -- Edit this bug report at http://bugs.php.net/?id=17391&edit=1