Opened 13 years ago

Closed 13 years ago

Last modified 13 years ago

#18324 closed Bug (worksforme)

QuerySet values ​​method fails — at Version 2

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
Pull Requests:How to create a pull request

Description (last modified by Luke Plant) 

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 (2)

comment:1 by Anssi Kääriäinen, 13 years ago

Resolution: → worksforme
Status: new → closed

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

SELECT "some_model"."field1" FROM "some_model" ORDER BY "some_model"."field1" ASC

which looks correct to me.

comment:2 by Luke Plant, 13 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.
Back to Top