semijoin does not take into account materialization and in_to_exists optimizer_switches
Bug #889751 reported by
Philip Stoev
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
Confirmed
|
Medium
|
Timour Katchaounov | ||
Bug Description
Timour reported that a certain semijoin code path does not observe the value of optimizer_switch . I assume he can provide more detail, I am filing this bug for tracking purposes.
| Changed in maria: | |
| milestone: | none → 5.3 |
| assignee: | nobody → Sergey Petrunia (sergefp) |
Revision history for this message
| Timour Katchaounov (timour) wrote | #1 |
| summary: |
- semijoin does not observe optimizer_switches in certain cases + semijoin does not take into account materialization and in_to_exists + optimizer_switches |
| Changed in maria: | |
| milestone: | 5.3 → 5.5 |
| importance: | Undecided → Low |
| status: | New → Confirmed |
| importance: | Low → Medium |
| assignee: | Sergey Petrunia (sergefp) → Timour Katchaounov (timour) |
Revision history for this message
| Elena Stepanova (elenst) wrote | #2 |
| tags: | added: optimizer |
To post a comment you must log in.
Semijoin does not take into account materialization and in_to_exists
optimizer_switches when reverting to one of these strategies.