semijoin does not take into account materialization and in_to_exists optimizer_switches

Bug #889751 reported by Philip Stoev on 2011-11-13
8
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)
Timour Katchaounov (timour) wrote :

Semijoin does not take into account materialization and in_to_exists
optimizer_switches when reverting to one of these strategies.

summary: - semijoin does not observe optimizer_switches in certain cases
+ semijoin does not take into account materialization and in_to_exists
+ optimizer_switches
Michael Widenius (monty) on 2012-03-21
Changed in maria:
milestone: 5.3 → 5.5
importance: Undecided → Low
status: New → Confirmed
importance: Low → Medium
assignee: Sergey Petrunia (sergefp) → Timour Katchaounov (timour)
Elena Stepanova (elenst) wrote :

Also filed in JIRA as MDEV-198

Elena Stepanova (elenst) on 2012-03-29
tags: added: optimizer
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers