Foreign key corruption: foreign key has entered an invalid state

[zachmu]

It's possible for foreign keys in Dolt to become corrupted through certain schema changes, exact mechanism unclear at this point. The symptom is that a call to dolt_commit() fails with a message like this:

Failed to commit changes.
cause: foreign key `paperinfo02_ibfk_1` has entered an invalid state, table `paperinfo02` is missing the index `pinc2`

The workaround is to drop and recreate the foreign key with the same definition.

alter table paperinfo02 drop constraint `paperinfo02_ibfk_1`;
alter table paperinfo02 add constraint `paperinfo02_ibfk_1` FOREIGN KEY (`id_coderinfo`) REFERENCES `coderinfo02` (`id_coderinfo`);

If you encounter this bug and can reproduce it, please comment to let us know.