#26658: "When Case" query generating rule in duplicate
----------------------------------------------+--------------------
     Reporter:  imaia                         |      Owner:  nobody
         Type:  Bug                           |     Status:  new
    Component:  Database layer (models, ORM)  |    Version:  1.9
     Severity:  Normal                        |   Keywords:
 Triage Stage:  Unreviewed                    |  Has patch:  0
Easy pickings:  0                             |      UI/UX:  0
----------------------------------------------+--------------------
 I have a query that looks like this:

 Model.objects.values('field').annotate(value=When(Case(something=number,
 then=1), default=0,
 output_field=IntegerField())).annotate(count=Count('field'),
 mysum=Sum('value'))

 The query above generates the "When Case" clause twice. Once for value and
 another time at the end of the query. That can be verified evaluating the
 '''str(queryset.query)'''.

--
Ticket URL: <https://code.djangoproject.com/ticket/26658>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/048.dfe90db0f09674b16d7dd521ecc95afd%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to