> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dbix-class- > [EMAIL PROTECTED] On Behalf Of Mike Rylander > Sent: Thursday, April 13, 2006 4:53 AM > To: [email protected] > Subject: Re: [Dbix-class] wishlist: "might_have_many" > > On 4/12/06, Mark Hedges <[EMAIL PROTECTED]> wrote: > > > > I found that if I do a prefetch on a Foo RS to its have_many > > Bar, but it doesn't have any Bars, I don't get the Foo at all. > > > > This is similar to a problem where if I do a prefetch from one > > to another with a 1:1 relationship, but the other doesn't exist, > > it does not work if I defined with has_one but it does work if I > > defined if might_have. > > > > However there isn't a fix for a 1:N relationship. (Doesn't 1:N > > imply that N could equal 0?) Instead I have to remember where > > this drop might occur and I get no object, and I can't prefetch. > > > > Sounds like has_many should use LEFT JOIN ... [he says, sniping from > the sidelines having not looked at the code] > > -- > Mike Rylander
I talked to castaway yesterday in IRC about changing the default join type for has_many to left join to prevent such things. What do you think about such a change? Till then I specify the join type myself for each rel I need a non-default value. -Alex *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Telefon +43 (0)57057 0, Telefax +43 (0)57057 8155 Bank Austria AG, BLZ 12000, Kto. 233-111-674/00, IBAN AT291200023311167400 Handelsgericht Wien, FN 79340b � DVR Nr. 0713520 � ARA-Lizenz Nr. 12554 ATU 15169001 *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Hinweis: Dieses E-mail kann vertrauliche und geschuetzte Informationen enthalten. Sollten Sie nicht der beabsichtigte Empfaenger sein, verstaendigen Sie bitte den Absender und loeschen Sie dieses E-mail dann sofort. Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ 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/
