[Dbix-class] inner join in prefetch drops some rows

[Nigel Metheringham]

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).

	Nigel.
--
[ Nigel Metheringham           Nigel.Metheringham at InTechnology.co.uk ]
[ - Comments in this message are my own and not ITO opinion/policy - ]