#18324 closed Bug (worksforme)
QuerySet values method fails
Reported by: | anonymous | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 1.4 |
Severity: | Normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description (last modified by )
class SomeModel(models.Model): field1 = models.CharField(max_length=100, blank=True, null=True, default='') field2 = models.CharField(max_length=100, blank=True, null=True, default='') field3 = models.CharField(max_length=100, blank=True, null=True, default='') class Meta: db_table = 'some_model' ordering = ['field1'] # Caused by this line
# # SomeModel.objects.values('field1') # sql: select field1, field2, field3, from some_model #
Change History (3)
comment:1 by , 12 years ago
Resolution: | → worksforme |
---|---|
Status: | new → closed |
comment:2 by , 12 years ago
Description: | modified (diff) |
---|
comment:3 by , 12 years ago
Replying to anonymous:
class SomeModel(models.Model): field1 = models.CharField(max_length=100, blank=True, null=True, default='') field2 = models.CharField(max_length=100, blank=True, null=True, default='') field3 = models.CharField(max_length=100, blank=True, null=True, default='') sequence = models.IntegerField(default=0) class Meta: db_table = 'some_model' ordering = ['field1', 'sequence'] # Caused by this line# # SomeModel.objects.values('field1').distinct() # sql: SELECT DISTINCT "some_model"."field1", "some_model"."sequence" FROM "some_model" ORDER BY "some_model"."field1" ASC, "some_model"."sequence" ASC #
Note:
See TracTickets
for help on using tickets.
I can't reproduce this on 1.4. This is the used test case:
https://github.com/akaariai/django/commit/fa76c9ee0d9847ea357b8b1be7f3c786255713f5
And here is the generated SQL
which looks correct to me.