The Ultimate Guide to High Availability with MariaDB

Comments - System-Versioned Tables

5 years, 10 months ago Sergei Golubchik
Re: System-Versioned Tables

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 insert...select 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.