Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-651

LP:889751 - semijoin does not take into account materialization and in_to_exists optimizer_switches

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.5.28a
        • Fix Version/s: 5.5
        • Component/s: None
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                duplicates

                Bug - A problem which impairs or prevents the functions of the product. MDEV-198 LP:889751 - semijoin does not take into account materialization and in_to_exists optimizer_switches

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  timour Timour Katchaounov added a comment -

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

                  Show
                  timour Timour Katchaounov added a comment - Re: semijoin does not take into account materialization and in_to_exists optimizer_switches Semijoin does not take into account materialization and in_to_exists optimizer_switches when reverting to one of these strategies.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Re: semijoin does not take into account materialization and in_to_exists optimizer_switches
                  Also filed in JIRA as MDEV-198

                  Show
                  elenst Elena Stepanova added a comment - Re: semijoin does not take into account materialization and in_to_exists optimizer_switches Also filed in JIRA as MDEV-198
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 889751

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 889751

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      philipstoev Philip Stoev
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      0 Start watching this issue

                      Dates

                      • Created:
                        Updated: