create or replace table t1 (x int)

with system versioning

partition by system_time (

partition p0 history,

partition pn current);

insert into t1 values (1);

explain partitions select * from t1;

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

| id   | select_type | table | partitions | type | possible_keys | key  | key_len | ref  | rows | Extra       |

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

|    1 | SIMPLE      | t1    | p0,pn      | ALL  | NULL          | NULL | NULL    | NULL |    2 | Using where |

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