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

Implement UPDATE with result set

    XMLWordPrintable

Details

    Description

      Add an UPDATE operation that returns a result set of the changed rows to the client.

      UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
      		 
          SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
      		 
          [WHERE where_condition]
      		 
          [ORDER BY ...]
      		 
          [LIMIT row_count]
      		 
      RETURNING select_expr [, select_expr ...]

      I'm not exactly sure how the corresponding multiple-table syntax should look like, or if it is possible at all. But already having it for single-table updates would be a nice feature.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-12326 Implement multiple-table UPDATE/DELETE returning a result set

          • Major - Major loss of function.
          • Open
          duplicates

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

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

          Task - A task that needs to be done. MDEV-30737 REPLACE...RETURNING should provide access to the old row data

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-3814 Implement DELETE with result set (mwl #205)

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10422 INSERT RETURNING

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-12326 Implement multiple-table UPDATE/DELETE returning a result set

          • Major - Major loss of function.
          • Open

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

          • Major - Major loss of function.
          • Closed

          Activity

            People

              danblack Daniel Black
              pprkut Heinz Wiesinger
              Votes:
              15 Vote for this issue
              Watchers:
              29 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.