X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fo2m_o2m_order_by_with_limit.t;h=75dda03387e028a70988a204dcb8abf147316c6c;hb=eb58c082cf9c35760d8fc199483d38c1d926b2e4;hp=f9f78cab7ac3ae97b6795c03f240c2cdf4d3b0d6;hpb=23b2c49b17262ecf84307c9ffba88ed38ecc90cb;p=dbsrgits%2FDBIx-Class.git diff --git a/t/prefetch/o2m_o2m_order_by_with_limit.t b/t/prefetch/o2m_o2m_order_by_with_limit.t index f9f78ca..75dda03 100644 --- a/t/prefetch/o2m_o2m_order_by_with_limit.t +++ b/t/prefetch/o2m_o2m_order_by_with_limit.t @@ -100,10 +100,10 @@ for ( LEFT JOIN "track" "tracks" ON "tracks"."cd" = "cds_unordered"."cdid" WHERE "me"."rank" = ? - GROUP BY "cds_unordered"."cdid", "cds_unordered"."artist", "cds_unordered"."title", "cds_unordered"."year", "cds_unordered"."genreid", "cds_unordered"."single_track" + GROUP BY "cds_unordered"."cdid", "cds_unordered"."artist", "cds_unordered"."title", "cds_unordered"."year", "cds_unordered"."genreid", "cds_unordered"."single_track", "me"."name" ORDER BY MAX("genre"."name") DESC, MAX( tracks.title ) DESC, - MIN("me"."name"), + "me"."name" ASC, "year" DESC, "cds_unordered"."title" DESC LIMIT ?