MariaDB [test]> CREATE OR REPLACE TABLE t (

    ->     label VARCHAR(50) NOT NULL,

    ->

    ->     valid_from TIMESTAMP(6)

    ->         GENERATED ALWAYS AS ROW START,

    ->     valid_to TIMESTAMP(6)

    ->         GENERATED ALWAYS AS ROW END,

    ->     PERIOD FOR SYSTEM_TIME (valid_from, valid_to)

    -> )

    ->     WITH SYSTEM VERSIONING,

    ->     ENGINE CONNECT,

    ->     TABLE_TYPE=CSV,

    ->     FILE_NAME='t.csv'

    -> ;

Query OK, 0 rows affected (0.004 sec)

MariaDB [test]> INSERT INTO t (label) VALUES ('v1');

Query OK, 1 row affected (0.001 sec)

MariaDB [test]> SELECT * FROM t;

Empty set (0.000 sec)

MariaDB [test]> SELECT * FROM t FOR SYSTEM_TIME ALL;

+-------+----------------------------+----------------------------+

| label | valid_from                 | valid_to                   |

+-------+----------------------------+----------------------------+

| v1    | 2018-10-15 22:40:26.000000 | 2038-01-19 03:14:07.000000 |

+-------+----------------------------+----------------------------+

1 row in set (0.001 sec)

MariaDB [test]> UPDATE t SET label = 'v2';

Query OK, 0 rows affected (0.000 sec)

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

MariaDB [test]> SELECT * FROM t;

Empty set (0.000 sec)

MariaDB [test]> SELECT * FROM t FOR SYSTEM_TIME ALL;

+-------+----------------------------+----------------------------+

| label | valid_from                 | valid_to                   |

+-------+----------------------------+----------------------------+

| v1    | 2018-10-15 22:40:26.000000 | 2038-01-19 03:14:07.000000 |

+-------+----------------------------+----------------------------+

1 row in set (0.000 sec)

MariaDB [test]> DELETE FROM t WHERE label = 'v1';

ERROR 1194 (HY000): Table 't' is marked as crashed and should be repaired

MariaDB [test]> SELECT * FROM t;

Empty set (0.000 sec)

MariaDB [test]> SELECT * FROM t FOR SYSTEM_TIME ALL;

+-------+----------------------------+----------------------------+

| label | valid_from                 | valid_to                   |

+-------+----------------------------+----------------------------+

| v1    | 2018-10-15 22:40:26.000000 | 2038-01-19 03:14:07.000000 |

+-------+----------------------------+----------------------------+

1 row in set (0.003 sec)