Bug #84361 Incorrect SHOW ENGINE INNODB STATUS for partitioned table

• Submitted: 28 Dec 2016 16:18
• Modified: 29 Dec 2016 6:51
• Reporter: Василий Лукьянчиков
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.6, 5.6.35, 5.7.17
• OS: Any
• CPU Architecture: Any

[28 Dec 2016 16:18] Василий Лукьянчиков

Description:
If we are trying to split the parent table on sections, the error message in "SHOW ENGINE INNODB STATUS" not content section " LATEST FOREIGN KEY ERROR".

How to repeat:
create table t1 (a int, index(a)) engine=innodb;

create table t2 (a int, foreign key (a) references t1(a)) engine=innodb;

alter table t1 PARTITION BY HASH(a) PARTITIONS 8;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

show engine innodb status;

[29 Dec 2016 6:51] MySQL Verification Team

Hello!

Thank you for the report.
Verified as described with 5.6.35.

Thanks,
Umesh