Support delete sql

[lewiszlw]

No description provided.

[Tianpingan]

I am working on it

[geofmureithi]

@Tianpingan Any update on this?

[lewiszlw]

I think he didn't work on this. Feel free to take this issue if you have interest.

[geofmureithi]

@lewiszlw could you provide a basic idea of what I should look for and work on. A tasklist might also be good.

[lewiszlw]

@geofmureithi I haven't worked on this project for about 7 months (I just don't have much time), these are something I can think of now.

• Convert delete ast to logical plan
• Convert delete logical plan to physical plan
• Buffer pool manager supports delete tuple from a page (we might need a solution to reuse these freed space)
• Update btree if needed

You can refer to cmu bustub:

1. https://github.com/cmu-db/bustub/blob/master/src/planner/plan_insert.cpp#L42
2. https://github.com/cmu-db/bustub/blob/master/src/execution/delete_executor.cpp

If you have some better ideas, welcome to communicate with me.