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:

And please look at Sergey Petrunia's blog about partitioning pruning optimizations:

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

Written By
Re: Query problem with date partitioning
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.