FullText Searching: The Dilemma

[Bradley Baetz]

On 27/06/07, Max Kanat-Alexander <mkanat at bugzilla.org> wrote:
> On Wed, 27 Jun 2007 09:30:33 +1000 "Bradley Baetz" <bbaetz at acm.org>
> wrote:
> > Postgres supports functional indexes. So you create an index on
> > UPPER(column) and then a search WHERE UPPER(column) = 'FOO' will use
> > the index.
>
>         Yes, I know. We use those already in a few cases. The problem
> isn't that--the problem is modifying all of Bugzilla to use
> $dbh->sql_istrcmp, which would also be ugly and hard to maintain.

Where apart from Search.pm needs to be changed, though? And even then
most of those sort of queries can be made to be fulltext queries
anyway.

Most other things (eg group names, email addresses) could be case
folded on input, although people may not like that for emails.

Bradley