MySQL Forums
Forum List  »  Partitioning

Re: Query problem with date partitioning
Posted by: Mattias Jonsson
Date: May 23, 2008 02:35PM

There was recently a bug report almost like this:
http://bugs.mysql.com/bug.php?id=36604

And please look at Sergey Petrunia's blog about partitioning pruning optimizations:
http://s.petrunia.net/blog/?p=21

Currently the partitioning and optimizer does not support range pruning on any partitioning type other than 'range'. (there is no range analysis even for unary and monotonic functions for checking if it gives the same result in this case).

Regard Mattias Jonsson
Sun/MySQL software engineer, working with the partitioning code.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query problem with date partitioning
2449
May 23, 2008 02:35PM


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.