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
11263	Bug in lookup with generic relation in model inheritance	veena	nobody	"{{{
#!python
class Order(models.Model):
    content_type = models.ForeignKey(ContentType)    
    object_id = models.PositiveIntegerField()
    content_object = generic.GenericForeignKey()
    status = models.CharField(max_length=10, default='ordered')
    
class Visitor(Person):
    order = generic.GenericRelation(Order)
    

Visitor.objects.filter(order__status='ordered').count()
}}}

It creates this broken query:

{{{
#!sql
SELECT COUNT(*)
FROM ""expo_visitor""
INNER JOIN ""expo_order"" ON (""expo_visitor"".""person_ptr_id"" = ""expo_order"".""object_id"")
INNER JOIN ""expo_order"" T3 ON (""expo_order"".""person_ptr_id"" = T3.""id"")
WHERE (T3.""status"" = %s AND T3.""content_type_id"" = %s )'
}}}

There is non existent column ""expo_order"".""person_ptr_id"""	Bug	closed	contrib.contenttypes	dev	Normal	fixed	generic relations, model inheritance	ramusus@… nator	Accepted	1	1	1	0	0	0