[rt-users] bug in watcher search for Postgres

[Vivek Khera]

It seems that searching for matching users to add to a watcher list is
not case-insensitive with Postgres.  For example, my ID has
organization of "MailerMailer LLC" but searching for organization
contains mail returns no matches.  Searching for Mail does return
matches.

I'm suspecting that there are other places where case-insensitivity
would be desirable, but isn't, due to the MySQL origins of the queries
(which is case insensitive by default.)

The fix is to find the queries and make them something like:

$x = lc($x);
then run query:

 select whatever from sometable where lower(fieldname) like '%$x%'


I haven't dug into the code to fix this just yet.

RT version 2.0.2 (with the 2.0.3 patch)... (how does one verify this
from the UI?)

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/