Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
A multiple-table UPDATE first performs join operations, then it updates the matching rows.
A multiple-table UPDATE returning a result set does the following:
- first performs join operations
- for each row of the result of the join it calculates some expressions over the columns of the join and forms from them a row of the returned result set
- after this it updates the matching rows
A multiple-table DELETE first performs join operations, then it deletes the matching rows.
A multiple-table DELETE returning a result set does the following:
- first performs join operations
- for each row of the result of the join it calculates some expressions over the columns of the join and forms from them a row of the returned result set
- after this it deletes the matching rows
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is blocked by
-
MDEV-5092 Implement UPDATE with result set
-
- In Review
-
- relates to
-
-
- In Review
-
-
-
- Closed
-
-
MDEV-20033
sql_mode="oracle" does not support INSERT INTO ... RETURNING
-
- Closed
-
Activity
Hi Khaled,
A student tried to implement this for GSoc19, but the attempt was not successful though the task was not harder than INSERT ... RETURNING (see MDEV-10014) that was implemented by another student and finally incorporated into MariaDB. You can look at the implementation of MDEV-10014 to figure out how much work it would be to implement UPDATE ... RETURNING.
Greetings! I'm Hammaad, it is really interesting to know how MDEV-10014 was implemented, thank you @Igor Babaev for the information, I'd like to receive some more hints on this topic if available, as it will help me and Khaled as well.
Moreover I would love to contribute to solve this requirement.
Thanks
Hi Hammaad,
Have you built MariaDB server from the tree git@github.com:MariaDB/server.git?
If so, have you checked in debugger how INSERT ... RETURNING works?
Greetings! Yes, I've built the Awesome Maria DB server. Working on MDEV-14558 currently, once done will surely look upon MDEV-10014.
Hi,
I'm Khaled from Egypt. I'm interested in participating in GSoC this year. Any reason this project hasn't been picked up the previous years? Seems like it garnered enough attention from students. Did Google refuse the proposals?
Anyways, so to clarify: This project is about implementing the RETURNING statement for multiple tables UPDATE/DELETE? Or rather implement the the UPDATE/DELETE itself with - of course - RETURNING?
I have downloaded and built MariaDB server. Is there any qualification tasks?