id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10628	RelatedManager and NULL	anonymous	nobody	"My Model:

{{{
class Active(models.Model):
 post    = models.ForeignKey(Post, related_name='activeposts')
 rubrica = models.ForeignKey(Rubrica, related_name='activeposts', null=True, blank=True)
 type    = models.ForeignKey(Type, related_name='activeposts', null=True, blank=True)
}}}

Code:
{{{
>>> p = Post.objects.get(pk=1206535731)
>>> p.activeposts.filter(type__pk=2, rubrica__isnull=True)
}}}

return empty result. but a have data in database.

{{{
>>> p.activeposts.filter(type__exact=2, rubrica__isnull=True).query.as_sql()
('SELECT `doska_active`.`id`, `doska_active`.`post_id`, `doska_active`.`rubrica_id`, `doska_active`.`type_id` FROM `doska_active` LEFT OUTER JOIN `doska_rubrica` ON (`doska_active`.`rubrica_id` = `doska_rubrica`.`id`) WHERE (`doska_active`.`post_id` = %s  AND `doska_active`.`type_id` = %s  AND `doska_rubrica`.`id` IS NULL)', (1206535731, 2))
}}}

Problem in '''AND `doska_rubrica`.`id` IS NULL'''"		closed	Database layer (models, ORM)	1.1-beta		invalid			Unreviewed	0	0	0	0	0	0