is_same_sql_bind (
$rs->as_query,
- '(SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track, me.cdid, me.title, artist.name FROM cd me JOIN artist artist ON artist.artistid = me.artist)',
+ '(SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track, artist.name FROM cd me JOIN artist artist ON artist.artistid = me.artist)',
[],
'Use of columns attribute results in proper sql'
);
'limited prefetch via column works on a multi-relationship',
);
-$sub_rs = $rs->search ({},
+my $sub_rs = $rs->search ({},
{
columns => [qw/artist tracks.trackid/], # columns should not be merged but override $rs columns
'+select' => ['tracks.title'],