[MDEV-13185] Pull conditions out of materialized subqueries Created: 2017-06-27 Updated: 2018-01-09 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Igor Babaev | Assignee: | Igor Babaev |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
If the optimizer chooses to materialize a subquery then in many cases it makes sense to clone the subquery conditions that can be transformed into conditions for outer tables and to add the result of the transformation to the WHERE condition of the main query. |