Bug #118058 optimize for check_promoted_index
Submitted: 25 Apr 9:48 Modified: 25 Apr 13:04
Reporter: alex xing (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S5 (Performance)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Apr 9:48] alex xing 
Description:
In the scenario of altering an invisible index, if the change involves a unique key, there is no need to maintain `has_unique_key`.
It is recommended to move the logic for maintaining `has_unique_key` to a later stage to reduce unnecessary overhead.

How to repeat:
just read the code

Suggested fix:
just as the below patch
[25 Apr 9:49] alex xing 
a simple patch to describe the optimization

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

Contribution: check_promoted_index_optimize.patch (application/octet-stream, text), 714 bytes.
[25 Apr 13:04] MySQL Verification Team 
Hello Alex xing,

Thank you for the report and contribution.
I think this is same as your previous one i.e. Bug #118057
For now marking it as a duplicate of Bug #118057, if you have any objections then please do let us know.

Sincerely,
Umesh