Comments - System-Versioned Tables

4 years, 4 months ago Cory Collier

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.

4 years, 4 months ago Sergei Golubchik

No, sorry. This is exactly the scenario that system versioning is supposed to prevent. The history is immutable.

Having said that, two more points:

  • you can make one particular column (that stores your sensitive data) non-versioned using WITHOUT VERSIONING clause
  • we might, in a future version, allow direct editing of timestamp fields (very limited, but still). then you'll be able, for example, to all data excluding that one record and get a new table without that one row.
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.