[rt-users] Problem Tools, Reports Postgres 3.8.2

[Kenneth Marshall]

On Fri, Mar 13, 2009 at 12:42:11AM +0000, Kristian Davies wrote:
> 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
> 
Kristian,

It does sound like something is missing because I am running
PostgreSQL 8.3.5 and did not have to make these changes. I do have
a question, why are you converting your RT instance to MySQL? Is
there a particular problem you are trying to address?

Just wondering?
Ken