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

Lots of joins can crash the server

    XMLWordPrintable

Details

    • Can result in hang or crash
    • A large number of joins in a SELECT can crash the server
    • Q1/2026 Server Maintenance

    Description

      Queries like

      SELECT * FROM t1 JOIN t1 x0 ON t1
                       JOIN t1 x1 ON t1
                       JOIN t1 x2 ON t1
                       ...
                       JOIN t1 x14000 ON t1
      

      might get out of stack when recursively invoking JOIN::free_pushdown_handlers().

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.