[15721] Schema Change Final PR - Githubissues

cmu-db / peloton

The Self-Driving Database Management System

http://pelotondb.io

Apache License 2.0

2.03k stars 623 forks source link

[15721] Schema Change Final PR #1366

Open DeanChensj opened 6 years ago

DeanChensj commented 6 years ago

Overview:

Blocking schema changes implementation for Add/Drop column, Rename column, and Alter column type.
Junit test for ALTER TABLE / Rename operations.
Benchmark to compare ALTER TABLE performance against Postgress & MySQL.
Bugs fix and addressed previous comments.

Eg queries:

ALTER TABLE table_name ADD COLUMN column_name column_type, DROP column_name, ALTER column_name column_type;
ALTER TABLE table_name RENAME column_name TO column_name;

Known issues:

In wait-based txn management, per-table lock is need within alter_executor
Mulit-txn bugs as mentioned in issues @1356, can be fixed by merging pr @1327.
Dropping the last column in the table will crash the pelton.
Foreign Key constraints need to be addressed in the future work.

coveralls commented 6 years ago

Coverage decreased (-0.9%) to 76.666% when pulling 19eac34cbc0eafdf75150b187b8918926addd37e on sxzh93:final into 5686479c5f33087031e1b68b7832245c7886b712 on cmu-db:master.