MYSQL READ-COMMITTED For this to work correctly, all tables must have a primary key.

This seems bizarre. Not every table necessarily needs a pkey. Arguably there should be some indexes of some kind, but thats not really the issue here.

Theres something else at work here.

If core doesnt enforce it, then I'm not really concerned.

If you want to opt into this, then its up to you to deal with the consequences, or add opt outs or whatever other configuration available to you.

Also, please read issue posting guidelines.

Maybe 🐛 READ COMMITTED requirement check doesn't account for database views Needs work via Slack.

I'm guessing we need to create a PK from entity_id, optionally revision_id, field_delta and delta

Going to merge this into ✨ Add primary key to occurrence tables Needs work