X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fgrouped.t;h=760e3814a73c06be3a897564793fdd7611fe5313;hb=0077982b2edc8273ab4b6ea59921177667008cb3;hp=c50b7ef3c2aa2c78a7120c0d7dd35b005af5f0a1;hpb=977f88cb4a2a252c91a6b4233bc4de59b702b9c1;p=dbsrgits%2FDBIx-Class-Historic.git

diff --git a/t/prefetch/grouped.t b/t/prefetch/grouped.t
index c50b7ef..760e381 100644
--- a/t/prefetch/grouped.t
+++ b/t/prefetch/grouped.t
@@ -294,7 +294,6 @@ for ($cd_rs->all) {
               FROM cd me
               JOIN artist artist ON artist.artistid = me.artist
             GROUP BY me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
-            ORDER BY me.cdid
           ) me
           JOIN artist artist ON artist.artistid = me.artist
           ORDER BY me.cdid
@@ -323,7 +322,6 @@ for ($cd_rs->all) {
               JOIN artist artist ON artist.artistid = me.artist
             WHERE ( tracks.title != ? )
             GROUP BY me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
-            ORDER BY me.cdid
           ) me
           LEFT JOIN track tracks ON tracks.cd = me.cdid
           JOIN artist artist ON artist.artistid = me.artist