[Dbix-class] different query after upgrade

[Wallace Reis]

On Fri, Aug 21, 2009 at 4:22 PM, Steve Rippl<rippls at woodlandschools.org> wrote:
> Now the following in my app
>
> $c->stash->{sections} = [$c->model('DB::Section')->search(
>                               {},
>                               {
>                                 join => [{'course_sections' => 'courses'} ,
> {'staff_sections' => 'staffs'}],
>                                 order_by => ['courses.grade',
> 'staffs.name_last'],
>                                 prefetch => [{'course_sections' =>
> 'courses'} , {'staff_sections' => 'staffs'}],
>                                })];

Are you sure that the rel between 'course_sections' class and
'courses' class is a belongs_to (or a proper add_relationship setup),
as well between 'staff_sections' class and 'staffs' class? If so,
report with a failing test case.

-- 
     wallace reis/wreis         Catalyst and DBIx::Class consultancy with a clue
     Software Developer		and a commit bit: http://shadowcat.co.uk/catalyst/
 Shadowcat Systems Limited
 http://www.shadowcat.co.uk     http://www.linkedin.com/in/wallacereis