Re: particular field type not allowed to this type of partitioning

[Mattias Jonsson]

In 5.5 you can also use RANGE COLUMNS partitioning without TO_DAYS():
PARTITION BY RANGE COLUMNS (fldassigndate)
(PARTITION p_Apr VALUES LESS THAN ('2012-05-01'),
PARTITION p_May VALUES LESS THAN ('2012-06-01'),
PARTITION p_Nov VALUES LESS THAN MAXVALUE );