Hello there, I'm not sure if this is the expected behavior or not (ie. bug vs feature).
In a relationship structure like this: entity->has_many->has_many->belongs_to If "prefetch" is used the results up to the last belongs_to relationship, the resulting query will use LEFT JOINs for the has_many relationships, but then use a regular join for the last belongs_to (which will prevent "entity" from appearing in the resultset). If "join" is used, all joins are made using LEFT JOINs and it works (although I would consider nested joins to be the proper solution, this also works fine). So - is prefetch really expected to work like that? I can explain better if this message isn't clear enough and a test case if it seems to be a bug. -Nilson Santos F. Jr. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk