[rt-users] RT 3.8.9 + PostgreSQL 8.4.7 - missing/bad indexes

[Jesse Vincent]

> 
> Okay, but does removing the LOWER()'s make the product harder to use?
> In other words, when writing a Scrip that uses Type would it now be
> case sensitive? i.e. Were AdminCc and admincc both acceptable? Some
> of my most painful bug hunts were case-only related. Maybe the RT
> code already handles that. My two cents.


Those bits are internals and the API always drops the content into the
database in one specific way. If you have your own code that's touching
Type or Domain, you've already voided your warranty, so to speak.  The 
fact that there's case-smashing on that search is a straight-up bug.
 
> Ken

--