FullText Searching: The Dilemma

[Max Kanat-Alexander]

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.

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

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.