#16058: Values_list with distinct return duplicate values
--------------------------+----------------------------------------------
Reporter: jonasnockert | Owner: nobody
Type: Bug | Status: new
Milestone: | Component: Database layer (models, ORM)
Version: 1.3 | Severity: Normal
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Easy pickings: 0
--------------------------+----------------------------------------------
I'm using Django 1.3 with the following model (and as far as I can tell
the generated sqlite3 schema looks okay as well):
{{{
class Article(Model):
product_number = PositiveIntegerField(_("Product number"),
db_index=True)
product_variant = PositiveIntegerField(_("Variant"), db_index=True)
...
class Meta:
unique_together = (('product_number', 'product_variant'),)
ordering = ['-date_added']
}}}
I'm making the following query which returns duplicate results:
{{{
>>>
Article.objects.filter(product_number=99668).values_list('product_number',
flat=True).distinct()
[99668, 99668]
}}}
It looks like a bug from here but I'm also a bit sceptical since other
people seem to be using this query construct successfully.
Thanks!
--
Ticket URL: <https://code.djangoproject.com/ticket/16058>
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.
