[rt-users] bug in watcher search for Postgres

[Rafael Corvalan]

In fact, but this is not the only problem with Postgres. If you are a
registered user with the e-mail "myname at macompany.com" and you send an
e-mail with the "From" field set to "MyName at company.com", you are not
the same user...
Jesse told me to use the method CanonicalizeAddress() in config.pm to
correct that (putting a lc() call), but I think this will not correct
your problem.

If someone in the list is a postgres specialist, maybe he could tell us
if there is a way to configure a column table to do case insensitive
searches...

-----Original Message-----
From: Vivek Khera [mailto:khera at kcilink.com] 
Sent: lundi, 30. juillet 2001 23:11
To: RT Users
Subject: [rt-users] bug in watcher search for Postgres


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/

_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com http://lists.fsck.com/mailman/listinfo/rt-users