Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Have there been there any improvements in error reporting when foreign keys fail? Does MySQL now report which column and reference failed?

April 26, 2017column Error fail foreign improvements keys MySQL Reference report

0

Posted

Have there been there any improvements in error reporting when foreign keys fail? Does MySQL now report which column and reference failed?

2 Answers

0

Posted

The foreign key support in InnoDB has seen improvements in each major version of MySQL. Foreign key support generic to all storage engines is scheduled for MySQL 6.x; this should resolve any inadequacies in the current storage engine specific implementation.

0

Posted

The foreign key support in InnoDB has seen improvements in each major version of MySQL. Foreign key support generic to all storage engines is scheduled for MySQL 5.2; this should resolve any inadequacies in the current storage engine specific implementation.