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

Implement DELETE with result set (mwl #205)

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.5
    • None
    • None

    Description

      Add a DELETE operations that returns a result set of the deleted rows to the client.

      Proposed syntax:

      DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
      		 
          [WHERE where_condition]
      		 
          [ORDER BY col_name | expr | position} [ASC | DESC], ...]
      		 
          [LIMIT row_count]
      		 
      RETURNING select_expr [, select_expr ...]

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-4907 merge 5.5 → 10.0-base → 10.0

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4918 Server crashes in st_select_lex::mark_const_derived on DELETE with ORDER BY and a subquery in RETURNING clause

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4919 Packets out of order on a SELECT after calling a procedure with DELETE .. RETURNING

          • Major - Major loss of function.
          • Closed

          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.
          • In Review

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

          • Major - Major loss of function.
          • Closed

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

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Igor Babaev (Inactive) made transition -
            In Progress Open
            		21h 40m 7
            Igor Babaev (Inactive) made transition -
            Open In Progress
            		290d 16h 31m 8
            Igor Babaev (Inactive) made transition -
            In Progress Stalled
            		4h 49m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		10d 10h 55m 1

            People

              igor Igor Babaev (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.