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=a9326cd013e5ba69e199948b8ea03bc347dbb293;hb=b3577eaeda963fc6f869378cd741042ae6274666;hp=75dda03387e028a70988a204dcb8abf147316c6c;hpb=eb58c082cf9c35760d8fc199483d38c1d926b2e4;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 75dda03..a9326cd 100644 --- a/t/prefetch/o2m_o2m_order_by_with_limit.t +++ b/t/prefetch/o2m_o2m_order_by_with_limit.t @@ -4,8 +4,8 @@ use warnings; use Test::More; use lib qw(t/lib); -use DBIC::SqlMakerTest; use DBICTest; +use DBIC::SqlMakerTest; use DBIx::Class::SQLMaker::LimitDialects; my ($ROWS, $OFFSET) = ( @@ -102,7 +102,7 @@ for ( WHERE "me"."rank" = ? 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, + MAX("tracks"."title") DESC, "me"."name" ASC, "year" DESC, "cds_unordered"."title" DESC @@ -116,7 +116,7 @@ for ( ON "tracks"."cd" = "cds_unordered"."cdid" WHERE "me"."rank" = ? ORDER BY "genre"."name" DESC, - tracks.title DESC, + "tracks"."title" DESC, "me"."name" ASC, "year" DESC, "cds_unordered"."title" DESC