X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fprefetch%2Fdouble_prefetch.t;h=d82f4c444cf92129e010e7cdf067f3b0490dfeff;hb=71ef99d5005601cf1c000b3183d945f79af2d30d;hp=b666220285f452d5c307f5a7789c70728f8aad23;hpb=f1952f5c69e092d9ce416586f29942f8c2f66bce;p=dbsrgits%2FDBIx-Class.git diff --git a/t/prefetch/double_prefetch.t b/t/prefetch/double_prefetch.t index b666220..d82f4c4 100644 --- a/t/prefetch/double_prefetch.t +++ b/t/prefetch/double_prefetch.t @@ -23,11 +23,11 @@ is_same_sql( '( SELECT cds.cdid, cds.artist, cds.title, cds.year, cds.genreid, cds.single_track, - single_track.trackid, single_track.cd, single_track.position, single_track.title, single_track.last_updated_on, single_track.last_updated_at, - single_track_2.trackid, single_track_2.cd, single_track_2.position, single_track_2.title, single_track_2.last_updated_on, single_track_2.last_updated_at, + single_track.trackid, single_track.cd, single_track.position, single_track.title, single_track.last_updated_on, single_track.last_updated_at, single_track.small_dt, + single_track_2.trackid, single_track_2.cd, single_track_2.position, single_track_2.title, single_track_2.last_updated_on, single_track_2.last_updated_at, single_track_2.small_dt, cd.cdid, cd.artist, cd.title, cd.year, cd.genreid, cd.single_track FROM artist me - LEFT JOIN cd cds ON cds.artist = me.artistid + JOIN cd cds ON cds.artist = me.artistid LEFT JOIN track single_track ON single_track.trackid = cds.single_track LEFT JOIN track single_track_2 ON single_track_2.trackid = cds.single_track LEFT JOIN cd cd ON cd.cdid = single_track_2.cd