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

Implement and evaluate select handler for Spider

    XMLWordPrintable

Details

    • Q4/2025 Server Maintenance

    Description

      Spider's GROUP BY handler (GBH) implementation is one of the prominent sources of the Spider bugs. Implement the select handler for Spider and evaluate if we can replace the existing GBH with the select handler.

      The select handler intercepts the query processing much earlier than GBH. I expect that this makes it easier for Spider to generate queries for data nodes.

      Related documents:

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-37818 Spider select handler V2

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-37819 Spider: change default from group by handler (gbh) to select handler (sh)

          • Major - Major loss of function.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37410 XAER_OUTSIDE in bb-main-mdev-27260

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

          Task - A task that needs to be done. MDEV-37110 Spider select handler: implement one that handles testcases showcasing problems with the gbh

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

          Task - A task that needs to be done. MDEV-37111 Spider select handler: implement one that handles all existing spider testcases

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

          Task - A task that needs to be done. MDEV-37113 Spider select handler: clean up relevant existing spider code

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

          Task - A task that needs to be done. MDEV-37114 Spider select handler: PoC and initial planning

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

          Task - A task that needs to be done. MDEV-37202 spider select handler: interim planning, design and implementation improvement

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

          Task - A task that needs to be done. MDEV-37291 Some remaining tasks for spider select handler V1 implementation

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

          Task - A task that needs to be done. MDEV-37810 Introduce combinations of gbh and usual handlers to spider tests

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20250 Implement early partition pruning before statement start

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32273 Research/Design: Broken queries are passed to the group by handler for execution

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

          Task - A task that needs to be done. MDEV-37112 Spider select handler: implement derived handler

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              serg Sergei Golubchik
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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