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

Implement multiple-table UPDATE/DELETE returning a result set

    XMLWordPrintable

Details

    Description

      A multiple-table UPDATE first performs join operations, then it updates the matching rows.
      A multiple-table UPDATE returning a result set does the following:

      • first performs join operations
      • for each row of the result of the join it calculates some expressions over the columns of the join and forms from them a row of the returned result set
      • after this it updates the matching rows

      A multiple-table DELETE first performs join operations, then it deletes the matching rows.
      A multiple-table DELETE returning a result set does the following:

      • first performs join operations
      • for each row of the result of the join it calculates some expressions over the columns of the join and forms from them a row of the returned result set
      • after this it deletes the matching rows

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-10448 DELETE ... RETURNING support for multi-table deteles

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-5092 Implement UPDATE with result set

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-5092 Implement UPDATE with result set

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19093 [Feature] Issue #48 SELECT...FROM UPDATE

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-20033 sql_mode="oracle" does not support INSERT INTO ... RETURNING

          • Major - Major loss of function.
          • Closed

          Activity

            People

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