MySQL Forums
Forum List  »  Partitioning

Re: Prunning partitions with range by date
Posted by: Aftab Khan
Date: September 27, 2012 01:39PM

>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)

Options: ReplyQuote


Subject
Views
Written By
Posted
2909
September 27, 2012 01:18PM
Re: Prunning partitions with range by date
1760
September 27, 2012 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.