[MDEV-3814] Implement DELETE with result set (mwl #205) Created: 2012-10-19  Updated: 2023-10-18  Resolved: 2013-08-17

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.0.5

Type: Task Priority: Major
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-4907 merge 5.5 → 10.0-base → 10.0 Closed
Relates
relates to MDEV-4918 Server crashes in st_select_lex::mark... Closed
relates to MDEV-4919 Packets out of order on a SELECT afte... Closed
relates to MDEV-5092 Implement UPDATE with result set In Review
relates to MDEV-20033 sql_mode="oracle" does not support IN... Closed
relates to MDEV-10422 INSERT RETURNING Closed

 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 ...]



 Comments   
Comment by Sergei Golubchik [ 2013-08-16 ]

pushed in 10.0-base

Generated at Thu Feb 08 06:51:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.