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

Implement multiple-table UPDATE/DELETE returning a result set

    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:
                igor Igor Babaev
                Reporter:
                igor Igor Babaev
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated: