300548 - sum word matches for basic relevance ordering in ANSI full text search

Status: NEW

(Bugzilla :: Query/Bug List, defect)

Description

[Myk Melez [:myk] [@mykmelez]]

For databases without full text searching functionality, Bugzilla provides an
ANSI SQL compliant full text search equivalent.  But that equivalent doesn't
order matches by relevance.  For searches on more than one word, a very basic
relevance ordering could be obtained by calculating the sum of word searches
(which either return the number one for found or the number zero for not found)
and using that sum as the relevance.

Making this depend on bug 232612 since it touches the same area of the code, and
we probably shouldn't hack this together until that gets checked in.  Of course,
perhaps we shouldn't hack this together at all.  After all, how much time is it
worth spending on the ANSI SQL implementation when we expect any serious
database to provide its own implementation?  MySQL has one, and PostGreSQL, the
only other database on the Bugzilla horizon, apparently does too (available as
an addon I think), although I don't think Bugzilla's PostGreSQL support uses it yet.