#16058: Values_list with distinct return duplicate values
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
jonasnockert | Status: closed
Type: Bug | Component: Database layer
Milestone: | (models, ORM)
Version: 1.3 | Severity: Normal
Resolution: invalid | Keywords:
Triage Stage: | Has patch: 0
Unreviewed | Needs tests: 0
Needs documentation: 0 | Easy pickings: 0
Patch needs improvement: 0 |
-------------------------------------+-------------------------------------
Changes (by ramiro):
* status: new => closed
* needs_docs: => 0
* resolution: => invalid
* needs_tests: => 0
* needs_better_patch: => 0
Comment:
I suspect is is because the (default, implicit) ordering Article model
queries have and/or the `unique_together` condition. You are seeing
duplicate results because '.ditinct()` is acting on all the columns
included in the low level SQL query.
Take a look at:
* The note in the
[http://docs.djangoproject.com/en/1.3/ref/models/querysets/#django.db.models.query.QuerySet.distinct
distinct()] method and
* the suggestion in the last paragraph of the
[http://docs.djangoproject.com/en/1.3/ref/models/querysets/#django.db.models.query.QuerySet.values
values()] method (using `.unique().values_list(...)` if possible)
--
Ticket URL: <https://code.djangoproject.com/ticket/16058#comment:1>
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 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.
