I have a schema where there are clients who have subscribers.
So there is an object "Client" which has a has_many relationship to
"Subscriber".
If I do the following
my $client = $app->schema->resultset('Client')->find(...);
my $subscribers = $client->subscribers;
Then the relationship is correct and only pulls out the subscribers
attached to that client.
But if I do the following.
my $client = $app->schema->resultset('Client')->new({});
my $subscribers = $client->subscribers;
Then all the subscribers are pulled out which is not ideal and
potentially a very embarrassing privacy breach. Looking at the SQL
generated by "$client->subscribers" it is not putting in the limiting
where clause "WHERE me.client_id = ..."
This is occurring in version 0.08008.
Brett
_______________________________________________
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/[EMAIL PROTECTED]
