Searchbuilder/RT problem with Oracle


Heads up! RT 1.3.71 exposes a bug in the way that DBIx::SearchBuilder constructs
queries for oracle.


----- Forwarded message from -----Date: Fri, 11 May 2001 18:05:01 -0400 (EDT)
Subject: Searchbuilder/RT problem

I just upgraded my rt2 installation to 1-3-71 and Searchbuilder .30 and
found a bug in Searchbuilder. RT tries to use a LIMIT clause to only
select 25 tickets for display on the home page. However, Searchbuilder
always uses a LIMIT keyword in the SQL, which isn’t valid on Oracle and
causes no results to be displayed.

Having the _LimitClause method always return an empty string is a
temporary work-around. However, it would be good if were fixed. I can
test patches if you need someone with Oracle access.

----- End forwarded message -----

jesse reed vincent –
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

“That package looks like what I wanted, but the site was down today,
so I decided to reimplement it in Perl.”