Bug #84361 Incorrect SHOW ENGINE INNODB STATUS for partitioned table

Submitted: 28 Dec 2016 16:18 Modified: 29 Dec 2016 6:51
Reporter: Василий Лукьянчиков Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6, 5.6.35, 5.7.17 OS:Any
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.