Bug #100024 | optimizer switch use_invisible_indexes=on does not allow FORCE INDEX | ||
---|---|---|---|
Submitted: | 28 Jun 2020 16:57 | Modified: | 11 Aug 2020 20:22 |
Reporter: | Morgan Tocker | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 8.0.20 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[28 Jun 2020 16:57]
Morgan Tocker
[29 Jun 2020 5:27]
MySQL Verification Team
Hello Morgan, Thank you for the report and feedback. regards, Umesh
[11 Aug 2020 20:22]
Jon Stephens
Documented fix as follows in the MySQL 8.0.22 changelog: In some cases, the server issued an error when an invisible index was used in an index hint even when the use_invisible_indexes optimizer switch was not set to OFF. Closed.