Make LOAD DATA statements support commit and rollback like normal DMLs in a transaction

[ekexium]

Feature Request

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

Consider this,

begin;
load data ...
load data ...
commit; or rollback;

The LOAD DATA statements should not take effect until the surrounding transaction commits or rolls back. But in current TiDB(v7.5), a LOAD DATA statement commits its current transaction, then starts loading data, then commits its content after the statement finishes.
Besides, a LOAD DATA statement can be non-atomic, i.e. it can import part of the data and commits anyway. We would like the statement to be atomic.

Describe the feature you'd like:

Make LOAD DATA statements in transactions behave like normal DMLs.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy: