And, I think your problem is the same that makes "union with an empty queryset always result in an empty queryset" bug:
User.objects.filter(Q) | User.objects.none() => always returns an empty queryset. -- omat On May 30, 12:12 pm, omat <[EMAIL PROTECTED]> wrote: > Hi Julien, > > I think the OR'ing of querysets (unions) is bogus. > > When I have a queryset that has some 'extra' parameter that builds a > non-exclusive join SQL, and try to merge it with an other queryset, > the table names are not handled correctly. Sometimes some tables are > ignored and sometimes they are injected into SQL's FROM multiple times > resulting in a DB error. > > I tried to explain the problem here, last > week:http://groups.google.com/group/django-users/browse_thread/thread/48cd... > > And I found a ticket that can be related to the > issues:http://code.djangoproject.com/ticket/7277 > > I tried to track down the problem in the django.db.query and solve my > problems partially by monkey patching but I am not comfortable at all > and looking forward for the official resolution. > > -- > omat > > On May 30, 9:57 am, Julien <[EMAIL PROTECTED]> wrote: > > > Hi, > > > A while ago I stumbled on a bug with OR lookups, but Malcolm had > > apparently fixed it in the queryset-refactor branch [1]. However I've > > just got a similar issue. Is that still a bug or am I mis-using it? > > > Here's my model: > > > class Contact(models.Model): > > requesting_user = models.ForeignKey(User, > > related_name='contacts_has_requested') > > requested_user = models.ForeignKey(User, > > related_name='contacts_was_requested') > > is_blocked = models.BooleanField(default=False) > > > Now the test code: > > > q1 = Q(contacts_was_requested__is_blocked=False, > > contacts_was_requested__requesting_user=self) > > p1=User.objects.filter(q1) > > => returns: QuerySet: [] > > > q2 = Q(contacts_has_requested__is_blocked=False, > > contacts_has_requested__requested_user=self) > > p2=User.objects.filter(q2) > > => returns: QuerySet: [<User: user_5>] > > > p3=User.objects.filter(q1 | q2) > > => returns: QuerySet: [] > > > Shouldn't the '|' sign do a union of the two intermediary querysets? > > > Am I missing something? > > > Thanks a lot, > > > Julien > > > [1]http://groups.google.com/group/django-users/browse_thread/thread/a467... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
