[MDEV-10114] Correlation names for delete Created: 2016-05-24 Updated: 2016-05-25 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Delete, Parser |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Nicholas Denning | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
In almost all circumstances you can use a correlation name as a short cut to a table name for example MT in the following query
However it looks like you cannot use a correlation name on a delete statement in mariadb so the following generates an error.
You can use a correlation name in this manner in most other databases. This is not that big an issue, but an irritation. |