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

Semi-join optimization for single-table update/delete statements

Details

    Description

      Currently, single-table UPDATE/DELETE statements cannot take advantage of semi-join optimizations. This is because semi-join optimizations are parts of join optimization (which is not invoked for single-table UPDATE/DELETE).

      This task is about

      • detecting UPDATE/DELETEs that can use semi-join optimizations
      • switching those queries to be processed as multi-table UPDATE/DELETEs. This will enable semi-join optimizations.

      Note that we do similar things for VIEWs: UPDATE multi_table_view SET =... is switched to be processed as multi-table UPDATE as soon as the server discovers that we're updating a multi-table VIEW.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33533 Crash at execution of DELETE when trying to use rowid filter

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34113 Spider XA: ERROR 1440 (XAE08): XAER_DUPID: The XID already exists

          • Major - Major loss of function.
          • Confirmed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15385 Full scan instead of index lookup on single table DELETE ... WHERE IN (SELECT ...)

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15385 Full scan instead of index lookup on single table DELETE ... WHERE IN (SELECT ...)

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-29547 prepare 10.11.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22415 Single table UPDATE/DELETE doesn't use non-semijoin Materialization

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10447 different execution plan for single- and multi-DELETE

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14956 Slow deletes if number of deleted rows smaller then LIMIT

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18561 Semi-Join optimization for single-table update

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Igor Babaev (Inactive) made transition -
            Open In Progress
            		2693d 14h 26m 1
            Igor Babaev (Inactive) made transition -
            In Progress In Review
            		13d 1h 16m 1
            Oleksandr Byelkin made transition -
            In Review Stalled
            		9h 13m 1
            Igor Babaev (Inactive) made transition -
            Stalled In Progress
            		15h 58m 1
            Igor Babaev (Inactive) made transition -
            In Progress In Testing
            		97d 9h 48m 1
            Lena Startseva made transition -
            In Testing Stalled
            		141d 1h 50m 1
            Igor Babaev (Inactive) made transition -
            Stalled Closed
            		30d 2h 1m 1

            People

              igor Igor Babaev (Inactive)
              psergei Sergei Petrunia
              Votes:
              5 Vote for this issue
              Watchers:
              15 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.