[Rt-devel] Re: r3602 - in rt/branches/QUEBEC-EXPERIMENTAL: . lib/RT

Alex Vandiver alexmv at bestpractical.com
Thu Aug 18 10:40:55 EDT 2005


On Thu, 2005-08-18 at 17:25 +0600, Ruslan Zakirov wrote:
> I don't see reason why you need LEFT JOIN for sorting. Could you show
> us why we can't use prev. solution.

Otherwise the JOINs required to give us a requestors column to sort on
leave out tickets that have no requestor; the LEFT JOINs give us nulls
in the requestor columns, instead of the JOINS which would eliminate the
row entirely.  The patch hence fixes a problem where sorting by
requestor limited the tickets to those which had a requestor.
 - Alex


More information about the Rt-devel mailing list