Wrong column name in SQL ORDER BY statement

[Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>]

When I have models like this:

class Foo(models.Model):
   a = models.SlugField('a')
   class Admin:
     pass

class Bar(models.Model):
   a = models.SlugField('a')
   class Admin:
     pass

class Baz(models.Model):
   parent = models.OneToOneField(Foo)
   bar = models.ForeignKey(Bar)
   class Admin:
     pass

Any attempt to access Baz model thru admin interface fails with OperationalError at <address> no such column: <app>_foo.id and generated SQL looks like this:

SELECT "<app>_baz"."parent_id","<app>_baz"."bar_id" FROM "<app>_baz" ORDER BY "<app>_foo"."id" ASC

I think that correct SQL is more like this:

SELECT "<app>_baz"."parent_id","<app>_baz"."bar_id" FROM "<app>_baz" ORDER BY "<app>_baz"."foo_id" ASC

Current workaround is that I must declare model like this:

class Baz(models.Model):
   parent = models.OneToOneField(Foo)
   bar = models.ForeignKey(Bar)
   class Meta:
       ordering = ['?']
   class Admin:
     pass

Note ? for forcing no ordering.

If I have time I'll lookup into source to find what's going on (and hopefully submit a patch), or I'm simply doing something wrong here?

[Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>]

I forgot to mention that I'm using SQLite database.

[Nebojsa Djordjevic <nesh at studioquattro dot co dot yu>]

Also a ordering = ['parent_id'] works (with validate complaining about missing column ;) )

[jkocherhans]

Duplicate of #1245