For the tables with transaction precise history cannot put history data into own partition(s).

Meaning the maintenance and cleanup of the huge tables is unefficient and very heavy task.

Meaning in turn transaction precise history is not really usable feature for production environment:

MariaDB [db]> CREATE TABLE t(
-> x INT,
-> start_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW START,
-> end_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW END,
-> PERIOD FOR SYSTEM_TIME(start_trxid, end_trxid)
-> ) WITH SYSTEM VERSIONING
-> PARTITION BY SYSTEM_TIME LIMIT 100000 (
-> PARTITION p_hist HISTORY,
-> PARTITION p_cur CURRENT
-> );
ERROR 4110 (HY000): `start_trxid` must be of type TIMESTAMP(6) for system-versioned table `t`