X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fgrouped.t;h=3db5f9e950e7a97755e1d92d208aa0ededdf35e9;hb=d8dbe471a2f98a0bc2de5e629f22ee2f2ec034ef;hp=85fd73014ee68a1e612fc112a06319a2250ee339;hpb=22ed9526e0504bbfbd6b288302160224f50e58f0;p=dbsrgits%2FDBIx-Class.git diff --git a/t/prefetch/grouped.t b/t/prefetch/grouped.t index 85fd730..3db5f9e 100644 --- a/t/prefetch/grouped.t +++ b/t/prefetch/grouped.t @@ -77,7 +77,7 @@ for ($cd_rs->all) { SELECT me.cd FROM track me JOIN cd cd ON cd.cdid = me.cd - WHERE ( me.cd IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) + WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) ) GROUP BY me.cd ) count_subq @@ -94,11 +94,11 @@ for ($cd_rs->all) { SELECT me.cd, COUNT (me.trackid) AS track_count, FROM track me JOIN cd cd ON cd.cdid = me.cd - WHERE ( me.cd IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) + WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) ) GROUP BY me.cd ) as me JOIN cd cd ON cd.cdid = me.cd - WHERE ( me.cd IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) + WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) ) )', [ map { [ 'me.cd' => $_] } ( ($cd_rs->get_column ('cdid')->all) x 2 ) ], 'next() query generated expected SQL',