id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
16058	Values_list with distinct return duplicate values	jonasnockert	nobody	"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!"	Bug	closed	Database layer (models, ORM)	1.3	Normal	invalid			Unreviewed	0	0	0	0	0	0