txn:make amended transaction semantic compatible

[cfzjywxk]

Feature Request

Is your feature request related to a problem? Please describe:

The transaction amend may indrocude some incompatilities, we need to solve these issues for specific amend type.

Issues like:

• Amend transaction can cause lost update #20912. For add column amend type, since the newest value on the added column will not be recorded in the amended transaction memory buffer, the amend will overwrite the newest written data, which causes lost update.

Describe the feature you'd like:

Make the amended transaction semantic compatible.

Describe alternatives you've considered:

We need to consider if memory buffer amend is needed under certain circumstances. Also, we need to evaluate the risk and benefit.

Teachability, Documentation, Adoption, Migration Strategy:

Check the amend project and sig-transaction for more information.

[Defined2014]

The amend txn is deprecated in v6.5.0. There should be no any progress on this issue, so close it.