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

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              igor Igor Babaev
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated: