Re: [Django] #28705: Wrong annotation when used with QuerySet.order_by()

[Django]

#28705: Wrong annotation when used with QuerySet.order_by()
-+-
 Reporter:  Rafael Capucho   |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  1.11
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  needsinfo
 Keywords:  Annotate, ORM,   | Triage Stage:
  Order_by   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Tomer Chachamu):

 * status:  new => closed
 * resolution:   => needsinfo


Comment:

 Also, if you can provide the output that you expected for each of the
 queries, that would help us understand the issue :)

-- 
Ticket URL: 
Django 
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/071.8c44cbbecdd48922a08356754ffc6ae4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #28705: Wrong annotation when used with QuerySet.order_by()

[Django]

#28705: Wrong annotation when used with QuerySet.order_by()
-+-
 Reporter:  Rafael Capucho   |Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.11
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  Annotate, ORM,   | Triage Stage:
  Order_by   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Tomer Chachamu):

 It looks like this section explains the behaviour:
 https://docs.djangoproject.com/en/1.11/topics/db/aggregation/#interaction-
 with-default-ordering-or-order-by

 Maybe you want to use `.annotate(...).order_by('label', 'latest')`
 instead?

-- 
Ticket URL: 
Django 
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/071.06af4343a714d6c3d32da65cec6c52c6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #28705: Wrong annotation when used with QuerySet.order_by() (was: Wrong annotation when used with order_by)

[Django]

#28705: Wrong annotation when used with QuerySet.order_by()
-+-
 Reporter:  Rafael Capucho   |Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.11
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  Annotate, ORM,   | Triage Stage:
  Order_by   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Tim Graham):

 * component:  Uncategorized => Database layer (models, ORM)


Comment:

 Could you add a `tests.py` file that demonstrates the issue (and/or
 replace the screenshot in the description)? The screenshot isn't
 particularly friendly for someone trying to reproduce this since they have
 to retype everything.

 Did you read the
 [https://docs.djangoproject.com/en/dev/topics/db/aggregation
 /#aggregations-and-other-queryset-clauses aggregation topic guide] to
 ensure that none of the documented issues there are the cause of the
 behavior?

-- 
Ticket URL: 
Django 
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/071.7e35de0d975fb5da0f55fa3189164ca4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.