X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fcount%2Fcount_rs.t;fp=t%2Fcount%2Fcount_rs.t;h=a5e4098df005e728f4e7dfbdb54579051f78992d;hb=00336453444021a6422e05539ff4fc86c703a6b6;hp=b2c2827ad16b03c93bd32d61551ca7fd3f364e39;hpb=1b6fe47d369e84831a8a881813a53cca68694e72;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/count/count_rs.t b/t/count/count_rs.t
index b2c2827..a5e4098 100644
--- a/t/count/count_rs.t
+++ b/t/count/count_rs.t
@@ -133,7 +133,7 @@ my $schema = DBICTest->init_schema();
     $crs->as_query,
     '(SELECT COUNT( * )
       FROM (
-        SELECT me.artistid, MAX( cds.year ) AS newest_cd_year 
+        SELECT MAX( cds.year ) AS newest_cd_year, me.artistid
           FROM artist me 
           LEFT JOIN cd cds ON cds.artist = me.artistid 
         GROUP BY me.artistid