[Dbix-class] Prefetch with a has_many relationship and rows
attribute
Sam Kaufman
sam.kaufman at takkle.com
Thu Jun 19 21:17:16 BST 2008
Ran into this inconsistency, we're using MySQL but I imagine it's probably the same for any db.
# say $parents is a resultset of 100 'parents'
# with each one having 20 'children'
my $rs = $parents->search({},
{rows => 20}
);
# ^ Fine, gives you 20 parents
my $rs = $parents->search({},
{ rows => 20, prefetch => 'children' }
);
# ^ not fine, will give you one 'parent' because the 'rows' attribute gets
# piped in as 'LIMIT 20'
More information about the DBIx-Class
mailing list