Re: Add new partition for Range by date

[Aftab Khan]

to_days() returns NULL for non-valid dates (like 2011-04-31). (See bug#49754).

I suggest you to try 'PARTITION BY RANGE COLUMNS (date)' (in MySQL 5.5) instead.

OR add extra partition to it:

ALTER TABLE idea_partition
reorganize partition rx201201 INTO (
partition invalid_dates values less than (0),
partition rx201201 VALUES LESS THAN( TO_DAYS('2012-01-01 00:00:00'))
);