Raw query map problem with some primary keys

[Reflejo@…]

Hello,

I'm trying the new raw query feature and i'm facing this bug:

When my model has primary_key set to some ForeignKey and I try to invoke the raw() method, InvalidQuery('Raw query must include the primary key') is raised.

class ExampleModel(models.Model):
    some = models.ForeignKey(SomeOther, primary_key=True)

    class Meta:
        db_table = 'example_model'


ExampleModel.objects.raw("SELECT some_id FROM example_model")

The problem arise because get_attname_column gives (some_id, some_id) as name/column but then it is compared to _meta.pk.attname (some) here:

        if skip:
            if self.model._meta.pk.attname in skip:
                raise InvalidQuery('Raw query must include the primary key')

[Alex Gaynor]

This is a dupe of another ticket (that one is labeled as being about model inheritance, but it's really about anyone where attname != name).

[sklass@…]

I appreciate this is a dupe - can you please point us to the ticket#?

Thanks

[Matt Johnson]

This is broken again in 1.8. Looks like 0b6f05ede648ce62a5c91c7c38a0a362711f0656 caused the regression.

Here's my attempt at a patch: ​https://github.com/django/django/pull/5036

[Tim Graham <timograham@…>]

In e063ac2:

Fixed #12768 -- Fixed QuerySet.raw() regression on FK with custom db_column.

[Tim Graham <timograham@…>]

In 05c7129b:

[1.8.x] Fixed #12768 -- Fixed QuerySet.raw() regression on FK with custom db_column.

Backport of e063ac2fae007a2eecaeab5ce17064c31230ce29 from master