Why was the ability to reference part of a composite key as a foreign key removed in MySQL 8.4.0?
In MySQL versions prior to 8.4.0, it was possible to create foreign keys that referenced only part of a composite key. Starting from MySQL 8.4.0, this functionality was restricted by default through the restrict_fk_on_non_standard_key system variable. This change has caused issues in my existing database schema.