Bug #112737 | Conditions refering to const table were not added to RANGE SCAN | ||
---|---|---|---|
Submitted: | 16 Oct 2023 9:07 | Modified: | 16 Oct 2023 9:31 |
Reporter: | Xingyu Yang (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S5 (Performance) |
Version: | 8.0, 8.0.34 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Contribution |
[16 Oct 2023 9:07]
Xingyu Yang
[16 Oct 2023 9:23]
Xingyu Yang
The const table map was obtained through qep_tab in test_quick_select(). But bug #32976857 removed the qep_tab in test_quick_select(), and did not pass the const table map to test_quick_select(). Here is the commit message of Bug #32976857 Bug #32976857: REMOVE QEP_TAB_STANDALONE [range optimizer, noclose] ``` Remove the QEP_TAB dependency from test_quick_select() (ie., the range optimizer). Change-Id: Ie0fcce71dfc813920711c43c3d62635dae0d7d20 ```
[16 Oct 2023 9:31]
MySQL Verification Team
Hello Xingyu Yang, Thank you for the report and contribution. Please ensure to upload patch via "Contribution" tab. Thank you. regards, Umesh
[16 Oct 2023 9:33]
Xingyu Yang
bugfix based on version 8.0.30 (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Contribution: 0001-bugfix-issue-594-Index-conditions-referencing-the-co.patch (application/octet-stream, text), 17.87 KiB.
[23 Apr 16:11]
Marc Reilly
Hi Umesh, Any chance the contribution to fix this regression could get merged in the next minor? It is still affecting the latest minor on 8.0. There is also a detailed write up on it here: https://github.com/enhancedformysql/blogs/blob/main/performance_degradation.md Thanks, Marc