Comments - System-Versioned Tables
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Is there a way to delete history for a specific record? I have a situation where once I delete a record, I'm under contract to remove all records (including historical ones). I don't see that anywhere here.
No, sorry. This is exactly the scenario that system versioning is supposed to prevent. The history is immutable.
Having said that, two more points:
WITHOUT VERSIONING
clause