[Rt-devel] DBIx::SearchBuilder and RT2

[Florian Weimer]

* Jesse Vincent:

>> @keys has got a single element, and the else branch of the if is
>> taken.  Which means, of course, that the single element in @keys is
>> constantly removed and added again.
>> 
>> What is the code supposed to do?
>
> The code is _supposed_ to make sure you don't join on a table that
> hasn't been listed yet. It's probably sufficient to put a check to make
> sure there's not a single element there.  Can you build up a simple
> failure case?

Elements/MyRequests in RT 2.0.15 triggers it, during a call to
RT::Ticket::Next.  The query is constructed as follws:

my $MyTickets;
$MyTickets = new RT::Tickets ($session{'CurrentUser'});
$MyTickets->LimitRequestor(VALUE => $session{'CurrentUser'}->EmailAddress);
$MyTickets->LimitStatus(VALUE => "open");
$MyTickets->LimitStatus(VALUE => "new");
$MyTickets->OrderBy(FIELD => 'Priority', ORDER => 'DESC');
$MyTickets->RowsPerPage(25);

-- 
Current mail filters: many dial-up/DSL/cable modem hosts, and the
following domains: bigpond.com, di-ve.com, hotmail.com, jumpy.it,
libero.it, netscape.net, postino.it, simplesnet.pt, spymac.com,
tatanova.com, tiscali.co.uk, tiscali.cz, tiscali.it, voila.fr, yahoo.com.