Re: [Django] #16058: Values_list with distinct return duplicate values

[Django]

#16058: Values_list with distinct return duplicate values
-+-
 Reporter:  jonasnockert |Owner:  nobody
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  1.3
  (models, ORM)  |   Resolution:  invalid
 Severity:  Normal   | Triage Stage:
 Keywords:   |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Pavel White ):

 You can use .sorted_by() for clear sorted meta oredering.[[BR]]

 Ex:
 {{{#!python
 >>>
 
Article.objects.filter(product_number=99668).sorted_by().values_list('product_number',
 flat=True).distinct()
 [99668]
 }}}

-- 
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 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.

Re: [Django] #16058: Values_list with distinct return duplicate values

[Django]

#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: 
Django 
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.

[Django] #16058: Values_list with distinct return duplicate values

[Django]

#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: 
Django 
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.