MySQL Forums
Forum List  »  Partitioning

Re: Mystified by Partition Pruning on Dates
Posted by: Rick James
Date: May 20, 2010 07:58AM

In the second case, change
WHERE col2 = DATE('2010-02-02');
to
WHERE col2 = '2010-02-02;
MySQL does not optimize functions.

I see that you did that on the first one; I can't explain it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mystified by Partition Pruning on Dates
1762
May 20, 2010 07:58AM


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.