Bug #119063 Unused variable 'fk_max_recusive_level'

• Submitted: 24 Sep 2025 3:45
• Modified: 15 Jan 16:53
• Reporter: Xiaocong Ding (OCA)
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.43
• OS: Any
• CPU Architecture: Any
• Tags: foreign key

[24 Sep 2025 3:45] Xiaocong Ding

Description:
As mentioned in the title, the variable fk_max_recusive_level is only assigned a value of 0 and has not participated in any conditional judgment, and it can be removed directly.

How to repeat:
This is a code suggestion.

Suggested fix:
Remove the variable 'fk_max_recusive_level'.

[24 Sep 2025 4:14] Xiaocong Ding

Besides, the variable 'check_recursive' is also unused, which can be removed.

[24 Sep 2025 6:19] Xiaocong Ding

Here is my patch fixing this problem.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: fix.patch (application/octet-stream, text), 3.48 KiB.

[29 Sep 2025 13:07] MySQL Verification Team

Thank you for your contribution.

[15 Jan 16:53] Edward Gilmore

Posted by developer:
 
Added the following note to the MySQL Server 9.6.0 release notes:
		
The field fk_max_recusive_level in dict_table_t struct is no longer used and has been removed.
Our thanks to Xiaocong Ding for the contribution.