Hi all,
Before I rush off and possibly file a bogus bug report, am I seeing
incorrect behavior here?
I have a simple 'Project' model, as so:
class Project(models.Model):
deployment = models.ForeignKey(Deployment, blank=True, null=True)
... some other fields here
Some of the projects in the db do not have a deployment.
When I run
Project.objects.all().count() it counts all the records in the project
table.
When I run
Project.objects.all() it tries to do an inner join to the deployment
table, which of course cuts out all projects that don't have a
deployment.
>>> m.Project.objects.all().query.as_sql()
('SELECT `tasks_project`.`id`, `tasks_project`.`deployment_id`,
`tasks_project`.`name`, `tasks_project`.`active`,
`tasks_project`.`is_support` FROM `tasks_project` INNER JOIN
`tasks_deployment` ON (`tasks_project`.`deployment_id` =
`tasks_deployment`.`id`) ORDER BY `tasks_deployment`.`name` ASC,
`tasks_project`.`name` ASC', ())
I have tried .select_related(depth=0) but that returns exactly the
same sql, which really, to my mind anyway, it should not. I explicitly
asked it not to select the deployments with depth=0, didn't I?
I am running revision 7569 of trunk.
Cheers,
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
