Re: This partition function is not allowed

2012-01-27 Thread Johan De Meersman
- Original Message - > From: "Adarsh Sharma" > > Is it possible I upgrade to higher version 5.5 with existing data Yes, look for the upgrade notes in the online documentation. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een eze

This partition function is not allowed

2012-01-26 Thread Adarsh Sharma
HAN ( UNIX_TIMESTAMP('2012-11-01 00:00:00') ), -> PARTITION p10 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-12-01 00:00:00') ), -> PARTITION p11 VALUES LESS THAN (MAXVALUE) -> ); ERROR 1564 (HY000): This partition function is not allowed After some Rn D