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
Subject
Views
Written By
Posted
2810
August 10, 2010 03:29AM
Re: first partition always
1522
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.