Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
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
-
-
- Closed
-
- relates to
-
MDEV-4918 Server crashes in st_select_lex::mark_const_derived on DELETE with ORDER BY and a subquery in RETURNING clause
-
- Closed
-
-
-
- Closed
-
-
MDEV-5092 Implement UPDATE with result set
-
- In Review
-
-
MDEV-20033
sql_mode="oracle" does not support INSERT INTO ... RETURNING
-
- Closed
-
-
-
- Closed
-
(1 relates to)
Activity
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
| 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] SELECT select_expr [, select_expr ...] |
Add a DELETE operations that returns a result set of the deleted rows to the client. Proposed syntax: {noformat} DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [WHERE where_condition] [ORDER BY col_name | expr | position} [ASC | DESC], ...] [LIMIT row_count] RETERNING select_expr [, select_expr ...] {noformat} |
| Description |
Add a DELETE operations that returns a result set of the deleted rows to the client. Proposed syntax: {noformat} DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [WHERE where_condition] [ORDER BY col_name | expr | position} [ASC | DESC], ...] [LIMIT row_count] RETERNING select_expr [, select_expr ...] {noformat} |
Add a DELETE operations that returns a result set of the deleted rows to the client. Proposed syntax: {noformat} 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 ...] {noformat} |
| Fix Version/s | 10.0.2 [ 11900 ] | |
| Fix Version/s | 10.0.1 [ 11400 ] |
| Fix Version/s | 10.0.3 [ 12900 ] | |
| Fix Version/s | 10.0.2 [ 11900 ] |
| Fix Version/s | 10.0.4 [ 13101 ] | |
| Fix Version/s | 10.0.3 [ 12900 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.0.5 [ 13201 ] | |
| Fix Version/s | 10.0.4 [ 13101 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | defaullt [ 24806 ] | MariaDB v2 [ 44291 ] |
| Workflow | MariaDB v2 [ 44291 ] | MariaDB v3 [ 61336 ] |
| Link |
This issue relates to |
| Link |
This issue duplicates |
| Workflow | MariaDB v3 [ 61336 ] | MariaDB v4 [ 132027 ] |
| Link |
This issue is duplicated by |
| Link |
This issue duplicates |
| Link |
This issue relates to |
| Link |
This issue is duplicated by |
pushed in 10.0-base