Bug #83257 Adding unique index check for schema_unused_indexes (contribution)
Submitted: 4 Oct 2016 21:11 Modified: 10 Jul 2019 23:54
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: SYS Schema Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[4 Oct 2016 21:11] OCA Admin 
Description:
This bug tracks a contribution by Gillian Gunson (Github user: ggunson) as described in http://github.com/mysql/mysql-sys/pull/108

How to repeat:
See description

Suggested fix:
See contribution code attached
[4 Oct 2016 21:11] OCA Admin 
Contribution submitted via Github - Adding unique index check for schema_unused_indexes 
(*) Contribution by Gillian Gunson (Github ggunson, mysql-sys/pull/108#issuecomment-251504265): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_83878954.txt (text/plain), 1.72 KiB.
[5 Oct 2016 4:17] MySQL Verification Team 
Hello Gillian,

Thank you for the report and contribution.

Thanks,
Umesh
[10 Jul 2019 23:54] Paul DuBois 
Posted by developer:
 
Fixed in 5.7.28.

The sys.schema_unused_indexes view now filters out unique indexes.
Thanks to Gillian Gunson for the contribution.