12 my $schema = DBICTest->init_schema();
14 my $cds = $schema->resultset("CD")->search({ cdid => 1 }, { join => { cd_to_producer => 'producer' } });
15 cmp_ok($cds->count, '>', 1, "extra joins explode entity count");
18 $cds->search({}, { prefetch => 'cd_to_producer' })->count,
20 "Count correct with extra joins collapsed by prefetch"
24 $cds->search({}, { distinct => 1 })->count,
26 "Count correct with requested distinct collapse of main table"
29 my $artist=$schema->resultset('Artist')->create({name => 'xxx'});
30 is($artist->related_resultset('cds')->count(), 0,
31 "No CDs found for a shiny new artist");
32 my $artist_rs = $schema->resultset('Artist')->search({artistid => $artist->id});
33 is($artist_rs->related_resultset('cds')->count(), 0,
34 "No CDs found for a shiny new artist using a resultset search");