Wrong annotation when used with QuerySet.order_by()

[Rafael Capucho]

Related to old closed ticket: https://code.djangoproject.com/ticket/25316

# Models

class Application(models.Model):
    package_name = models.CharField(max_length=128, null=False, blank=True)
    package_version_code = models.IntegerField(blank=True)
    package_version_name = models.CharField(max_length=64, null=False, blank=True)
    label = models.CharField(max_length=64, null=False, blank=True)

    class Meta:
        ordering = ['label', 'package_version_code']

class Profile(models.Model):
    applications = models.ManyToManyField(
        'applications.Application',
        related_name='application_%(class)s',
        blank=True
    )

class Device(models.Model):
   profile = models.ForeignKey(
        Profile,
        related_name='devices',
        blank=True,
        null=True
    )

The error is:

[Tim Graham]

Could you add a tests.py file that demonstrates the issue (and/or replace the screenshot in the description)? The screenshot isn't particularly friendly for someone trying to reproduce this since they have to retype everything.

Did you read the ​aggregation topic guide to ensure that none of the documented issues there are the cause of the behavior?

[Tomer Chachamu]

It looks like this section explains the behaviour: ​https://docs.djangoproject.com/en/1.11/topics/db/aggregation/#interaction-with-default-ordering-or-order-by

Maybe you want to use .annotate(...).order_by('label', 'latest') instead?

[Tomer Chachamu]

Also, if you can provide the output that you expected for each of the queries, that would help us understand the issue :) you can set the status to "new" again if you think there is an issue still.