Inconsistent sorting behavior in mult-table inheritance query for different database backends

[George Song]

Given the following models:

from django.db import models

class A(models.Model):
    name = models.CharField(max_length=50)

class B(A):
   pass

class C(A):
   pass

The following query returns different queryset order for sqlite3 vs. postgresql_psycopg2:

A.objects.order_by('b', 'name')

SQLite will sort B objects, followed by C objects. PostgreSQL will sort C objects, followed by B objects.

[Alex Gaynor]

This looks to be a DB level inconsistency, not something Django can control. Unless there's something I'm missing closing as wontfix.