#30518: Multiple Count annotation with filter doesn't work properly (at least if
related modelas has same named fileds)
-------------------------------------+-------------------------------------
Reporter: farin | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: 2.2
layer (models, ORM) |
Severity: Normal | Keywords: annotate
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Lets have following models
{{{
class User(models.Model):
pass
class Subscription(models.Model):
user = models.ForeignKey(User, models.CASCADE)
valid_to = models.DateTimeField()
class SubscriptionToAuthor(models.Model):
user = models.ForeignKey(User, models.CASCADE)
valid_to = models.DateTimeField()
}}}
then annotate on only one related model works fine
{{{
# this is ok
User.objects.annotate(
subscribed_authors=Count('subscriptiontoauthor',
filter=Q(subscriptiontoauthor__valid_to__gt=now))
)
}}}
or
{{{
# this is ok
User.objects.annotate(
subscribed_newspapers=Count('subscription',
filter=Q(subscription__valid_to__gt=now))
)
}}}
but Count returns incorrect (too big) count numbers when both annotations
are used on single query set
{{{
# wrong result
User.objects.annotate(
subscribed_authors=Count('subscriptiontoauthor',
filter=Q(subscriptiontoauthor__valid_to__gt=now))
).annotate(
subscribed_newspapers=Count('subscription',
filter=Q(subscription__valid_to__gt=now))
)
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30518>
Django <https://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 unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/048.ecf7791756af17a0a65773c7a68b950b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
