Auto-drop old history partition for system-versioned tables that use auto-creation

create table t1 (x int) with system versioning

partition by system_time interval 1 hour auto max 24;

create table t1 (x int) with system versioning

partition by system_time interval 1 month auto max 12;

create table t1 (x int) with system versioning

partition by system_time interval 1 hour auto max 24

(partition p0 history, partition pn current);