[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

SELECT MT.*
FROM MYTABLE MT
WHERE MT.MYKEY = 5;

However it looks like you cannot use a correlation name on a delete statement in mariadb so the following generates an error.

DELETE FROM MYTABLE MT
WHERE MT.KEY = 5;

You can use a correlation name in this manner in most other databases.

This is not that big an issue, but an irritation.


Generated at Thu Feb 08 07:39:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.