Bug #96666 Remove handler::get_parent/foreign_key_list() usage
Submitted: 27 Aug 2019 9:39 Modified: 16 Sep 2019 16:06
Reporter: Dmitry Lenev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Storage Engine API Severity:S3 (Non-critical)
Version:8.0.18-git OS:Any
Assigned to: CPU Architecture:Any

[27 Aug 2019 9:39] Dmitry Lenev 
Description:
In MySQL 8.0 all information about foreign keys is available from the
new data-dictionary, corresponding DD API and sometimes from TABLE_SHARE.

However, SQL-layer code still uses SE API to get some of this information
which results in code duplication at very least.

Specifically handler::get_parent_foreign_key_list() and get_foreign_key_list()
methods are used to get information about foreign keys involving columns
being ALTERed even though the same information is available from DD API.

This SE API should be removed and code using it should be updated to use
DD API instead.

How to repeat:
Inspect sql/sql_table.cc
[16 Sep 2019 16:06] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.19.

Code cleanup. No changelog entry required.