Do we want Bugzilla to be case-sensitive or case-insensitive?

Max Kanat-Alexander mkanat at bugzilla.org
Thu Nov 3 19:54:01 UTC 2005


	I think that perhaps the heart of the issue has been slightly missed,
in some of the discussion here.

	When using the Search screen, Products, Components, Keywords,
Summaries, *anything* that you type in the Boolean Charts -- all are
*case sensitive* on PostgreSQL. In fact, any text that you type
*anywhere* to match *anything* is case sensitive on PostgreSQL.

	The is NO database-wide way around that.

	The only way to fix it is to make EVERY SINGLE:

	product = ?

	into:

	$dbh->sql_istrcmp('product', '?')

	In ALL OF BUGZILLA. And not just for products, but for everything that
we want to match, anywhere, ever.

	At which point, on some DBs, we'd lose the value of our indexes, or on
some others we'd have to start keeping track of a bunch of indexes on
LOWER(product).

	Since we're not going to do that, we made only the most critical thing
(usernames) case-insensitive on PostgreSQL, and everything else is case
sensitive.

	If anybody comes up with a way to make an entire PostgreSQL database do
case-insensitive comparisons, then I'm certainly open to it.

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




More information about the developers mailing list