On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall <[email protected]> wrote: > On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote: >> Kristian, >> >> I think the problem is in SearchBuilder/Handle.pm in the function >> _MakeClauseCaseInsensitive. It looks like it only skips the lower() >> for integer values. I think that you can replace the if test with >> something like: >> >> if ($value !~ /^[\d:- ]+$/) { # don't downcase integer values or timestamps > > Oops, that should read: > > if ($value !~ /^[-\d: ]+$/) { # don't downcase integer values or timestamps
Excellent. I changed this line in Handle.pm and Pg.pm and it now works again. I wonder if upgrading postgres ( 8.1.9-1.el4s1.1 -> 8.3.6-1PGDG.rhel4) or perl (5.8.8-4.el4s1 -> 5.8.8-6.el4s1_3) could have caused this, as I managed to get it working before without code tweaks. Many thanks Ken! My next project is to convert this back to mysql eventually (82k tickets). A task I'm not looking forward to. Cheers, Kristian _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
