Raw queries with Oracle impossible when using uppercase column names

[Dmitry Shachnev]

When one has a model with a custom column name in uppercase, say:

class Man(Model):
    id = models.AutoField(primary_key=True, db_column="F_MAN_ID")

Then it is impossible to use RawQuerySets with this model on Oracle, you will always get the “InvalidQuery: Raw query must include the primary key” error.

The problem is that column_name_converter() converts the column names to lowercase, so even if you use F_MAN_ID in your query, the self.columns list in the RawQuerySet instance will contain the lowercase column name. And because of case differences the f.column in self.columns check in resolve_model_init_order method will return False.

We are currently using Django 1.8 in production, but I looked at the Django code and it’s the same between 1.8 and 1.11, so I have put 1.11 into the Version field.

[Mariusz Felisiak]

Test

[Mariusz Felisiak]

​PR

[GitHub <noreply@…>]

In 99df304:

Fixed #28206 -- Fixed RawQuerySet crash on a model with a mixed case db_column pk on Oracle.

Thanks Tim Graham for the review.