On 5/27/07, Nigel Metheringham
<[EMAIL PROTECTED]> wrote:
On 27 May 2007, at 18:31, Paul Makepeace wrote:
> I notice adding a prefetch to a search causes some results to go
> missing in the case that the column being joined on is null in the
> first table. This is down to prefetch using an inner rather than left
> join. Presumably y'all had a reason for that? The left join solved it
> for me (in SQL tests). Is there a work-around for this?
You can change the join type used in a relationship - see the
join_type attribute in the DBIx::Class::Relationship::Base
documentation (near the top of the page).
Have you tried your own advice? Because join_type => 'left' does not
appear to affect how prefetch works, at least afaics. ($VERSION =
'0.07006')
Devs, is having prefetch use an inner join a deliberate choice?
P
Nigel.
--
[ Nigel Metheringham [EMAIL PROTECTED] ]
[ - Comments in this message are my own and not ITO opinion/policy - ]
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
