Mutations in My SQL fail when sql_require_primary_key = 1 in set in the DB

[pari-m]

Is your proposal related to a problem?

MySQL doesn't return data in mutations so Hasura creates temporary tables so Hasura can retain and select the data after a mutation. These tables don't have a primary key which is causing the following error on the MySQL server.

Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key'

Describe the solution you'd like

Hasura to use primary keys in temporary tables

Describe alternatives you've considered

The following variable can be set in MySQL

SET sql_require_primary_key = 0;