[Django] #36092: Composite primary key creates invalid migration when one of its fields is inherited

[Django]

#36092: Composite primary key creates invalid migration when one of its fields is
inherited
-------------------------------------+-------------------------------------
Reporter: Jacob Walls | Type: Bug
Status: new | Component: Database
| layer (models, ORM)
Version: dev | Severity: Release
| blocker
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
(As ever, let me know if this is a known/deferred issue--just trying to
report anything I noticed while taking a look around.)
----
With these models:

{{{#!py
class CoffeeProduct(models.Model):
whole_bean = models.BooleanField()


class SpecialtyCoffeeProduct(CoffeeProduct):
pk = models.CompositePrimaryKey("whole_bean", "varietal")
varietal = models.CharField()
}}}

This migration is generated on sqlite:
{{{#!sql
BEGIN;
--
-- Create model CoffeeProduct
--
CREATE TABLE "appName_coffeeproduct" ("id" integer NOT NULL PRIMARY KEY
AUTOINCREMENT, "whole_bean" bool NOT NULL);
--
-- Create model SpecialtyCoffeeProduct
--
CREATE TABLE "appName_specialtycoffeeproduct" ("coffeeproduct_ptr_id"
bigint NOT NULL UNIQUE REFERENCES "appName_coffeeproduct" ("id")
DEFERRABLE INITIALLY DEFERRED, "varietal" varchar NOT NULL, PRIMARY KEY
("whole_bean", "varietal"));
COMMIT;
}}}

And fails when executed:
{{{
File "/Users/<user>/django/django/db/backends/sqlite3/base.py", line
356, in execute
return super().execute(query)
^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.OperationalError: expressions prohibited in PRIMARY KEY
and UNIQUE constraints
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/36092>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.