--source include/have_innodb.inc

--source include/have_partition.inc

SET SESSION TIME_ZONE= '+00:00';

CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY KEY() PARTITIONS 2;

INSERT INTO t1 VALUES (1),(2);

SELECT pk, row_end FROM t1;

DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME '2039-01-01';

SELECT pk FROM t1;

SELECT pk FROM t1 FOR SYSTEM_TIME ALL;

DROP TABLE t1;

MariaDB [test]> DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME '2039-01-01';

Query OK, 2 rows affected (0.003 sec)

MariaDB [test]> SELECT pk FROM t1;

Empty set (0.000 sec)

MariaDB [test]> SELECT pk FROM t1 FOR SYSTEM_TIME ALL;

+----+

| pk |

+----+

|  1 |

|  2 |

+----+

2 rows in set (0.000 sec)

MariaDB [test]> DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME '2039-01-01';

Query OK, 4 rows affected (0.002 sec)

MariaDB [test]> SELECT pk FROM t1;

Empty set (0.000 sec)

MariaDB [test]> SELECT pk FROM t1 FOR SYSTEM_TIME ALL;

Empty set (0.000 sec)

MariaDB [test]> DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME '2039-01-01';

Query OK, 3 rows affected (0.008 sec)

MariaDB [test]> SELECT pk FROM t1;

Empty set (0.000 sec)

MariaDB [test]> SELECT pk FROM t1 FOR SYSTEM_TIME ALL;

+----+

| pk |

+----+

|  1 |

+----+

1 row in set (0.000 sec)