[MDEV-8563] DELETE ... RETURNING broken with joins Created: 2015-07-30  Updated: 2015-07-30  Resolved: 2015-07-30

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Delete
Affects Version/s: 10.0.20
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Anthony Ryan Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: File delete-join-returning.sql    

 Description   

The newly added DELETE ... RETURNING fails to include support for DELETEs featuring JOINs.

Minimal test case (based off an example in the docs) is attached.

 Comments   
Comment by Anthony Ryan [ 2015-07-30 ]

After re-reading the documentation and trying a few other combinations ORDER BY, LIMIT, etc. It seems that the multi-table syntax doesn't support any of these, so I'm less convinced this is a bug.

Comment by Elena Stepanova [ 2015-07-30 ]

That's right, see MDEV-5872.
There used to be a discrepancy between documentation and the initial task/implementation (MDEV-3814), but it was fixed on the documentation side. RETURNING clause just was not implemented for multi-table updates.

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