[rt-users] Problem Tools, Reports Postgres 3.8.2

[Kristian Davies]

On Thu, Mar 12, 2009 at 1:51 PM, Kenneth Marshall <ktm at rice.edu> 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