Support Optimize on non-append-only tables

[wjones127]

Description

We note here that optimize only works on append-only tables. We should get it to work for all tables.

delta-rs/rust/src/optimize.rs

Lines 7 to 8 in 2c66b19

	//! *WARNING:* Currently Optimize only supports append-only workflows. Use with
	//! other workflows may corrupt your table state.

Use Case

Related Issue(s)

[Matthieusalor]

Do we have more details on scenarios where the table might get corrupted besides when the table uses deletion vectors ?

[roeap]

Don't quite remember what the specific issue was when this was created. My assumption would be that the corruption was due to the fact that we were not doing conflict resolution on failing commits. This would not have been an issue for append only tables.

Since then we added conflict resolution, but not sure if that is in the latest python release. So i think this could be resolved now.

[wjones127]

I think we can consider this fixed by #632, but we need to update the documentation for Optimize, since it currently claims it could corrupt tables.