[rt-users] Problem Tools, Reports Postgres 3.8.2

[Kenneth Marshall]

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

because when including a dash ('-') in the character list it must
come first.

Sorry,
Ken

> 
> I do not have a sample query to test with, but if this works
> please let me know so I can log a bug report against DBIx::SearchBuilder.
> 
> Thanks,
> Ken