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

Add Spider server variable for disabling GROUP BY handler

    XMLWordPrintable

Details

    Description

      Add a server variable, to the Spider storage engine, that enables/disables the use of GROUP BY handler. This provides users with a unified workaround for the bugs like MDEV-26013. In the Spider docs, an execution is called "direct" if it uses GROUP BY handler (e.g., direct aggregation, direct join, ...). So, the parameter name would be spider_direct_execution spider_enable_direct_select. Or, simply naming spider_enable_group_by_handler would be OK.

      The default value of the variable should be 1 (i.e., use GROUP BY handler) for compatibility.

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-32238 Add a switch to disable spider group by handler

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-26361 Spider: Use GROUP BY handler only when necessary and safe

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

          Task - A task that needs to be done. MDEV-26369 Add Spider status variable to count usage of GROUP BY handler

          • Major - Major loss of function.
          • Open

          Activity

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.