FullText Searching: The Dilemma

Max Kanat-Alexander mkanat at bugzilla.org
Tue Jun 26 23:31:01 UTC 2007

On Wed, 27 Jun 2007 09:30:33 +1000 "Bradley Baetz" <bbaetz at acm.org>
> 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.

	Remember, MySQL *doesn't* support functional indexes, and
*won't* use a normal index on LOWER(col) = 'blah';

Competent, Friendly Bugzilla Services. And Everything Else, too.

More information about the developers mailing list