[rt-users] second-level sort

Vivek Khera khera at kcilink.com
Mon Mar 8 09:58:27 EST 2004


On Mar 6, 2004, at 3:05 PM, Ben Goodwin wrote:

> Yes, this is due to the addition of a 'UNIQUE' in the SELECT call in 
> the
> more recent DBI::Searchbuilder's.  The resulting MySQL query returns 
> data in
> a different order - if you can even call it an order.
> My solution was to use the newer "OrderByCols" feature.  I copied
>

well, no ordering is guaranteed unless you explicitly specify an ORDER 
BY that you want.  in Postgres 7.4, this may bite you too, since the 
UNIQUE and GROUP BY implementations have changed, and they no longer 
implicitly order by the UNIQUE or GROUPed element(s).




More information about the rt-users mailing list