MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.3.39-MariaDB-1:10.3.39+maria~deb10-log

-- system-versioned tables arrived in MariaDB 10.3
create table price (item varchar(10), amount int) with system versioning;
insert into price values ('widget',10);
update price set amount = 12 where item = 'widget';

Rows matched: 1  Changed: 1  Inserted: 1  Warnings: 0

select item, amount from price;

item
amount

widget
12

-- the superseded row is still there, in history
select item, amount from price for system_time all order by amount;

item
amount

widget
10

widget
12