MySQL Forums
Forum List  »  Partitioning

Re: first partition always
Posted by: Aftab Khan
Date: August 11, 2010 05:44AM

since TO_DAYS() returns NULL values for dates, it must also search the first partition to see if any have occurred. This is why you see it matching 2010_08_01 in the explain, since NULL is considered less than any other positive integer.

You could create a special partition like:

PARTITION invalid_dates VALUES LESS THAN (0)

http://bugs.mysql.com/bug.php?id=49754

Options: ReplyQuote


Subject
Views
Written By
Posted
2860
N N
August 10, 2010 03:29AM
Re: first partition always
1544
August 11, 2010 05:44AM


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.