#11263: Bug in lookup with generic relation in model inheritance
--------------------------------------------------------+-------------------
               Reporter:  veena                         |         Owner:  
nobody                              
                 Status:  new                           |     Milestone:  1.3   
                              
              Component:  Database layer (models, ORM)  |       Version:  SVN   
                              
             Resolution:                                |      Keywords:  
generic relations, model inheritance
           Triage Stage:  Accepted                      |     Has patch:  1     
                              
    Needs documentation:  1                             |   Needs tests:  1     
                              
Patch needs improvement:  0                             |  
--------------------------------------------------------+-------------------

Comment (by amarkor):

 Can confirm that at least the content_type_id between the two queries is
 different.

 {{{
 Photo.objects.filter(order__status='ordered').query
 }}}

 {{{
   SELECT "generic_relations_regress_media"."id",
        "generic_relations_regress_photo"."media_ptr_id"
    FROM "generic_relations_regress_photo"
    INNER JOIN "generic_relations_regress_media"
       ON ("generic_relations_regress_photo"."media_ptr_id" =
           "generic_relations_regress_media"."id")
    INNER JOIN "generic_relations_regress_order"
       ON ("generic_relations_regress_media"."id" =
           "generic_relations_regress_order"."object_id")
    WHERE ("generic_relations_regress_order"."status" = ordered
    AND "generic_relations_regress_order"."content_type_id" = 26 )
 }}}

 {{{
 photo.order.filter(status='ordered').query
 }}}

 {{{
 SELECT "generic_relations_regress_order"."id",
        "generic_relations_regress_order"."content_type_id",
        "generic_relations_regress_order"."object_id",
        "generic_relations_regress_order"."status"
    FROM "generic_relations_regress_order"
    WHERE ("generic_relations_regress_order"."object_id" = 1
    AND "generic_relations_regress_order"."content_type_id" = 27
    AND "generic_relations_regress_order"."status" = ordered )
 }}}

 patch attached.

-- 
Ticket URL: <http://code.djangoproject.com/ticket/11263#comment:18>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Reply via email to