Altering a table to extend partition range fails with error 3732

Database
Enthusiast

Altering a table to extend partition range fails with error 3732

Hi, I'm getting following error when I run alter table statement to add/extend partition range:

3732: The facility of altering the partitioning of a non-empty table by adding/dropping partitions other than partitions at the beginning or end of a RANGE_N partitioning expression at partitioning level one has not been implemented

Im using TD v13.10 - alter table statement and DDL of one of the tables I'm trying to extend are as follows:

alter table tablex modify primary index

add range between date '2013-01-01' and date '2015-12-31' each interval '1' month;

CREATE MULTISET TABLE TABLEX ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      COL_ID BIGINT NOT NULL,

      COL2 DATE FORMAT 'YYYY-MM-DD' NOT NULL,

      COL3 DATE FORMAT 'YYYY-MM-DD' NOT NULL DEFAULT DATE '9999-12-31',

      COL4 TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),

      COL5 DATE FORMAT 'YYYY-MM-DD' COMPRESS (DATE '2005-07-16'),

      COL6 DATE FORMAT 'YYYY-MM-DD' COMPRESS ,

      COL7 CHAR(2) CHARACTER SET LATIN CASESPECIFIC COMPRESS (,

      COL7 CHAR(3) CHARACTER SET LATIN CASESPECIFIC COMPRESS ('UN ','WM ','ZB ','ZC ','ZD ','ZO '),

      COL8 CHAR(1) CHARACTER SET LATIN CASESPECIFIC COMPRESS 'P')

PRIMARY INDEX ( COL1 )

PARTITION BY RANGE_N(COL3  BETWEEN DATE '2000-01-01' AND '2012-12-31' EACH INTERVAL '1' MONTH ,

DATE '9999-12-31' AND '9999-12-31');