All Forums Database
cursavas 2 posts Joined 02/13
26 Jun 2013
CPPI question

Hello,
I am trying to add a range to my CPPI column but get this error when I run the alter table statement:
 'Executed as Single statement.  Failed [5731 : HY000] TBL_ADD_PARTITIONS_FOR_PERIOD:DROP RANGE and ADD RANGE for level 1 are not allowed; partitioning expression, if any, at that level is not a RANGE_N function or involves comparison of character or graphic data'
Below are my statements:

CREATE MULTISET TABLE TestTable 

(Column1 varchar(50),

Column2 varchar(250))

PRIMARY INDEX TestTable (Column1)

partition by (range_n(Column2 between 'a' and 'b', NO RANGE ));

 

Alter Table TestTable Modify PRIMARY INDEX ADD RANGE BETWEEN 'c' and 'd'

 

I am using version 13.10.

Do you know how I can resolve the above error?

Thanks

Cenk

Tags:
Fred 1096 posts Joined 08/04
26 Jun 2013

Making this change via ALTER is not supported for character PPI.
Create a new table and copy the data.

You must sign in to leave a comment.