Bug #17391 Updated: MySQL's FULLTEXT index not usefull for the bugsystem

ID: 17391 Updated by: sander@php.net -Summary: Advanced bug search not working Reported By: edink@proventum.net Status: Open Bug Type: Website problem Operating System: N/A PHP Version: 4.0CVS-2002-05-23 New Comment: 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? Previous Comments: ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ [2002-05-23 11:03:39] edink@proventum.net I don't seem to be getting any results when I enter data in "Find bugs with any of the words" field. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17391&edit=1