[Fulltextsearch-devel] Table/phrase searches - bug report and patch

[Kate L P. <ka...@ea...>]

I found what I think is a bug with table/phrase searches.  The way the
table backend works is that it pulls all the information out of the
table and joins it together with spaces -- so if you're searching for
a phrase such as "antique furniture", and the data in one of your
columns ends in "antique" and the data in the next one starts with
"furniture", you'll get picked out even if you don't contain the
phrase "antique furniture" at all.

I think this is a bug because it's non-intuitive behaviour and it's
dependent on the order of the columns.  If nobody else thinks it's a
bug then it should certainly be documented.  I've appended a patch and
tests though, in case other people want it changed too.

(The test is written using Test::More -- would there be interest or
howls of disapproval if I overhauled the test suite to use Test::More
instead of the current 'print "ok 2\n"' stuff and to improve the test
coverage?  I'm unlikely to do the latter without the former.)

Kake
-- 
http://www.earth.li/~kake/cookery/ - vegan recipes, now with new search feature
http://grault.net/grubstreet/ - the open-source guide to London
http://www.penseroso.com/ - websites for the fine art and antique trade