X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class.git;a=blobdiff_plain;f=t%2Fprefetch%2Fjoin_type.t;h=f0772292f8a86c8870f457d101cda3d79099772c;hp=10a8783f96bbe5fcca7c49852438daa4ab66dbea;hb=c97338007ede15e7c62095a642b3de382a3508bd;hpb=571df6765aada245c9882a358cd4269541a178b4

diff --git a/t/prefetch/join_type.t b/t/prefetch/join_type.t
index 10a8783..f077229 100644
--- a/t/prefetch/join_type.t
+++ b/t/prefetch/join_type.t
@@ -38,7 +38,7 @@ is_same_sql_bind (
       JOIN artist artist ON artist.artistid = me.artist
       LEFT JOIN cd cds ON cds.artist = artist.artistid
       LEFT JOIN artist artist_2 ON artist_2.artistid = cds.artist
-    ORDER BY me.cdid
+    ORDER BY cds.artist, cds.year ASC
   )',
   [],
 );