Re: Query problem with date partitioning
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.
Subject
Views
Written By
Posted
4274
May 22, 2008 04:39PM
2830
May 22, 2008 09:08PM
2783
May 23, 2008 06:42AM
3398
May 23, 2008 11:44AM
Re: Query problem with date partitioning
2494
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.