Fix broken tests that would fail in future SQL::Abstract

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

diff --git a/t/search/select_chains_unbalanced.t b/t/search/select_chains_unbalanced.t
index 99dcc00..b803c0f 100644 (file)
--- a/t/search/select_chains_unbalanced.t
+++ b/t/search/select_chains_unbalanced.t
@@ -42,7 +42,7 @@ my @chain = (
           me.cdid,
           DISTINCT(foo, bar),
           me.genreid,
-          (SELECT me.name, me.rank FROM artist me WHERE ( artistid 1 )),
+          (SELECT me.name, me.rank FROM artist me WHERE ( artistid 1 ))
         FROM cd me'
     => [qw/title cd_id foo bar genreid name rank/],
 
@@ -56,7 +56,7 @@ my @chain = (
           DISTINCT(foo, bar),
           me.genreid,
           (SELECT me.name, me.rank FROM artist me WHERE ( artistid 1 )),
-          COUNT( me.cdid ) AS cnt,
+          COUNT( me.cdid ) AS cnt
         FROM cd me'
     => [qw/title len cd_id foo bar genreid name rank cnt/],
   {