ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

[Chaya Shindhe]

Hi,

I'm trying to create a partition table
CREATE TABLE TEST
(
ID INT NOT NULL AUTO_INCREMENT,
SETG_DATE TIMESTAMP NOT NULL DEFAULT now(),
PRIMARY KEY (ID,SETG_DATE)
)
ENGINE=INNODB
PARTITION BY RANGE (TO_DAYS(SETG_DATE))
(
PARTITION MONTH_NULL VALUES LESS THAN (0),
PARTITION JAN VALUES LESS THAN (TO_DAYS('2010-01-01')),
PARTITION FEB VALUES LESS THAN (TO_DAYS('2010-03-01')),
PARTITION MARCH VALUES LESS THAN (TO_DAYS('2010-04-01')),
PARTITION APRIL VALUES LESS THAN (TO_DAYS('2010-05-01')),
PARTITION MAY VALUES LESS THAN (TO_DAYS('2010-06-01')),
PARTITION JUNE VALUES LESS THAN (TO_DAYS('2010-07-01')),
PARTITION JULY VALUES LESS THAN (TO_DAYS('2010-08-01')),
PARTITION AUG VALUES LESS THAN (TO_DAYS('2010-09-01')),
PARTITION SEP VALUES LESS THAN (TO_DAYS('2010-10-01')),
PARTITION OCT VALUES LESS THAN (TO_DAYS('2010-11-01')),
PARTITION NOV VALUES LESS THAN MAXVALUE
);

I'm able to create this partitioned table in "Server version: 5.1.41-log MySQL Community Server (GPL)"

But its throwing the error "ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed" when im trying to do it in "Server version: 5.1.43 MySQL Community Server (GPL)"

Can you please provide me the solution as soon as possible.