On Mon, 24 Feb 2003, Lee Daniel Crocker wrote:
Also, the min-length thing is independent of that
choice anyway. By
default, MySQL won't index any word fewer than 4 letters long, and we
got lots of complaints that you couldn't search for "PNG" or
"XP".
MySQL has to be recompiled to change that limit, and the local setting
just informs the wiki software of how MySQL was compiled so it knows
what it can hand to the indexer.
Well, yes and no. If we don't parse the query into separate words, it
doesn't matter how much we hand to it: a MATCH AGAINST( "Windows XP" )
will still turn up all the results for "Windows", whereas MATCH AGAINST(
"Windows" ) AND MATCH AGAINST ("XP") returns nothing at all --
that's why
we need to be aware of it and remove the too-short words from the search
using our hackish boolean system.
However, it would be nice to spit out a little message to the effect of
"The word 'XP' has been ignored in your search because MySQl doesn't
like
it," whatever the search method.
-- brion vibber (brion @
pobox.com)