Re: Prunning partitions with range by date

[Aftab Khan]

>expecting that the list of prunned partitions would contain only "cur_year_sep", but the result was "pre_year,cur_year_sep".

This is a known issue, if you are using MySQL 5.5. You can also use RANGE COLUMNS partitioning without TO_DAYS():

..
PARTITION BY RANGE COLUMNS (`ins_date`)
..

if you are using MySQL 5.1, then catch for invalid dates,
>PARTITION invalid_date VALUES LESS THAN (0)
(Bug#49754: Partitioning by RANGE with TO_DAYS always includes first partition when pruning)