[MDEV-20468] Allocating more space than required for JOIN_TAB array for a query with SJM table Created: 2019-09-02 Updated: 2023-12-20 Resolved: 2019-09-25 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.1, 10.2, 10.3, 10.4, 10.5 |
| Fix Version/s: | 10.5.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Varun Gupta (Inactive) | Assignee: | Varun Gupta (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||
| Description |
|
An example
this case uses Semi Join Materializaion and the subquery is added to the table list of select #1. In the function JOIN::get_best_combination
In the debugger So in this issue we would like to correct the value of top_join_tab_count, to only consider the tables that would be present at the top level. In this case |
| Comments |
| Comment by Varun Gupta (Inactive) [ 2019-09-02 ] |
|
Patch: This patch also fixes the crash in |
| Comment by Sergei Petrunia [ 2019-09-19 ] |
|
Ok to push |