S::L tests rely on preserving the sqlmaker between reconnections

[dbsrgits/DBIx-Class.git] / t / prefetch / o2m_o2m_order_by_with_limit.t

diff --git a/t/prefetch/o2m_o2m_order_by_with_limit.t b/t/prefetch/o2m_o2m_order_by_with_limit.t
index f9f78ca..65a2c39 100644 (file)
--- a/t/prefetch/o2m_o2m_order_by_with_limit.t
+++ b/t/prefetch/o2m_o2m_order_by_with_limit.t
@@ -4,8 +4,7 @@ use warnings;
 use Test::More;
 
 use lib qw(t/lib);
-use DBIC::SqlMakerTest;
-use DBICTest;
+use DBICTest ':DiffSQL';
 use DBIx::Class::SQLMaker::LimitDialects;
 
 my ($ROWS, $OFFSET) = (
@@ -100,10 +99,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 ?